Re: synchronous_standby_names with '*'

Поиск
Список
Период
Сортировка
От Alexander Perepelica
Тема Re: synchronous_standby_names with '*'
Дата
Msg-id CAAXZ8mcXNUy4jN0SFsvP6zyYt66btzC9ucZZ1Ps9Byh9aWGeaQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: synchronous_standby_names with '*'  (Fujii Masao <masao.fujii@gmail.com>)
Список 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.fujii@gmail.com>
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 по дате отправления:

Предыдущее
От: Alexander Perepelica
Дата:
Сообщение: Re: synchronous_standby_names with '*'
Следующее
От: DM
Дата:
Сообщение: MySQL -> PostgreSQL conversion issue