pgagroal

pgagroal is a high-performance protocol-native connection pool for PostgreSQL.

Pronounced: p-g-a-gro-al, named after A gro al in Portugal.

Features

High performance
Connection pool
Limit connections for users and databases
Prefill support
Remove idle connections
Perform connection validation
Enable / disable database access
Graceful / fast shutdown
Transport Layer Security (TLS) v1.2+ support
Daemon mode
User vault

See Getting Started on how to get started with pgagroal.

See Configuration on how to configure pgagroal.

See Performance for a performance run.

Overview

pgagroal makes use of

Process model
Shared memory model across processes
libev for fast network interactions
Atomic operations are used to keep track of state
The PostgreSQL native protocol v3 for its communication

See Architecture for the architecture of pgagroal.

Tested platforms

Fedora 28+
RHEL 7.x with EPEL and DevTools 8+
RHEL 8.x with AppStream

Compiling the source

pgagroal requires

dnf install gcc cmake make libev libev-devel openssl openssl-devel python3-docutils

Alternative clang 8+ can be used.

Release build

The following commands will install pgagroal in the /usr/local hierarchy and run the default configuration.

git clone https://github.com/agroal/pgagroal.git
cd pgagroal
mkdir build
cd build
cmake -DCMAKE_INSTALL_PREFIX=/usr/local ..
make
sudo make install
/usr/local/bin/pgagroal -c /usr/local/etc/pgagroal/pgagroal.conf -a /usr/local/etc/pgagroal/pgagroal_hba.conf

See RPM for how to build a RPM of pgagroal.

Debug build

The following commands will create a DEBUG version of pgagroal.

git clone https://github.com/agroal/pgagroal.git
cd pgagroal
mkdir build
cd build
cmake -DCMAKE_BUILD_TYPE=Debug ..
make
cd src
cp ../../doc/etc/*.conf .
./pgagroal -c pgagroal.conf -a pgagroal_hba.conf

Remember to set the log_level configuration option to debug5.

Contributing

Contributions to pgagroal are managed on GitHub.com

Contributions are most welcome !

Consider giving the project a star on GitHub if you find it useful. And, feel free to follow the project on Twitter as well.

License

BSD-3-Clause

xxgoracle/pgagroal