Re: Postgres replication question :- One master 2 slaves 9.0.10 - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: Postgres replication question :- One master 2 slaves 9.0.10
Date
Msg-id CAL_0b1tKE1xJySd0b00+dOgVmS==kU1Hy9p79NonLV6FdFyZHg@mail.gmail.com
Whole thread Raw
In response to Re: Postgres replication question :- One master 2 slaves 9.0.10  (Jaime Casanova <jaime@2ndquadrant.com>)
Responses Re: Postgres replication question :- One master 2 slaves 9.0.10
List pgsql-general
On Tue, Oct 1, 2013 at 6:15 PM, Jaime Casanova <jaime@2ndquadrant.com> wrote:
> 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.

Right, I mixed up a with the terms a bit.

> 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?

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray.ru@gmail.com


pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: Largest PG database known to man!
Next
From: Sergey Konoplev
Date:
Subject: Re: Postgres replication question :- One master 2 slaves 9.0.10