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
