Configuration Metrics News About

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 8 dashboard
• Remote management
• Authentication query support
• Failover support
• Transport Layer Security (TLS) v1.2+ support
• Daemon support
• User vault

Overview

• 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

Presentations

• Lighting talk: pgagroal 1.2 (Slides)
• pgcon 2020: Introducing pgagroal (Slides) (Video)
• pgconf.us 2020: Introducing pgagroal (Slides)

Further information

• GitHub

Related projects

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