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) when installing the package to
ensure you've installed the version that matches your copy of Postgres.
| Component | Package | Description | Info |
|---|---|---|---|
| Spock | pgedge-spock50_XX | Multi-master logical replication | Info |
| Snowflake | pgedge-snowflake_XX | Distributed unique ID generator | Info |
| pgEdge Postgres MCP Server | pgedge-postgres-mcp | Model Context Protocol server and Natural Language Agent |
Info |
| Postgres MCP KB Server | pgedge-postgres-mcp-kb | MCP support for Knowledgebase | Info |
| NLA CLI Client | pgedge-nla-cli | Natural Language API CLI tool | Info |
| NLA Web Client | pgedge-nla-web | Natural Language API web interface | Info |
| pgEdge Anonymizer | pgedge-anonymizer | Data anonymization and masking | Info |
| pgEdge DocLoader | pgedge-docloader | Document loading utility | Info |
| pgEdge RAG Server | pgedge-rag-server | Retrieval-Augmented Generation server | Info |
| pgEdge Vectorizer | pgedge-vectorizer_XX | Vector embedding generation | Info |
| Lolor | pgedge-lolor_XX | Logical-logical replication | Info |
| pgAdmin | pgedge-pgadmin4; pgedge-pgadmin4-desktop; pgedge-pgadmin4-server; pgedge-pgadmin4-web |
Web-based database management tool | Info |
| pgaudit | pgedge-pgaudit_XX | Session and object audit logging | Info |
| pgBackRest | pgedge-pgbackrest | Backup and restore solution | Info |
| PostGIS | pgedge-postgis35_XX | Spatial and geographic objects | Info |
| pgBouncer | pgedge-pgbouncer | Lightweight connection pooler | Info |
| pgvector | pgedge-pgvector_XX | Vector similarity search for Postgres | Info |
Note
After using the pgedge repository to install an extension, use the
CREATE EXTENSION
command to create that 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.