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.fu...@gmail.com] 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.khadt...@teamaol.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
