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 |
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 |