PostgreSQL 13 Beta 2: it’s your time to help testing!

We are approaching very quickly (and on time) the PostgreSQL 13 version, and we all can help testing it to provide a feedback and get ready for the next version.
As I’ve often written, a very easy approach to install and test the new version along side the version you are using (but not in production!) is by means of pgenv.
The only thing you have to do is pgenv build 13beta2, or if you are more curious:
luca@miguel ~ % pgenv available 13
             Available PostgreSQL Versions

                     PostgreSQL 13
     13beta1  13beta2 

luca@miguel ~ % pgenv build 13beta2
PostgreSQL, contrib, and documentation installation complete.
pgenv configuration written to file /home/luca/git/pgenv/.pgenv.13beta2.conf
PostgreSQL 13beta2 built

Once the system has been compiled, you can start it and use it:
luca@miguel ~ % pgenv use 13beta2           

  your PATH enrvironemnt variable does not seem to include


  as an entry. You will not be able to use the currently
  selected PostgreSQL binaries.

  adjust your PATH variable to include


  for instance

  export PATH=/home/luca/git/pgenv/pgsql/bin:$PATH

Already using PostgreSQL 13beta2
waiting for server to start.... done
server started
PostgreSQL 13beta2 started
Logging to /home/luca/git/pgenv/pgsql/data/server.log

As the pgenv output suggests, it is better to modify your PATH to get the new executables:
luca@miguel ~ % export PATH=/home/luca/git/pgenv/pgsql/bin:$PATH

and you can make this a permanent change in your shell configuration.

Now, let’s connect to the cluster:

luca@miguel ~ % psql -U postgres template1 -c 'SHOW server_version;'
(1 row)

luca@miguel ~ % psql -U postgres template1 -c 'SELECT version();'   
 PostgreSQL 13beta2 on x86_64-unknown-freebsd12.1, compiled by gcc (FreeBSD Ports Collection) 9.2.0, 64-bit
(1 row)

Happy testing!

The article PostgreSQL 13 Beta 2: it's your time to help testing! has been posted by Luca Ferrari on July 13, 2020