Postgres Pro
Downloads
Home   >   mailing lists

Re: synchronous_standby_names with '*' - Mailing list pgsql-general

From Fujii Masao
Subject Re: synchronous_standby_names with '*'
Date
Msg-id CAHGQGwEui2MmymQMpwfRK56LLKZM7zu34ZKkNZMmw0Br8Pf4KA@mail.gmail.com
Whole thread Raw
In response to Re: synchronous_standby_names with '*'  (alexondi <alexondi@rambler.ru>)
Responses Re: synchronous_standby_names with '*'
List pgsql-general
Tree view 
On Fri, Aug 19, 2011 at 8:39 PM, alexondi <alexondi@rambler.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

pgsql-general by date:

Previous
From: alexondi
Date:
Subject: Re: synchronous_standby_names with '*'
Next
From: Misa Simic
Date:
Subject: UUID datatype and GIST index support