Re: synchronous_standby_names with '*'

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

I think
set synchronous_commit to "off"
Disable synchronous commit only for this session (connect) not for postgres
instance, right?
Maybe I must chnage configuration and call "pg_ctl reload"? to change
deafult behaviour for postgres instance?

2011/8/19 Fujii Masao <masao(dot)fujii(at)gmail(dot)com>

> 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

Browse pgsql-general by date

  From Date Subject
Next Message DM 2011-08-19 12:50:58 MySQL -> PostgreSQL conversion issue
Previous Message Alexander Perepelica 2011-08-19 12:25:47 Re: synchronous_standby_names with '*'