PostgreSQL 14 beta 2 is released. As written in the announcement, "In the spirit of the open source PostgreSQL community, we strongly encourage you to test the new features of PostgreSQL 14 in your systems to help us eliminate bugs or other issues that may exist."

So, let's install it!
RPMs are out for the following platforms:

- RHEL / Rocky Linux / Oracle Linux 8 (x86_64 and ppc64le)
- RHEL / CentOS / Oracle Linux 7 (x86_64 and ppc64le)
- Fedora 34 and 33
- SLES 15 SP2
- SLES 12 SP5

There will probably be at least another beta, and definitely at least an RC, so please join us in testing this upcoming new release. PostgreSQL 14 RPMs are in “testing” repositories, so you need to manually enable those v14 testing repos for beta and RC versions.

Enabling PostgreSQL 14 testing repos on RHEL/Rocky Linux / Fedora / Oracle Linux

If you have not already installed PostgreSQL PGDG repo RPMs , first install the repo rpm based on the OS and architecture.

To enable PostgreSQL 14 testing repos, run the following:

- RHEL/Rocky/Oracle Linux 8 and Fedora 33+ (you may need to install dnf-plugins-core package first):
dnf config-manager --enable pgdg14-updates-testing

- RHEL/CentOS/Oracle Linux 7 (you may need to install yum-utils package first) :
yum-config manager --enable pgdg14-updates

Enabling PostgreSQL 14 testing repos on SLES 15 and SLES 12

Run these commands on SLES 15 or 12:

- SLES 15:
zypper addrepo
- SLES 12:
zypper addrepo

To enable v14 testing repo, first find repository id with the following command:

zypper lr | grep pgdg-14-updates-testing

And enable it with:

zypper mr -e Repository_ID

An example output:

Installing PostgreSQL 14 RC/Beta

Now that the repositories are enabled, we can install PostgreSQL 14:

- RHEL/Rocky/Oracle Linux 8 and Fedora 33+: dnf install postgresql14-server postgresql14-contrib

- RHEL/CentOS/Oracle Linux 7: yum install postgresql14-server postgresql14-contrib

- SLES 15 and 12: zypper install postgresql14-server postgresql14-contrib

Initializing the cluster

This is same for all distros:

postgresql-14-setup initdb

This command will initialize the cluster under /var/lib/pgsql/14/data directory.

Tip: If you have multiple clusters running on the same server, change the port by editing postgresql.conf.

Starting the cluster

systemctl enable --now postgresql-14

If you find any bugs, please report it via PostgreSQL bug report form.


No comments

The author does not allow comments to this entry