From: | "Venkatesh" <venkatesh(at)claystone-tech(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Postgres 9.0 Replication - Problem in Starting up Standby Server |
Date: | 2011-03-22 08:32:25 |
Message-ID: | 005801cbe86b$ace33ff0$06a9bfd0$@com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I am running a test setup for verifying the hot standby feature in Postgres
9.0 release. Both my Master (Win 7 Professional, 32 bit) & Standby (Win 7
Professional, 32 bit) machines are having Postgres 9.0
(postgresql-9.0.3-1-windows) installed & both are in our LAN environment.
After taking a hot backup of the master database using pg_start_backup() &
copy of the data folder to Standby machine followed by pg_stop_backup() in
Master, the Standby server is started. The Standby server logs show the
following error and the Postgres server shuts down
2011-03-22 13:01:58 IST FATAL: the database system is starting up
2011-03-22 13:01:59 IST FATAL: the database system is starting up
2011-03-22 13:02:00 IST FATAL: the database system is starting up
2011-03-22 13:02:01 IST FATAL: ShmemIndex entry size is wrong for data
structure "Wal Sender Ctl": expected 16, actual 0
2011-03-22 13:02:01 IST FATAL: the database system is starting up
2011-03-22 13:02:02 IST FATAL: the database system is starting up
2011-03-22 13:02:03 IST FATAL: the database system is starting up
2011-03-22 13:02:04 IST FATAL: the database system is starting up
2011-03-22 13:02:05 IST FATAL: the database system is starting up
2011-03-22 13:02:06 IST FATAL: the database system is starting up
2011-03-22 13:02:07 IST FATAL: the database system is starting up
2011-03-22 13:02:08 IST FATAL: the database system is starting up
2011-03-22 13:02:09 IST FATAL: the database system is starting up
2011-03-22 13:02:10 IST FATAL: the database system is starting up
2011-03-22 13:02:11 IST FATAL: the database system is starting up
2011-03-22 13:02:12 IST FATAL: ShmemIndex entry size is wrong for data
structure "Wal Sender Ctl": expected 16, actual 0
2011-03-22 13:02:12 IST FATAL: the database system is starting up
2011-03-22 13:02:13 IST FATAL: the database system is starting up
2011-03-22 13:02:15 IST FATAL: the database system is starting up
2011-03-22 13:02:16 IST FATAL: the database system is starting up
2011-03-22 13:02:17 IST FATAL: the database system is starting up
2011-03-22 13:02:23 IST FATAL: ShmemIndex entry size is wrong for data
structure "Wal Sender Ctl": expected 16, actual 0
2011-03-22 13:02:34 IST FATAL: ShmemIndex entry size is wrong for data
structure "Wal Sender Ctl": expected 16, actual 0
2011-03-22 13:02:45 IST FATAL: ShmemIndex entry size is wrong for data
structure "Wal Sender Ctl": expected 16, actual 0
I have also attached the Master/Standy config files for your reference.
Please help me in resolving this issue.
Regds,
Venkatesh
Attachment | Content-Type | Size |
---|---|---|
postgres-replication.zip | application/octet-stream | 17.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | tv | 2011-03-22 09:53:20 | Re: postgres conferences missing videos? |
Previous Message | Alban Hertroys | 2011-03-22 07:37:31 | Re: query taking much longer since Postgres 8.4 upgrade |