pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeddatabase system identifier differs between the primary and standby
6+ messages / 5 participants
[nested] [flat]
* database system identifier differs between the primary and standby
@ 2011-04-20 13:13 rajibdk <rajib.deka@siemens.com>
0 siblings, 0 replies; 6+ messages in thread
From: rajibdk @ 2011-04-20 13:13 UTC (permalink / raw)
To: pgsql-admin
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: +91-9176780669 | E-Mail: rajib.deka@siemens.com
--
View this message in context: http://postgresql.1045698.n5.nabble.com/database-system-identifier-differs-between-the-primary-and-s...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 6+ messages in thread
* database system identifier differs between the primary and standby
@ 2011-04-20 13:13 rajibdk <rajib.deka@siemens.com>
2011-04-20 15:57 ` Re: database system identifier differs between the primary and standby Simon Riggs <simon@2ndQuadrant.com>
0 siblings, 1 reply; 6+ messages in thread
From: rajibdk @ 2011-04-20 13:13 UTC (permalink / raw)
To: pgsql-admin
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: +91-9176780669 | E-Mail: rajib.deka@siemens.com
--
View this message in context: http://postgresql.1045698.n5.nabble.com/database-system-identifier-differs-between-the-primary-and-s...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: database system identifier differs between the primary and standby
2011-04-20 13:13 database system identifier differs between the primary and standby rajibdk <rajib.deka@siemens.com>
@ 2011-04-20 15:57 ` Simon Riggs <simon@2ndQuadrant.com>
2012-04-30 23:54 ` Re: database system identifier differs between the primary and standby DM <dm.aeqa@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Simon Riggs @ 2011-04-20 15:57 UTC (permalink / raw)
To: rajibdk <rajib.deka@siemens.com>; +Cc: 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: database system identifier differs between the primary and standby
2011-04-20 13:13 database system identifier differs between the primary and standby rajibdk <rajib.deka@siemens.com>
2011-04-20 15:57 ` Re: database system identifier differs between the primary and standby Simon Riggs <simon@2ndQuadrant.com>
@ 2012-04-30 23:54 ` DM <dm.aeqa@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: DM @ 2012-04-30 23:54 UTC (permalink / raw)
To: Simon Riggs <simon@2ndquadrant.com>; rajibdk <rajib.deka@siemens.com>; 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@2ndquadrant.com> wrote:
> 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
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* database system identifier differs between the primary and standby
@ 2011-04-20 13:16 Deka, Rajib IN MAA SL <rajib.deka@siemens.com>
2011-04-20 13:52 ` Re: database system identifier differs between the primary and standby Vibhor Kumar <vibhor.aim@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Deka, Rajib IN MAA SL @ 2011-04-20 13:16 UTC (permalink / raw)
To: pgsql-admin
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<http://www.siemens.com;
Mob: +91-9176780669 | E-Mail: rajib.deka@siemens.com
________________________________
Important notice: This e-mail and any attachment there to contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system.
Thank You.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: database system identifier differs between the primary and standby
2011-04-20 13:16 database system identifier differs between the primary and standby Deka, Rajib IN MAA SL <rajib.deka@siemens.com>
@ 2011-04-20 13:52 ` Vibhor Kumar <vibhor.aim@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Vibhor Kumar @ 2011-04-20 13:52 UTC (permalink / raw)
To: Deka, Rajib IN MAA SL <rajib.deka@siemens.com>; +Cc: pgsql-admin
On Apr 20, 2011, at 6:46 PM, Deka, Rajib IN MAA SL wrote:
>
> 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
vibhor.aim@gmail.com
Blog:http://vibhork.blogspot.com
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2012-04-30 23:54 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-04-20 13:13 database system identifier differs between the primary and standby rajibdk <rajib.deka@siemens.com>
2011-04-20 13:13 database system identifier differs between the primary and standby rajibdk <rajib.deka@siemens.com>
2011-04-20 15:57 ` Simon Riggs <simon@2ndQuadrant.com>
2012-04-30 23:54 ` DM <dm.aeqa@gmail.com>
2011-04-20 13:16 database system identifier differs between the primary and standby Deka, Rajib IN MAA SL <rajib.deka@siemens.com>
2011-04-20 13:52 ` Vibhor Kumar <vibhor.aim@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox