| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mario Splivalo | 2011-04-20 19:31:30 | Reseting statistics, cluster wide |
| Previous Message | raghu ram | 2011-04-20 15:52:09 | Re: [GENERAL] How to uninstall PostgreSQL 8.4 on both Windows XP and Windows 7 |