RE: Libpq support to connect to standby server as priority

Поиск
Список
Период
Сортировка
Искать
От
tsunakawa.takay@fujitsu.com
Тема
RE: Libpq support to connect to standby server as priority
Дата
Msg-id
TYAPR01MB2990DC03906F589DFF22D35BFE400@TYAPR01MB2990.jpnprd01.prod.outlook.com
Ответ на
Список
Дерево обсуждения
Libpq support to connect to standby server as priority Jing Wang <jingwangian@gmail.com>
RE: Libpq support to connect to standby server as priority "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: Libpq support to connect to standby server as priority Jing Wang <jingwangian@gmail.com>
Re: Libpq support to connect to standby server as priority Jing Wang <jingwangian@gmail.com>
From: Robert Haas 
> I think it would be better to have read-write and read-only check
> trnasaction_read_only, and primary and standby can check the new
> thing. There can never be any real advantage in having synonyms for
> the same thing, but there can be an advantage to letting users choose
> the behavior they want.

+1
"primary" is not always equal to "read-write".  When normal users are only allowed to query data on a logically replicated database (ALTER USER SET default_transaction_read_only = on), it's the primary read-only server.


Regards
Takayuki Tsunakawa



В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата:
От: Michael Paquier
Дата:
FAQ