Re: postgres 9 streaming replication

Hi,

Problem solved after removing trigger entry from recovery.conf file

Thx for help

Regards,
Sharad K

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

On Tue, Jan 25, 2011 at 8:59 PM, Khadtare, Sharad <sharad(dot)khadtare(at)teamaol(dot)com> wrote:
> Pls find below logfile of standby and recovery.conf in standby data directory.
>
> bash-3.2$ cat logfile
> LOG:  database system was interrupted while in recovery at log time
> 2011-01-25 05:28:35 EST
> HINT:  If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.
> LOG:  entering standby mode
> LOG:  restored log file "000000010000000000000037" from archive
> LOG:  redo starts at 0/37000020
> LOG:  consistent recovery state reached at 0/38000000
> LOG:  database system is ready to accept read only connections
> cp: cannot stat `/db/postgres/archive/000000010000000000000038': No
> such file or directory
> LOG:  unexpected pageaddr 0/30000000 in log file 0, segment 56, offset
> 0
> cp: cannot stat `/db/postgres/archive/000000010000000000000038': No
> such file or directory
> LOG:  trigger 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 backup 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