Re: must synchronous_standby_names be set?

From: "Jaime Casanova" <jaime(at)2ndquadrant(dot)com>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Erik Rijkers <er(at)xs4all(dot)nl>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: must synchronous_standby_names be set?
Date: 2011-07-01 16:28:29
Message-ID: 8739iq2ceq.fsf@casanova1.SEINGALT
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:

> On Fri, Jul 1, 2011 at 2:42 PM, Erik Rijkers <er(at)xs4all(dot)nl> wrote:
>
>> Two questions:
>>
>> 1. How to query a session to make absolutely sure that replication is actually synchronous?
>
> Check synchronous_standby_names and synchronous commit for appropriate values.
>

also check pg_stat_replication

--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL
Soporte 24x7, desarrollo, capacitación y servicios

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Torello Querci 2011-07-01 17:31:30 Re: pg_terminate_backend and pg_cancel_backend by not administrator user
Previous Message Simon Riggs 2011-07-01 15:23:03 Re: must synchronous_standby_names be set?