Configuring Supporting Components
Many of the supporting components distributed via the pgedge repository follow standard configuration and usage as documented by their open-source projects.
Package names and links to the component documentation are noted in the table below. _XX after the package name indicates the package version is required; substitute your version into the package name (i.e. pgedge-spock50_16 or pgedge-spock50_17).
| Component | Package Name | Details and Links |
|---|---|---|
| Spock | pgedge-spock50_XX | Configuration and Usage |
| Snowflake | pgedge-snowflake_XX | Configuration and Usage (opens in a new tab) |
| Lolor | pgedge-lolor_XX | Configuration and Usage (opens in a new tab) |
| pgAdmin | pgedge-pgadmin4; pgedge-pgadmin4-desktop; pgedge-pgadmin4-server; pgedge-pgadmin4-web | Configuration and Usage (opens in a new tab) |
| pgaudit | pgedge-pgaudit_XX | Configuration and Usage (opens in a new tab) |
| pgBackRest | pgedge-pgbackrest | Configuration and Usage |
| PostGIS | pgedge-postgis35_XX | Configuration and Usage (opens in a new tab) |
| pgBouncer | pgedge-pgbouncer | Configuration and Usage |
| pgvector | pgedge-pgvector_XX | Configuration and Usage (opens in a new tab) |
After using the pgedge repository to install a component, use the Postgres CREATE EXTENSION (opens in a new tab) command to create the extension in your database.
Using pgBouncer with pgEdge Enterprise Postgres
PgBouncer is a lightweight connection pooler designed to work with Postgres. After configuring the pgedge repo, you can install PgBouncer with the command:
sudo dnf install pgedge-pgbouncer
After installing pgBouncer, copy the sample userlist.txt to the PgBouncer configuration directory:
sudo cp /usr/share/doc/pgbouncer/userlist.txt /etc/pgbouncer/
Next, edit /etc/pgbouncer/userlist.txt and add your database user credentials. Entries in the file take the form:
"postgres" "your_password_here"
Next, make sure the file has the correct permissions; use the command:
sudo chown pgbouncer:pgbouncer /etc/pgbouncer/userlist.txt sudo chmod 600 /etc/pgbouncer/userlist.txt
Before using pgBouncer, you'll need to share system configuration details in the /etc/pgbouncer/pgbouncer.ini file; modify the file to match your system. Provide database connection info, listener port, and other options as needed.
Next, ensure that your Postgres server is up and running on the target port and start the PgBouncer service with the command:
sudo systemctl start pgbouncer
You can use the following command to check the status of the pgBouncer service:
sudo systemctl status pgbouncer
To connect to your Postgres database through PgBouncer connection pooling, use the command:
psql -p 6432 -U your_username -d pgbouncer
Note that your_username is a database user included in the /etc/pgbouncer/userlist.txt file.