Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file - Mailing list pgsql-general

From Michael Paquier
Subject Re: Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file
Date
Msg-id CAB7nPqQ=j_SWDdmPDWEVuCW1_a9Sb0nsBXg9fhJaeY5fDdX1wA@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file  (Amit Bondwal <bondwal.amit@gmail.com>)
Responses Re: Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file
List pgsql-general
Tree view


On Fri, Aug 21, 2015 at 7:56 PM, Amit Bondwal <bondwal.amit@gmail.com> wrote:
2015-08-21 15:35:03 IST [21507-2] DETAIL:  The primary's identifier is 6185381639353264094, the standby's identifier is 6185382953613258663.

It gives the error "database system identifier differs between the primary and standby".

This means that you are trying to use a standby that has been set up using the base backup from the node of another cluster (be it either standby or master node), different than the node you are trying to connect to. This error just reports the incompatibility.
--
Michael

pgsql-general by date:

Previous
From: Amit Bondwal
Date:
Subject: Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file
Next
From: Amit Bondwal
Date:
Subject: Re: Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file