Re: database system identifier differs between the primary and standby - Mailing list pgsql-admin

From Simon Riggs
Subject Re: database system identifier differs between the primary and standby
Date
Msg-id BANLkTin6V2M0HguAxxmiZykZSv_kwmXmqQ@mail.gmail.com
Whole thread Raw
In response to database system identifier differs between the primary and standby  (rajibdk <rajib.deka@siemens.com>)
Responses Re: database system identifier differs between the primary and standby
List pgsql-admin
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

pgsql-admin by date:

Previous
From: raghu ram
Date:
Subject: Re: [GENERAL] How to uninstall PostgreSQL 8.4 on both Windows XP and Windows 7
Next
From: Mario Splivalo
Date:
Subject: Reseting statistics, cluster wide