RE: Libpq support to connect to standby server as priority - Mailing list pgsql-hackers

From tsunakawa.takay@fujitsu.com
Subject RE: Libpq support to connect to standby server as priority
Date
Msg-id TYAPR01MB2990DC03906F589DFF22D35BFE400@TYAPR01MB2990.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: Libpq support to connect to standby server as priority  (Robert Haas <robertmhaas@gmail.com>)
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: security_context_t marked as deprecated in libselinux 3.1
Next
From: Michael Paquier
Date:
Subject: Re: 回复:how to create index concurrently on partitioned table