about pg14 new parameter in_hot_standby

From: "yanliang lei" <msdnchina(at)163(dot)com>
To: "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: about pg14 new parameter in_hot_standby
Date: 2022-05-22 03:59:15
Message-ID: 4d053c3c.91d.180e9eb5298.Coremail.msdnchina@163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2022-05-24 12:36:18 Re: Documentation Suggestion
Previous Message Rajakavitha Kodhandapani 2022-05-21 15:03:50 Re: INVALID index while concurrent indexing in progress?