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

Detailed logs in log file

DETAIL: The primary's identifier is 6185381639353264094, the standby's
identifier is 6185382953613258663.
2015-08-21 15:34:16 IST [21447-1] FATAL: database system identifier
differs between the primary and standby
2015-08-21 15:34:16 IST [21447-2] DETAIL: The primary's identifier is
6185381639353264094, the standby's identifier is 6185382953613258663.
2015-08-21 15:34:17 IST [21105-2] LOG: received fast shutdown request
2015-08-21 15:34:17 IST [21105-3] LOG: aborting any active transactions
2015-08-21 15:34:17 IST [21107-1] LOG: shutting down
2015-08-21 15:34:17 IST [21107-2] LOG: database system is shut down
2015-08-21 15:34:18 IST [21465-1] LOG: database system was shut down in
recovery at 2015-08-21 15:34:17 IST
2015-08-21 15:34:18 IST [21465-2] LOG: entering standby mode
2015-08-21 15:34:18 IST [21465-3] LOG: consistent recovery state reached
at 0/1782DE8
2015-08-21 15:34:18 IST [21465-4] LOG: record with zero length at 0/1782DE8
2015-08-21 15:34:18 IST [21464-1] LOG: database system is ready to accept
read only connections
2015-08-21 15:34:18 IST [21469-1] FATAL: database system identifier
differs between the primary and standby
2015-08-21 15:34:18 IST [21469-2] DETAIL: The primary's identifier is
6185381639353264094, the standby's identifier is 6185382953613258663.
2015-08-21 15:34:19 IST [21470-1] [unknown](at)[unknown] LOG: incomplete
startup packet
2015-08-21 15:34:33 IST [21492-1] FATAL: database system identifier
differs between the primary and standby
2015-08-21 15:34:33 IST [21492-2] DETAIL: The primary's identifier is
6185381639353264094, the standby's identifier is 6185382953613258663.
2015-08-21 15:34:38 IST [21495-1] FATAL: database system identifier
differs between the primary and standby
2015-08-21 15:34:38 IST [21495-2] DETAIL: The primary's identifier is
6185381639353264094, the standby's identifier is 6185382953613258663.
2015-08-21 15:34:43 IST [21496-1] FATAL:

2015-08-21 15:34:43 IST [21496-2] DETAIL: The primary's identifier is
6185381639353264094, the standby's identifier is 6185382953613258663.
2015-08-21 15:34:48 IST [21498-1] FATAL: "/var/lib/postgresql/9.3/main" is
not a valid data directory
2015-08-21 15:34:48 IST [21498-2] DETAIL: File
"/var/lib/postgresql/9.3/main/PG_VERSION" is missing.
2015-08-21 15:35:03 IST [21507-1] FATAL: database system identifier
differs between the primary and standby
2015-08-21 15:35:03 IST [21507-2] DETAIL: The primary's identifier is
6185381639353264094, the standby's identifier is 6185382953613258663.
2015-08-21 15:35:03 IST [21464-2] LOG: received fast shutdown request
2015-08-21 15:35:03 IST [21464-3] LOG: aborting any active transactions
2015-08-21 15:35:03 IST [21466-1] LOG: shutting down
2015-08-21 15:35:03 IST [21466-2] LOG: database system is shut down
2015-08-21 15:35:29 IST [21535-1] FATAL: incorrect checksum in control file
2015-08-21 15:40:20 IST [21561-1] FATAL: incorrect checksum in control file

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

On Fri, Aug 21, 2015 at 3:26 PM, Amit Bondwal <bondwal(dot)amit(at)gmail(dot)com>
wrote:

> Hi everyone,
>
> I am trying to setup postgresql 9.3 hotstandby replication server. I am
> getting error incorrect checksome in control file. both server have below
> version and pg package version and both are 64 bit processor.
>
> OS is : Debian squeeze
> PG version:- postgresql-9.3
>
> Only difference is replication server hardware is more powerful than
> master server.
>
> I am following this link
> http://www.rassoc.com/gregr/weblog/2013/02/16/zero-to-postgresql-streaming-replication-in-10-mins/.
> I had done replication previously by using this method but in that cases
> server hardware was same and OS was debian squeeze or it was on debian
> wheezy on different hardwares or VPS servers.
>
> Is there any different way to do replication to avoid this issue? or how
> can I resolve this issue.
>
>
> --
> Regards
>
> Amit Bondwal
>