🐘 PostgreSQL¶

Muppy's PostgreSQL features are split across four Apps:

PostgreSQL Base — install, configure and manage standalone PostgreSQL clusters. Back up, restore and copy databases as pg_dump archives.
PostgreSQL Replication — manage streaming replication over groups of clusters called RCS (Replicated Cluster Set). ==Video tutorial available==
PostgreSQL HA — add automatic failover to clusters running streaming replication. Built on pglookout, not Patroni or repmgr.
PostgreSQL PITR — Point In Time Recovery: continuous backup, and restore of a cluster to any moment in time.

The diagram below shows how they fit together:

Recovery Time Objective (RTO)¶

RTO is the longest acceptable outage — how long a PostgreSQL cluster may stay unavailable.

Muppy PostgreSQL HA (with Replication) builds RCS that meet a demanding RTO.

Success

Muppy can run HA across multi-cloud RCS, which gives you the highest availability levels.

RPO is the longest acceptable window of data loss.

Muppy PITR builds clusters that meet an RPO of a few minutes.

Info

Deploy Muppy PostgreSQL High Availability and Muppy PITR together for clusters that meet a demanding RPO and RTO.