Standby server does not start with base backup

From: Sanjay Rao <srao(at)noida(dot)interrasystems(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Standby server does not start with base backup
Date: 2011-06-18 08:57:30
Message-ID: 4DFC687A.8080703@noida.interrasystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am running a test setup for verifying the warm standby feature in
Postgres 9.0 release. Both my Master (Win 7 Professional, 64 bit) &
Standby (Win 7
Professional, 64 bit) machines are having Postgres 9.0
(postgresql-9.0.4-1-windows) installed & both are in our LAN environment.

After taking a base 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 standby Postgres
server shuts down. After this it never starts

2011-06-18 13:56:32 IST LOG: entering standby mode
2011-06-18 13:56:32 IST LOG: streaming replication successfully
connected to primary
2011-06-18 13:56:32 IST FATAL: the database system is starting up
2011-06-18 13:56:33 IST LOG: redo starts at 0/3000020
2011-06-18 13:56:33 IST FATAL: the database system is starting up
2011-06-18 13:56:34 IST LOG: consistent recovery state reached at 0/5000000
2011-06-18 13:56:34 IST FATAL: the database system is starting up
2011-06-18 13:56:35 IST FATAL: the database system is starting up
2011-06-18 13:56:36 IST FATAL: the database system is starting up
2011-06-18 13:56:37 IST FATAL: the database system is starting up
2011-06-18 13:56:38 IST FATAL: the database system is starting up
2011-06-18 13:56:39 IST FATAL: the database system is starting up
.
.
.
.and same message continues..

I have attached the configuration files of standby server. Please help
me if anybody have any such experience or know the exact cause of the issue.

Regards,
Sanjay

Attachment Content-Type Size
pg_hba.conf text/plain 3.7 KB
postgresql.conf text/plain 18.2 KB
recovery.conf text/plain 4.2 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nithya Rajendran 2011-06-18 09:22:18 While converting the Master to Standby , FATAL: timeline 2 of the primary does not match recovery target timeline 1
Previous Message Greg Smith 2011-06-18 07:22:41 Re: Another RAID controller recommendation question