| 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: | Whole Thread | Raw Message | 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 '*' |