| From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
|---|---|
| To: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
| Cc: | akp geek <akpgeek(at)gmail(dot)com>, Chris Travers <chris(dot)travers(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Postgres replication question :- One master 2 slaves 9.0.10 |
| Date: | 2013-10-03 04:34:56 |
| Message-ID: | CAJKUy5iBC7g-jmqrS2R6Vt2a_C85sQ32=O0zcZnrUVW3eGuGxg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Oct 1, 2013 at 10:48 PM, Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> wrote:
> On Tue, Oct 1, 2013 at 6:15 PM, Jaime Casanova <jaime(at)2ndquadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | saritha N | 2013-10-03 07:35:12 | Unable to convert xpath value to date |
| Previous Message | KONDO Mitsumasa | 2013-10-03 00:32:27 | Re: Who is pgFoundery administrator? |