RPM Repository

This page helps you configure the CYBERTEC PostgreSQL Enterprise Edition (PGEE) RPM repository.

Several repositories are hosted here:

PostgreSQL Enterprise Edition (PGEE) full version
PostgreSQL Enterprise Edition (PGEE) free public demo version
PostgreSQL Transparent Data Encryption (TDE) full version

PGEE includes TDE and more features.

Available Packages

PostgreSQL 16 Enterprise Edition: postgresql16-ee-server (not on RHEL 7)
PostgreSQL 15 Enterprise Edition: postgresql15-ee-server
PostgreSQL 14 Enterprise Edition: postgresql14-ee-server
PostgreSQL 15 Transparent Data Encryption: postgresql15-tde-server
PostgreSQL 14 Transparent Data Encryption: postgresql14-tde-server
PostgreSQL 13 Transparent Data Encryption: postgresql13-tde-server
PostgreSQL 12 Transparent Data Encryption: postgresql12-tde-server

Supported Distributions

RedHat RHEL 9 and derivatives
RedHat RHEL 8 and derivatives
RedHat RHEL 7 and derivatives
SUSE SLES 15

Repository Configuration

Disable Built-In Modules

On RedHat 8 and later, disable the built-in postgresql module:

sudo dnf module disable -y postgresql

Public PGEE Demo Version Repository

Free to use, limited to 100 MB per table

version=16 # available: 14 15 16

# RedHat/CentOS
sudo tee /etc/yum.repos.d/cybertec-pg$version.repo <<EOF
[cybertec_pg$version]
name=CYBERTEC PostgreSQL $version for RHEL/CentOS \$releasever - \$basearch
baseurl=https://repository.cybertec.at/public/$version/redhat/\$releasever/\$basearch
gpgkey=https://repository.cybertec.at/assets/cybertec-rpm.asc
enabled=1
EOF

# SUSE SLES
sudo tee /etc/zypp/repos.d/cybertec-pg$version.repo <<EOF
[cybertec_pg$version]
name=CYBERTEC PostgreSQL $version for SLES \$releasever_major - \$basearch
baseurl=https://repository.cybertec.at/public/$version/sles/\$releasever_major/\$basearch
gpgkey=https://repository.cybertec.at/assets/cybertec-rpm.asc
enabled=1
EOF

Full PGEE Version Repository

Unlimited version - contact CYBERTEC for a quote

version=16 # available: 14 15 16
username="YOUR_LOGIN"
password="YOUR_PASSWORD"

# RedHat/CentOS
sudo tee /etc/yum.repos.d/cybertec-pg$version.repo <<EOF
[cybertec_pg$version]
name=CYBERTEC PostgreSQL $version for RHEL/CentOS \$releasever - \$basearch
baseurl=https://repository.cybertec.at/pgee/$version/redhat/\$releasever/\$basearch
gpgkey=https://repository.cybertec.at/assets/cybertec-rpm.asc
username=$username
password=$password
enabled=1
EOF

# SUSE SLES
sudo tee /etc/zypp/repos.d/cybertec-pg$version.repo <<EOF
[cybertec_pg$version]
name=CYBERTEC PostgreSQL $version for SLES \$releasever_major - \$basearch
baseurl=https://$username:$password@repository.cybertec.at/pgee/$version/sles/\$releasever_major/\$basearch
gpgkey=https://repository.cybertec.at/assets/cybertec-rpm.asc
enabled=1
EOF

Full TDE Version Repository

Unlimited version - contact CYBERTEC for a quote

Note: We are phasing out the TDE packages; existing customers are encouraged to switch to PGEE. See below for migration instructions.

version=15 # available: 12 13 14 15
username="YOUR_LOGIN"
password="YOUR_PASSWORD"

sudo tee /etc/yum.repos.d/cybertec-pg$version.repo <<EOF
[cybertec_pg$version]
name=CYBERTEC PostgreSQL $version for RHEL/CentOS \$releasever - \$basearch
baseurl=https://repository.cybertec.at/non-public/$version/redhat/\$releasever/\$basearch
username=$username
password=$password
enabled=1
gpgcheck=0
EOF

Install Packages

sudo yum install -y postgresql15-ee-server
sudo yum install -y postgresql15-tde-server

Create Encrypted Cluster

To create an encrypted cluster, set up an encryption key, and create a new cluster:

KEY=$(dd if=/dev/random bs=1k count=1 | md5sum - | cut -d ' ' -f 1)
PATH=/usr/pgsql-15-tde/bin:/usr/pgsql-15/bin:$PATH

initdb -D /var/lib/pgsql/15/data -k -K "echo $KEY"
pg_ctl -D /var/lib/pgsql/15/data start
psql

Note: The cluster created here uses an encryption key that is stored inside postgresql.conf. Other more secure key retrieval methods can be configured; talk to CYBERTEC about which method fits your security requirements best.

Migrate from TDE to PGEE

To migrate from the TDE packages to the PGEE packages, use pg_upgrade.

For example, when starting with 13 TDE moving to 15 EE, install 15 EE as above, then:

initdb -D /var/lib/pgsql/15/data -k -K "echo $KEY" # same key
/usr/pgsql-15/bin/pg_upgrade -b /usr/pgsql-13-tde/bin/ \
    -d /var/lib/pgsql/13/data -D /var/lib/pgsql/15/data