pgagroal

Appearance

Features ​

  • High performance connection pool
  • Limit connections for users and databases
  • Prefill support
  • Remove idle connections
  • Connection validation
  • Enable / disable database access
  • Graceful / fast shutdown
  • Prometheus support
  • Grafana 12 dashboard
  • Remote management
  • Authentication query support
  • Failover support
  • Transport Layer Security (TLS) v1.2+ support
  • Daemon mode
  • User vault

Overview ​

pgagroal makes use of

  • Process model
  • Shared memory model across processes
  • io_uring (Linux) / kqueue (*BSD) for fast network interactions
  • Atomic operations are used to keep track of state

See Architecture for the architecture of pgagroal.

Further information ​

  • pgmoneta - Backup / restore solution for PostgreSQL
  • pgexporter - Prometheus exporter for PostgreSQL