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 

Incoming search terms:

  • FATAL: database system identifier differs between the primary and standby (1)
(Visited 370 times, 1 visits today)

Author: Giuseppe Urso

Giuseppe lives in Haarlem now with his shiny dog, Filippa
In 1982 received his first home computer, a Commodore 64, followed by Datasette and a 1541 Floppy Disk Drive.
In 1999 he installed his first Linux distro (LRH6).
In 2006 he switched to Debian as favourite OS. Giuseppe Urso actively sustains the Free Software Fundation and his founder Richard Mattew Stallman, he speaks to people trying to convince them to join the fight now, and about how important is to use Free Software only.
He has a job as Infra Specialist at Hippo Enterprise Java Cms an Open Source Enterprise class Content Management System, one of the coolest company ever, in Amsterdam. He’s always ready to install Debian on other people computers for free.

Leave a Reply

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