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

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


pgsql-general by date:

Previous
From: KONDO Mitsumasa
Date:
Subject: Re: [HACKERS] Who is pgFoundery administrator?
Next
From: saritha N
Date:
Subject: Unable to convert xpath value to date