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