Re: postgres 9 streaming replication

Hi,

Pls find below logfile of standby and recovery.conf in standby data directo=
ry.

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 fi=
le or directory
LOG:  unexpected pageaddr 0/30000000 in log file 0, segment 56, offset 0
cp: cannot stat `/db/postgres/archive/000000010000000000000038': No such fi=
le 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 di=
rectory
LOG:  selected new timeline ID: 2
cp: cannot stat `/db/postgres/archive/00000001.history': No such file or di=
rectory
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.fujii@gmail.com]=20
Sent: Tuesday, January 25, 2011 3:38 PM
To: Khadtare, Sharad
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] postgres 9 streaming replication

On Tue, Jan 25, 2011 at 5:01 PM, Khadtare, Sharad <sharad.khadtare@teamaol.=
com> wrote:
> Configured postgres 9 streaming replication and changed parameter in=20
> postgresql.conf & pg_hba.conf file
>
> Problem is wal sender & receiver process not started , is there any=20
> 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 o=
r elsewhere?

Regards,

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