Using pgEdge Enterprise Postgres Packages

After installing the pgedge repository, you're ready to create Postgres databases and install supporting components. If needed, modify the sample commands that follow to use your preferred package manager.

Then, to review a list of packages available from the pgedge repository, use the command:

dnf repoquery --available --repo=pgedge

To see a list of components installed by a specific package, use the command:

repoquery -l package_name

To install a package, you can use conventional syntax and options:

sudo dnf install package_name

For example, to install only those packages required to set up a Postgres 17 database, use the command:

sudo dnf install pgedge-enterprise-postgres_17

Installed File Locations

When you install a package, binaries are placed in /usr/pgsql-17/bin. You may wish to add /usr/pgsql-17/bin to your $PATH variable in /etc/profile for easy access to supported components and Postgres utilities.

The packages install files in the following locations:

Installing pgEdge Enterprise Postgres and Initializing a Database

To install pgEdge Enterprise Postgres and supporting component packages (like pgAdmin, pgBouncer, and pgBackRest), use the command:

sudo dnf install pgedge-enterprise-all_17

After installing the packages, you can initialize a Postgres 17 database by assuming the root identity and invoking the command:

postgresql-17-setup initdb

Then, start the Postgres server; as root, use the command:

systemctl start postgresql-17.service

To configure the Postgres server to autostart with system reboots, use the following command:

systemctl enable postgresql-17.service

These commands expect the service to be on the localhost, listening on port 5432. To confirm that the service is working, you can connect with psql and query the server:

sudo -u postgres ./psql -U postgres -p 5432
psql (17.5)
Type "help" for help.
 
postgres=# SELECT version();
  version                                                  
-------------------------------
 PostgreSQL 17.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-5), 64-bit
(1 row)

Installation of the server package creates a database user named postgres. This user has no default password. To set a password for the postgres user, use the Postgres ALTER ROLE (opens in a new tab) command. For example:

postgres=# ALTER ROLE postgres PASSWORD '1safepassword!';
ALTER ROLE

License

Use of components distributed via the pgedge repository is governed by product-specific licenses; see the bundled readme files for more information.