Postgres 9.0 Replication - Problem in Starting up Standby Server

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

Browse pgsql-general by date

  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