Introduction
pgagroal is a high-performance protocol-native connection pool for PostgreSQL.
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
- Prometheus support
- Grafana 12 dashboard
- Remote management
- Authentication query support
- Failover support
- Transport Layer Security (TLS) v1.2+ support
- Daemon mode
- User vault
Platforms
The supported platforms are
How to Use This Manual
This manual is organized to guide you from initial setup to advanced usage and development. Use the table below to quickly find the section most relevant to your needs:
Navigation Note: Each entry has two links separated by
|:
- First link (Chapter): Use when reading the PDF manual (jumps to page)
- Second link (File): Use when browsing individual markdown files
- File links will not work in PDF format
| Chapter | File | Description |
|---|---|---|
| Installation | 02-installation.md | Step-by-step setup for Rocky Linux, PostgreSQL 18, and pgagroal |
| Getting Started | 03-gettingstarted.md | Quick introduction to basic pgagroal usage and initial configuration |
| Configuration | 04-configuration.md | Comprehensive guide to all configuration files and options |
| Prefill | 05-prefill.md | How to configure and use connection prefill for better performance |
| Remote Management | 06-remote_management.md | Setting up and using remote management features for pgagroal |
| Split Security | 07-split_security.md | Implementing split security models for authentication and access control |
| TLS | 08-tls.md | Configuring Transport Layer Security (TLS) for secure connections |
| Database Alias | 09-database_alias.md | Using database aliases for flexible client connections |
| Vault | 10-vault.md | Managing user credentials and secrets with the pgagroal vault |
| Prometheus | 11-prometheus.md | Integrating Prometheus metrics and monitoring |
| Docker | 12-docker.md | Running pgagroal in Docker containers |
| Command Line Tools | 13-cli-tools.md | Comprehensive CLI tools reference (pgagroal-cli, pgagroal-admin) |
| Performance | 14-performance.md | Performance benchmarks, tuning, and optimization |
| Failover | 15-failover.md | Failover configuration and scripting |
| Pipelines | 16-pipelines.md | Pipeline types and configuration |
| Security | 17-security.md | Comprehensive security hardening guide |
| Development | 70-dev.md | Development environment setup and contribution guidelines |
| Git | 71-git.md | Git workflow and version control practices for the project |
| Architecture | 72-architecture.md | High-level architecture and design of pgagroal |
| RPM | 73-rpm.md | Building and using RPM packages |
| Building | 74-building.md | Compiling pgagroal from source |
| Code Coverage | 75-codecoverage.md | Code coverage analysis and testing practices |
| Event Loop | 76-eventloop.md | Understanding the event loop implementation |
| Core API | 77-core_api.md | Reference for core API functions |
| Testing | 78-test.md | Testing frameworks and procedures |
| Distribution Installation | 79-distributions.md | Platform-specific installation notes |
| Acknowledgements | 97-acknowledgement.md | Credits and contributors |
| Licenses | 98-licenses.md | License information |
| References | 99-references.md | Additional resources and references |