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]@[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.a...@gmail.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 >
