Thread: database system identifier differs between the primary and standby
Hello List, We are getting the following log while configuring hot standby, 2011-04-20 17:34:40 ETC/GMT FATAL: the database system is starting up 2011-04-20 17:34:41 ETC/GMT FATAL: database system identifier differs between the primary and standby 2011-04-20 17:34:41 ETC/GMT DETAIL: The primary's identifier is 5592072752411433371, the standby's identifier is 5597615802844953578. PostgreSQL Version: 9.0.2 Prymary configuration: wal_level = 'hot_standby' - postgresql.conf host replication all x.x.x.x/24 trust – pg_hba.conf Secondary configuration: Hot_standby=off – postgresql.conf standby_mode = 'on' – recovery.conf primary_conninfo = 'host=10.20.9.181 port=5432' – recovery.conf Please suggest on the above log O/P. Regards, Rajib Rajib Deka SIEMENS Ltd. Robert V Chandran Tower, First Floor, West Wing, #149, Velechery Tambaram Main Road, Pallikaranai, Chennai-100, INDIA. www.siemens.com Mob: +91-9176780669 | E-Mail: rajib.deka@siemens.com -- View this message in context: http://postgresql.1045698.n5.nabble.com/database-system-identifier-differs-between-the-primary-and-standby-tp4315820p4315820.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
On Wed, Apr 20, 2011 at 2:13 PM, rajibdk <rajib.deka@siemens.com> wrote: > We are getting the following log while configuring hot standby, > > 2011-04-20 17:34:40 ETC/GMT FATAL: the database system is starting up > 2011-04-20 17:34:41 ETC/GMT FATAL: database system identifier differs > between the primary and standby > 2011-04-20 17:34:41 ETC/GMT DETAIL: The primary's identifier is > 5592072752411433371, the standby's identifier is 5597615802844953578. Please refer to http://www.postgresql.org/docs/9.0/static/warm-standby.html#STANDBY-SERVER-SETUP http://www.postgresql.org/docs/9.0/static/continuous-archiving.html#BACKUP-PITR-RECOVERY You might also want to look at the recent Postgres book that has a detailed chapter on Replication: http://www.2ndquadrant.com/books/postgresql-9-admin-cookbook/ -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
Looks like you have set the wrong host information in recovery.conf file or there is a mistake in recovery.conf file. Please check your recovery.conf file.
May be postgres should throw a correct message to the logs saying the host information for replication is wrong or something meaningful to understand instead of "database system identifier differs between the primary and standby"
Thanks
Deepak
On Wed, Apr 20, 2011 at 8:57 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
On Wed, Apr 20, 2011 at 2:13 PM, rajibdk <rajib.deka@siemens.com> wrote:Please refer to
> We are getting the following log while configuring hot standby,
>
> 2011-04-20 17:34:40 ETC/GMT FATAL: the database system is starting up
> 2011-04-20 17:34:41 ETC/GMT FATAL: database system identifier differs
> between the primary and standby
> 2011-04-20 17:34:41 ETC/GMT DETAIL: The primary's identifier is
> 5592072752411433371, the standby's identifier is 5597615802844953578.
http://www.postgresql.org/docs/9.0/static/warm-standby.html#STANDBY-SERVER-SETUP
http://www.postgresql.org/docs/9.0/static/continuous-archiving.html#BACKUP-PITR-RECOVERY
You might also want to look at the recent Postgres book that has a
detailed chapter on Replication:
http://www.2ndquadrant.com/books/postgresql-9-admin-cookbook/
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin