public inbox for [email protected]
help / color / mirror / Atom feedabout pg14 new parameter in_hot_standby
2+ messages / 2 participants
[nested] [flat]
* about pg14 new parameter in_hot_standby
@ 2022-05-22 03:59 yanliang lei <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: yanliang lei @ 2022-05-22 03:59 UTC (permalink / raw)
To: [email protected] <[email protected]>
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: about pg14 new parameter in_hot_standby
@ 2022-05-24 23:57 Bruce Momjian <[email protected]>
parent: yanliang lei <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2022-05-24 23:57 UTC (permalink / raw)
To: yanliang lei <[email protected]>; +Cc: [email protected] <[email protected]>
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 <[email protected]> https://momjian.us
EDB https://enterprisedb.com
Indecision is a decision. Inaction is an action. Mark Batterson
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-05-24 23:57 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-05-22 03:59 about pg14 new parameter in_hot_standby yanliang lei <[email protected]>
2022-05-24 23:57 ` Bruce Momjian <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox