Re: synchronous_standby_names with '*'

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: alexondi <alexondi(at)rambler(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: synchronous_standby_names with '*'
Date: 2011-08-19 11:48:13
Message-ID: CAHGQGwEui2MmymQMpwfRK56LLKZM7zu34ZKkNZMmw0Br8Pf4KA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 19, 2011 at 8:39 PM, alexondi <alexondi(at)rambler(dot)ru> wrote:
> so can I somehow disable|enable synchronous replication at runtime (not only
> for session but for the server)?

Yes.

To disable;
Empty synchronous_standby_names, or set synchronous_commit to "local" or "off".

To enable;
Set synchronous_standby_names or set synchronous_commit to "on".

And then reload the configuration file.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Misa Simic 2011-08-19 12:17:47 UUID datatype and GIST index support
Previous Message Simon Riggs 2011-08-19 11:44:41 Re: synchronous_standby_names with '*'