On Tue, Oct 1, 2013 at 5:46 PM, Sergey Konoplev <gray...@gmail.com> wrote: > On Tue, Oct 1, 2013 at 2:03 PM, akp geek <akpg...@gmail.com> wrote: >> One more thing.. pardon me for being dumb >> >> I want to set the 2 nd slave as HOT STAND BY, not steaming .. > > Hot standby assumes being streaming. You can not establish a hot > standby without using streaming replication. What is the reason not to > do it streaming? >
Ah! why? you don't need to use streaming replication for a hot standby, it works perfectly well even if you replay everything from archive and never do streaming. but it would be a good idea to set hot_standby_feedback to on and max_standby_archive_delay to something larger than 30s -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
