Re: postgres 9 streaming replication

Hi,

Problem solved after removing trigger entry from recovery.conf file

Thx for help

Regards,
Sharad K=20

-----Original Message-----
From: Fujii Masao [mailto:masao.fujii@gmail.com]=20
Sent: Tuesday, January 25, 2011 5:55 PM
To: Khadtare, Sharad
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] postgres 9 streaming replication

On Tue, Jan 25, 2011 at 8:59 PM, Khadtare, Sharad <sharad.khadtare@teamaol.=
com> wrote:
> Pls find below logfile of standby and recovery.conf in standby data direc=
tory.
>
> bash-3.2$ cat logfile
> LOG: =A0database system was interrupted while in recovery at log time=20
> 2011-01-25 05:28:35 EST
> HINT: =A0If this has occurred more than once some data might be corrupted=
 and you might need to choose an earlier recovery target.
> LOG: =A0entering standby mode
> LOG: =A0restored log file "000000010000000000000037" from archive
> LOG: =A0redo starts at 0/37000020
> LOG: =A0consistent recovery state reached at 0/38000000
> LOG: =A0database system is ready to accept read only connections
> cp: cannot stat `/db/postgres/archive/000000010000000000000038': No=20
> such file or directory
> LOG: =A0unexpected pageaddr 0/30000000 in log file 0, segment 56, offset=
=20
> 0
> cp: cannot stat `/db/postgres/archive/000000010000000000000038': No=20
> such file or directory
> LOG: =A0trigger file found: /db/postgres/trigger

The above message means that you created the trigger file and promoted the =
standby server to the master. Since the standby was running as the master, =
walreceiver was not invoked in the standby.

To start replication, you need to create the standby (taking the base backu=
p from the master is required) and start it after you
*ensure* that there is no trigger file in the standby.

I hope this helps..

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center