Postgres Pro
Downloads
Home   >   mailing lists

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

From Vibhor Kumar
Subject Re: database system identifier differs between the primary and standby
Date
Msg-id E8206F4A-2089-4786-8223-84307292712B@gmail.com
Whole thread Raw
In response to database system identifier differs between the primary and standby  ("Deka, Rajib IN MAA SL" <rajib.deka@siemens.com>)
List pgsql-admin
Tree view 
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
creatingstandby. 

Thanks & Regards,
Vibhor Kumar
vibhor.aim@gmail.com
Blog:http://vibhork.blogspot.com

pgsql-admin by date:

Previous
From: "Deka, Rajib IN MAA SL"
Date:
Subject: database system identifier differs between the primary and standby
Next
From: raghu ram
Date:
Subject: Re: [GENERAL] How to uninstall PostgreSQL 8.4 on both Windows XP and Windows 7