Patroni
Run PostgreSQL clusters with distributed consensus and automatic failover.
Multilingual documentation for six independent components
PostgreSQL Community Components
Independent, elegant, multilingual documentation.
Choose a documentation root
Six components. Six direct entrances.
Each component has its own sidebar, reading order, page outline, and local search context. All six collections are bilingual.
Read the docs
pgBackRest
Design reliable backup, restore, archive, and point-in-time recovery workflows.
PgBouncer
Cut connection overhead with session, transaction, and statement pooling.
pgBadger
Turn PostgreSQL and PgBouncer logs into query, workload, and error reports.
HAProxy
Read the complete HAProxy 3.4 Starter, Configuration, and Management manuals.
etcd
Operate a strongly consistent key-value store, its APIs, Raft model, and internals.
Component guides
What each component does — and where to start
Read the short orientation, then use the linked index beside it to jump directly into the manual.
01 / HIGH AVAILABILITY
Patroni
◇ A template for PostgreSQL high availability
- Runs leader election and cluster state through a DCS.
- Automates failover, with controls for planned changes.
- Covers bare metal, VMs, Kubernetes, and multi-datacenter.
Start with installation and configuration, then the operational surfaces.
02 / BACKUP & RECOVERY
pgBackRest
◇ Reliable backup, archive, restore, and point-in-time recovery
- Full, differential, incremental, and block-level backups.
- Manages repositories, retention, and WAL archiving.
- Documents guided deployments and every command.
Start with your OS guide, then keep configuration and commands close.
03 / CONNECTION POOLING
PgBouncer
◇ A lightweight connection pooler for PostgreSQL
- Reuses connections to cut backend startup cost.
- Offers session, transaction, and statement pooling.
- Covers authentication, routing, limits, and the console.
Read the pooling model first, then install and tune for your workload.
04 / LOG ANALYSIS
pgBadger
◇ Fast PostgreSQL and PgBouncer log analysis
- Parses PostgreSQL and PgBouncer logs in many formats.
- Reports slow queries, errors, locks, and vacuum activity.
- Generates self-contained HTML, JSON, text, and CSV output.
Configure logging first, then pick one-shot, parallel, or incremental.
05 / LOAD BALANCING
HAProxy
◇ Fast, reliable TCP and HTTP traffic management
- The complete 3.4 Starter Guide as nine focused topics.
- The Configuration Manual in its 12 native chapters.
- The Management Guide in 13 operational chapters.
Learn the architecture, look up every keyword, and operate HAProxy.
06 / CONSENSUS & COORDINATION
etcd
◇ A strongly consistent distributed key-value store
- A durable key-value API built on the Raft algorithm.
- Covers configuration, security, maintenance, and tuning.
- Documents client APIs, upgrades, and internal design.
Start with the quickstart, then the ops guide and v3 API reference.
FAQ
A few useful answers
Where should I start?
Choose the component that matches your current task. Each card opens an independent documentation root, and the detailed section above links directly to its most-used pages.
Is pgsql.cc an official PostgreSQL website?
No. pgsql.cc is an independent community documentation project. It links back to each upstream project and keeps product names and technical context intact.
How are the English and Chinese pages organized?
All six collections pair the English source and Simplified Chinese translation at the same logical route, with the language control switching between them.
How is the upstream documentation credited?
Every page ends with one line naming the work it is adapted from, its copyright holder, its licence, and a link to this site’s change history for that page. The attribution page collects the pinned revisions, licences, and retained notices for all six collections.
