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
>
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 '*' |