Installing PostgreSQL client utility
You need to install this utility to protect the following databases:
Azure PostgreSQL Single and Flexible server
AWS RDS PostgreSQL
AWS RDS Aurora PostgreSQL
GCP PostgreSQL
The utility version must be the same or higher than the server version.
For server version 16, the recommended version of the PostgreSQL client utility is 16.9.
For server version 17, the recommended version of the PostgreSQL client utility is 17.5.
Server version 16 | Bin | |
Lib | ||
Server version 17 | Bin | |
Lib |
To install, do the following:
- Navigate to
/usr/openv/dbpaas. If thedbpaasfolder does not exist, run the command mkdir dbpaas to create the folder. - Create the
postgresqlfolder inside the/usr/openv/dbpaasfolder. Run the command mkdir postgresql inside/usr/openv/dbpaas.For server version 16, create the folder
16inside the/usr/openv/dbpaas/postgresqlfolder. Run the command mkdir 16 inside the/usr/openv/dbpaas/postgresqlfolder.For server version 17, create the folder
17inside the/usr/openv/dbpaas/postgresqlfolder. Run the command mkdir 17 inside the/usr/openv/dbpaas/postgresqlfolder.
- Download the utilities as follows:
For server version 16, go to the
16folder, and run the command:For bin
wget https://download.postgresql.org/pub/repos/ yum/16/redhat/rhel-9-x86_64/postgresql16-16.9- 3PGDG.rhel9.x86_64.rpm
For lib
wget https://download.postgresql.org/pub/repos/ yum/16/redhat/rhel-9-x86_64/postgresql16-libs-16.9 -3PGDG.rhel9.x86_64.rpm
For server version 17, go to the
17folder, and run the command:For bin
wget https://download.postgresql.org/pub /repos/ yum/17/redhat/rhel-9-x86_64/postgresql17-17.5- 3PGDG.rhel9.x86_64.rpm
For lib
wget https://download.postgresql.org/pub/repos/ yum/17/redhat/rhel-9-x86_64/postgresql17-libs- 17.5-3PGDG.rhel9.x86_64.rpm
- To install, run the commands:
For version 16 Lib:
rpm2cpio /usr/openv/dbpaas/postgresql/16/postgresql16- libs-16.9-3PGDG.rhel9.x86_64.rpm | bsdtar -xv --strip-components=3 -f - -C /usr/openv/dbpaas/postgresql/16 'usr/pgsql-16/lib/libpq.so*'
For version 16 Bin:
rpm2cpio /usr/openv/dbpaas/postgresql/16/postgresql16-16.9-3PGDG.rhel9.x86_64.rpm | bsdtar -xv --strip-components=3 -f - -C /usr/openv/dbpaas/postgresql/16 'usr/pgsql-16/bin/pg_dump' 'usr/pgsql-16/bin/pg_dumpall' 'usr/pgsql-16/bin/psql' 'usr/pgsql-16/bin/pg_restore' 'usr/pgsql-16/bin/createdb' 'usr/pgsql-16/bin/dropdb'
For version 17 Lib:
rpm2cpio /usr/openv/dbpaas/postgresql/17/postgresql17-libs-17.5-3PGDG.rhel9.x86_64.rpm | bsdtar -xv --strip-components=3 -f - -C /usr/openv/dbpaas/postgresql/17 'usr/pgsql-17/lib/libpq.so*'
For version 17 Bin:
rpm2cpio /usr/openv/dbpaas/postgresql/17/postgresql17-17.5-3PGDG.rhel9.x86_64.rpm | bsdtar -xv --strip-components=3 -f - -C /usr/openv/dbpaas/postgresql/17 'usr/pgsql-17/bin/pg_dump' 'usr/pgsql-17/bin/pg_dumpall' 'usr/pgsql-17/bin/psql' 'usr/pgsql-17/bin/pg_restore' 'usr/pgsql-17/bin/createdb' 'usr/pgsql-17/bin/dropdb'