Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.paquier@xxxxxxxxx> wrote:


On Fri, Aug 21, 2015 at 7:56 PM, Amit Bondwal <bondwal.amit@xxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux