[ADMIN] database system identifier differs between the primary and standby

[rajibdk]

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: [phone] | E-Mail: ***@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.

[Vibhor Kumar]

Post by rajibdk
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

How did you setupt the replication? Please mention the steps. It seems you have not used the PITR Backup of Primary for creating standby.

Thanks & Regards,
Vibhor Kumar
***@gmail.com
Blog:http://vibhork.blogspot.com

[Simon Riggs]

Post by rajibdk
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/

[DM]

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

Post by Simon Riggs

Post by rajibdk
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
http://www.2ndquadrant.com/books/postgresql-9-admin-cookbook/
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
http://www.postgresql.org/mailpref/pgsql-admin