On Wed, Apr 20, 2011 at 2:13 PM, rajibdk <rajib.deka@xxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin