PostgreSQL Replication¶
Streaming replication copies a Primary cluster onto one or more Standby clusters. The primary handles reads and writes; standbys are read-only.
RCS
Muppy calls a group of clusters replicating to each other a Replicated Cluster Set, or RCS. Find them under Muppy / Databases / PostgreSQL / Replicated Cluster Set (RCS).
Replication is not a backup
Replication makes standbys faithful copies of the primary — including your mistakes. A
DROP DATABASE replicates just as reliably as anything else.
Muppy offers two backup mechanisms that complement replication:
- Database Backups (pg_dump) — the PostgreSQL Base App
- Continuous backup — the PostgreSQL PITR / wal-g App
What you can do¶
- Create an RCS
- View an RCS
- Monitor replication
- Add standbys
- Restructure an RCS — change the primary, promote a standby to a standalone cluster
- Integrate an RCS with your applications or orchestrator, through callbacks and notifications
- Reconfigure a running RCS