Skip site navigation (1) Skip section navigation (2)

Re: database system identifier differs between the primary and standby

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: rajibdk <rajib(dot)deka(at)siemens(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: database system identifier differs between the primary and standby
Date: 2011-04-20 15:57:35
Message-ID: BANLkTin6V2M0HguAxxmiZykZSv_kwmXmqQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Wed, Apr 20, 2011 at 2:13 PM, rajibdk <rajib(dot)deka(at)siemens(dot)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

In response to

Responses

pgsql-admin by date

Next:From: Mario SplivaloDate: 2011-04-20 19:31:30
Subject: Reseting statistics, cluster wide
Previous:From: raghu ramDate: 2011-04-20 15:52:09
Subject: Re: [GENERAL] How to uninstall PostgreSQL 8.4 on both Windows XP and Windows 7

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group