Re: postgres 9 streaming replication

Hi,

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
LOG: redo done at 0/370000D8
LOG: restored log file "000000010000000000000037" from archive
cp: cannot stat `/db/postgres/archive/00000002.history': No such file or directory
LOG: selected new timeline ID: 2
cp: cannot stat `/db/postgres/archive/00000001.history': No such file or directory
LOG: archive recovery complete
LOG: autovacuum launcher started
LOG: database system is ready to accept connections

Regards,
Sharad k

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

On Tue, Jan 25, 2011 at 5:01 PM, Khadtare, Sharad <sharad(dot)khadtare(at)teamaol(dot)com> wrote:
> Configured postgres 9 streaming replication and changed parameter in
> postgresql.conf & pg_hba.conf file
>
> Problem is wal sender & receiver process not started , is there any
> way to check process please suggest.

What log messages did you get right after starting the standby?

Did you locate the recovery.conf in PostgreSQL's data directory, not /etc or elsewhere?

Regards,

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