postgresql FATAL: database system identifier differs between the primary and standby

This is due to two possible reasons:

  1. you did not do the initial filesystem sync (usually rsync)
  2. the recovery.conf contains errors

this page actually helped me

https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-on-postgresql-on-an-ubuntu-12-04-vps

Hope this helps 

(Visited 94 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *