Search Postgresql Archives

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

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

 



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.amit@xxxxxxxxx> 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


[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