Downloads
Home   >   mailing lists

Re: display hot standby state in psql prompt - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: display hot standby state in psql prompt
Date
Msg-id CAKAnmm+qDTsofqT6ShjjpKn3+WMNovttomwO0mTYcZgg7R7kDQ@mail.gmail.com
Whole thread Raw
In response to display hot standby state in psql prompt  (Jim Jones <jim.jones@uni-muenster.de>)
Responses Re: display hot standby state in psql prompt
List pgsql-hackers
Tree view
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

--
Enterprise Postgres Software Products & Tech Support

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: pg_dump misses comments on NOT NULL constraints
Next
From: Nathan Bossart
Date:
Subject: Re: Fixes inconsistent behavior in vacuum when it processes multiple relations