Thread

Re: display hot standby state in psql prompt

Greg Sabino Mullane <htamfids@gmail.com> — 2025-06-25T15:17:54Z

On Wed, Jun 25, 2025 at 4:02 AM Jim Jones <jim.jones@uni-muenster.de> wrote:

>     if (pset.db && PQparameterStatus(pset.db, "in_hot_standby"))
>

Seems transaction_read_only might be a more useful thing to examine? That's
the side-effect, if you will, that people really care about when in hot
standby mode (and of course, we can get into TRO other ways).

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support