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

From: Amit Bondwal <bondwal(dot)amit(at)gmail(dot)com>
To: Michael Paquier <michael(dot)paquier(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 12:26:43
Message-ID: CAJ=k2iGp-8nD0DKksZRQRzd41fTzriEyA_x3iq0Lbdy2YNOcig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael, Thanks for your reply, I found the issue, the person who setup OS
mix up some 64 and 32 bit package. I am starting it again.

Thanks again.

On Fri, Aug 21, 2015 at 5:12 PM, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
wrote:

>
>
> 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

Browse pgsql-general by date

  From Date Subject
Next Message Laurent Laborde 2015-08-21 13:24:25 Re: hot backup with zfs ?
Previous Message Michael Paquier 2015-08-21 11:42:46 Re: Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file