Postgres Pro
Downloads
Home   >   mailing lists

Re: must synchronous_standby_names be set? - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: must synchronous_standby_names be set?
Date
Msg-id 8739iq2ceq.fsf@casanova1.SEINGALT
Whole thread Raw
In response to Re: must synchronous_standby_names be set?  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Tree view 
Simon Riggs <simon@2ndQuadrant.com> writes:

> On Fri, Jul 1, 2011 at 2:42 PM, Erik Rijkers <er@xs4all.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

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: must synchronous_standby_names be set?
Next
From: Torello Querci
Date:
Subject: Re: pg_terminate_backend and pg_cancel_backend by not administrator user