Re: must synchronous_standby_names be set?

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Erik Rijkers <er(at)xs4all(dot)nl>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: must synchronous_standby_names be set?
Date: 2011-07-01 15:23:03
Message-ID: BANLkTimOW61sA+-Dut7VGAVshCTXwJSWaw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

> 2. Does sync-repl really need synchronous_standby_names to be set?

Yes

Unset => "synchronise with zero servers" => asynchronous

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jaime Casanova 2011-07-01 16:28:29 Re: must synchronous_standby_names be set?
Previous Message Robert Haas 2011-07-01 14:32:08 Re: relpersistence and temp table