Re: Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Amit Bondwal <bondwal(dot)amit(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file
Date: 2015-08-21 11:42:46
Message-ID: CAB7nPqQ=j_SWDdmPDWEVuCW1_a9Sb0nsBXg9fhJaeY5fDdX1wA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 21, 2015 at 7:56 PM, Amit Bondwal <bondwal(dot)amit(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Amit Bondwal 2015-08-21 12:26:43 Re: Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file
Previous Message Amit Bondwal 2015-08-21 10:56:21 Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file