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
обсуждение исходный текст
Ответ на Re: Libpq support to connect to standby server as priority  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
From: Robert Haas <robertmhaas@gmail.com>
> 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
replicateddatabase (ALTER USER SET default_transaction_read_only = on), it's the primary read-only server.
 


Regards
Takayuki Tsunakawa




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: security_context_t marked as deprecated in libselinux 3.1
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: 回复:how to create index concurrently on partitioned table