Gold Standard Disaster Recovery for PostgreSQL

Leverage PostgreSQL's powerful real-time replication functionality to keep a standby cluster continuously up-to-date. Easily import existing streaming configurations to gain compelling monitoring and maintenance functionality through StandbyMP.

1. Initialize the standby cluster easily using StandbyMP.
   
   
2. A replication slot is created on the primary cluster, to which the standby cluster seamlessly connects and initiates a full backup operation via the data stream.
   
   
3. Once the primary cluster data is synchronized, the standby cluster remains continuously connected and receives all transactions from the primary as soon as they are committed.

Utilize time-tested and reliable Write-Ahead-Log files together with PostgreSQL's Archive Mode settings to keep your standby cluster up to date.

1. Initialize the standby cluster easily using StandbyMP.
   
   
2. A full backup is automatically created, transferred onto standby and restored, bringing the standby into sync with the primary.
   
   
3. The Archive Interval is set on the primary cluster. Whenever a new WAL segment is ready, or the Interval timeout is reached, a new WAL file is backed up by the primary cluster.
   
   
4. StandbyMP automatically creates and manages the various associated callbacks, catching the newly-created WAL file, transferring it to the standby, and restoring it. StandbyMP also includes all file management, keeping both systems clean of WAL files that are no longer required.

When you need total control, keep your standby cluster in-sync by manually creating and restoring transactional backups on a set schedule.

1. Initialize the standby cluster easily using StandbyMP.
   
   
2. A full backup is automatically created, transferred onto standby and restored, bringing the standby into sync with the primary.
   
   
3. Leaving PostgreSQL's own settings alone, StandbyMP instead controls the whole show itself: a manual query is run on a set interval to create WAL backups.
   
   
4. These are then automatically brought across to the standby cluster, and a manual query is run to restore them. StandbyMP manages all files and network transfers.