Thanks for all suggestions. based on the constraints I had with network, I could able to set up the warm stand by. I am seeing the following log file
I don't know to how to handle. 2013-10-03 17:52:00 GMT [27636]: [457-1] user=,db=LOG: restored log file "00000001000001F600000003" from archive scp:/archive/00000001000001F600000004: No such file or directory *2013-10-03 17:52:02 GMT [27636]: [458-1] user=,db=LOG: unexpected pageaddr 1F5/34000000 in log file 502, segment 4, offset 0* Regards On Thu, Oct 3, 2013 at 12:34 AM, Jaime Casanova <ja...@2ndquadrant.com>wrote: > On Tue, Oct 1, 2013 at 10:48 PM, Sergey Konoplev <gray...@gmail.com> > wrote: > > On Tue, Oct 1, 2013 at 6:15 PM, Jaime Casanova <ja...@2ndquadrant.com> > wrote: > > > >> but it would be a good idea to set hot_standby_feedback to on and > >> max_standby_archive_delay to something larger than 30s > > > > Doesn't replica need a connection to master for hot_standby_feedback? > > > > doh! yes, it needs it... > > vacuum_defer_cleanup_age it's the one you should set if never do > streaming... but, of course, that is not accurate enough > > -- > Jaime Casanova www.2ndQuadrant.com > Professional PostgreSQL: Soporte 24x7 y capacitación > Phone: +593 4 5107566 Cell: +593 987171157 >
