Re: display hot standby state in psql prompt

Nathan Bossart <nathandbossart@gmail.com>

From: Nathan Bossart <nathandbossart@gmail.com>

To: Jim Jones <jim.jones@uni-muenster.de>

Cc: Srinath Reddy Sadipiralla <srinath2133@gmail.com>, Greg Sabino Mullane <htamfids@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-10-24T14:12:47Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

psql: Add %i prompt escape to indicate hot standby status.
- dddbbc253b92 19 (unreleased) landed
Mark search_path as GUC_REPORT
- 28a1121fd912 18.0 cited

On Fri, Oct 24, 2025 at 01:07:41AM +0200, Jim Jones wrote:
> Although I prefer it being explicit in this case, I can live with either
> approach. Do you think we should go for "ro" or "rw"?

I'm currently leaning towards ro/rw, but I'm also hoping that others chime
in with opinions here.

-- 
nathan