Patroni
Build and operate PostgreSQL clusters with distributed consensus, health checks, and automatic failover.
Four independent PostgreSQL manuals · English + 中文
PostgreSQL Community Components
Four focused documentation roots for Patroni, pgBackRest, PgBouncer, and pgBadger.
Pick a component and go straight to its guides, references, releases, and support material.
Choose a documentation root
Four components. Four direct entrances.
Each component has its own sidebar, reading order, page outline, and local search context.
Read the docs
pgBackRest
Design reliable backup, restore, archive, retention, and point-in-time recovery workflows.
PgBouncer
Reduce connection overhead and understand session, transaction, and statement pooling behavior.
pgBadger
Turn PostgreSQL and PgBouncer logs into query, workload, error, and operational reports.
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
- Coordinates leader election and cluster state through a distributed configuration store.
- Automates failover while retaining explicit controls for planned operational changes.
- Covers bare metal, virtual machines, Kubernetes, watchdogs, and multi-datacenter patterns.
Start with installation and configuration, then learn the operational surfaces.
02 / BACKUP & RECOVERY
pgBackRest
◇ Reliable backup, archive, restore, and point-in-time recovery
- Supports full, differential, incremental, and block-level backups with parallel processing.
- Manages repositories, retention, encryption, object storage, and asynchronous WAL archiving.
- Documents both guided deployments and every command in the reference interface.
Begin with the guide for your operating system, then keep configuration and command reference close.
03 / CONNECTION POOLING
PgBouncer
◇ A lightweight connection pooler for PostgreSQL
- Reuses PostgreSQL connections to reduce backend startup cost and connection pressure.
- Offers session, transaction, and statement pooling with different compatibility boundaries.
- Includes a compact but complete guide to authentication, routing, limits, timeouts, and the admin console.
Read the pooling model first, then install and tune the configuration for your workload.
04 / LOG ANALYSIS
pgBadger
◇ Fast PostgreSQL and PgBouncer log analysis
- Parses many PostgreSQL log formats, compressed files, remote inputs, and PgBouncer logs.
- Reports slow and frequent queries, errors, sessions, locks, checkpoints, vacuum activity, and more.
- Generates self-contained HTML, incremental reports, JSON, text, binary, and CSV output.
Configure logging first, then choose between one-shot, parallel, and incremental reporting.
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?
Every imported page has a paired translation at the same logical route. The language switcher keeps readers on the corresponding page whenever both versions exist.