You are here

Verifying that the database is replicating

Subscribe to Syndicate
Replication is a feature of postgres and is automatically set up for cloud venues. Self service venues may set this up if they wish - the support team is unable to help you.
There are some simple ways to ensure that the main database is properly replicating to the hot standby. You will need to do most of this observation on the hot standby machine.
  • Observe the Postgres log roll forward the changes
  • Looking at the replication logs to see that they are created and then removed
  • Make some changes to the main database and then using pgAdmin to verify that the changes are in the backup in real time