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:

  • database system identifier differs between the primary and standby (1)
  • EBSN (1)
  • https://yandex ru/clck/jsredir?from=yandex ru;search;web;;&text=&etext=1826 fn2I1xyr8twc-8hrGlfuAW8d3uBoJ1wWtUL5jAK0B-k79r1X_NUiO7FQWMvoOtQZ 92bd274d688e4c7fa58f26b0b37c493956c615d3&uuid=&state=_BLhILn4SxNIvvL0W45KSic66uCIg23qh8iRG98qeIXme (1)
  • https://yandex ru/clck/jsredir?from=yandex ru;search;web;;&text=&etext=1828 W5g0lydORPJC0Ay0bVgUJGYQu5CISDDxJ9_hpE4aSvriOTclsEJjAfoYRZtB4omK 9f5e676894d68afb6dfbede841c24687cf93f90f&uuid=&state=_BLhILn4SxNIvvL0W45KSic66uCIg23qh8iRG98qeIXme (1)
  • https://yandex ru/clck/jsredir?from=yandex ru;search;web;;&text=&etext=1831 qROw-4JkqYAAt3gUqxA6l9TGuvDqtKiBPTVE22HTtfvIdOmdrSW92txuMhhK6BcJ 5ca0ec5c90327fa1252d84855a76753d718723a6&uuid=&state=_BLhILn4SxNIvvL0W45KSic66uCIg23qh8iRG98qeIXme (1)
  • preparewqr (1)
  • settlersdb8 (1)
(Visited 1,045 times, 3 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 *

 

This site uses Akismet to reduce spam. Learn how your comment data is processed.