Live Sync Replication

The Live Sync feature synchronizes the master PostgreSQL server to a standby PostgreSQL server by replicating logs from the backup of the master server to a synced standby server. The live sync operation continuously applies log files from the master database backups since the last sync point.

Note: Backup and restore operations for this feature can be performed from PostgreSQL and EnterpriseDB version 9.2 to version 11.

The Live Sync feature performs the following procedures:

  • Initiates the replication automatically after a backup is completed on the master server.
  • Minimizes the impact on production systems CPU and I/O by using the backup data for replications. This method avoids the need to read the master server again for replication.
  • Copies the backup data to remote disaster recovery (DR) sites with deduplication to minimize the wide area network (WAN) traffic. A live sync operation then runs at the DR site.
  • Supports the destination database sync in standby mode so that users can schedule workloads on the destination server.
  • Initiates replication after the auxiliary copy completes, when you use a copy precedence for live sync operation.

You can use a live sync schedule to initiate replication automatically after the backup operation completes on the master server. If no new backup operations have run since the last live sync, then the scheduled live sync operation does not run.

Use the following backup types to replicate PostgreSQL databases:

  • Traditional backups
  • Auxiliary copies

Last modified: 5/18/2020 12:51:50 PM