On Tue, Oct 1, 2013 at 5:46 PM, Sergey Konoplev <[email protected]> wrote: > On Tue, Oct 1, 2013 at 2:03 PM, akp geek <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
