CentOS (EL-8) - PostgreSQL 12

Step 1:

Download the repository file and Crunchy Data's public GPG key (RPM-GPG-KEY-crunchydata-dev)

Step 2:

Download Crunchy Data's public key file RPM-GPG-KEY-crunchydata-dev and validate the authenticity of the key using an md5sum against the key:

md5sum RPM-GPG-KEY-crunchydata-dev

The output should match: c85d895b58f451ee0aaf5056cfd4ba4e

NOTE: If the output does not match, then the public key is invalid and Crunchy Data should be contacted immediately!

Step 3:

Move the verified GPG key to this directory:

/etc/pki/rpm-gpg

Step 4:

Put the repository file here:

/etc/yum.repos.d/crunchypg12.repo

Step 5:

Verify the repository line is in your repolist (@crunchydatadevpg12):

sudo dnf repolist

Step 6:

Install EPEL repositories:

sudo dnf install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm

Step 7:

Because of the modularity feature in CentOS 8, disable the PostgreSQL module:

sudo dnf -qy module disable postgresql

Step 8:

Verify the packages are available to your system (@crunchydatadevpg12 entry in their rightmost column):

sudo dnf list postgresql12

Step 9:

Install PostgreSQL:

sudo dnf install postgresql12\*