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

Re: database system identifier differs between the primary and standby

From: DM <dm(dot)aeqa(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>, rajibdk <rajib(dot)deka(at)siemens(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: database system identifier differs between the primary and standby
Date: 2012-04-30 23:54:51
Message-ID: CAO0A+LivTxSR+OdvC2d2ZcNfP0b8vh=sCXF+mtZMA4reyruA1w@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)2ndquadrant(dot)com> wrote:

> 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
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

In response to

pgsql-admin by date

Next:From: Bèrto ëd SèraDate: 2012-05-01 09:13:01
Subject: Any public dataset for benchmarking?
Previous:From: Fernando HeviaDate: 2012-04-29 00:13:22
Subject: Re: Postgres shared memory error

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