about pg14 new parameter in_hot_standby
in the pg14 document(https://www.postgresql.org/docs/14/runtime-config-preset.html)
in_hot_standby parameter:
Reports whether the server is currently in hot standby mode.
When this is on, all transactions are forced to be read-only.
Within a session, this can change only if the server is promoted to be primary. See Section 27.4 for more information.
"Within a session, this can change only if the server is promoted to be primary"--- I can not understand this statement.
I think document will tell us:
when the postgresql cluster is in the standby database role, the standby database parameter in_hot_standby value will change to on，and this in_hot_standby parameter can not been modified in the session.
I do not know what I say is correct or not.
On Sun, May 22, 2022 at 11:59:15AM +0800, yanliang lei wrote:
in the pg14 document(https://www.postgresql.org/docs/14/
runtime-config-preset.html)in_hot_standby parameter:
Reports whether the server is currently in hot standby mode.
When this is on, all transactions are forced to be read-only.
Within a session, this can change only if the server is promoted to be primary.
See Section 27.4 for more information."Within a session, this can change only if the server is promoted to be
primary"--- I can not understand this statement.
It means when the server is in read/write mode, called "primary" mode vs
"standby" mode.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Indecision is a decision. Inaction is an action. Mark Batterson