PostgreSQL 19 introduces a new `%i` prompt escape for psql that displays whether the connected server is a primary or standby (hot standby). When added to PROMPT1 in `.psqlrc`, the prompt shows `[[primary]]` or `[[standby]]` at a glance, making it easier to distinguish server roles in replicated environments without manually calling `pg_is_in_recovery()`.

2m read timeFrom depesz.com
Post cover image

Sort: