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

From Jim Jones
Subject Re: display hot standby state in psql prompt
Date
Msg-id fe37eed0-7bff-46fd-bb6b-71d020b2bf44@uni-muenster.de
Whole thread Raw
In response to Re: display hot standby state in psql prompt  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: display hot standby state in psql prompt
List pgsql-hackers

On 27/01/2026 14:51, Fujii Masao wrote:
> It looks like the short description for %i is missing from the header comment
> at the top of get_prompt(). Could you add that?
> 
> 
> In the patch, nothing is shown when connected to PostgreSQL 13 or older
> (i.e., versions that do not report in_hot_standby). Would it be better to
> show "?", similar to what %S does?

It seems I reverted too much from the previous patch :)
Description added again.

> 
> 
> + else
> + buf[0] = '\0';
> + }
> + else
> + buf[0] = '\0';
> 
> The second "else + buf[0] = '\0'" does not seem necessary.

Here I was just following the style of other options, like %x

case 'x':
  if (!pset.db)
    buf[0] = '?';

Removed (let me know if I misunderstood your point here)

> 
> +        <listitem>
> +          <para>
> +            Indicates whether the server is in hot standby mode.
> 
> The indentation style for "<para>" and its contents seems to differ from
> the surrounding prompt option descriptions. For consistency, it might be
> better to match the existing style used nearby.


Indentation fixed.


> 
> 
> +            The value is shown as <literal>standby</literal> if the
> server reports
> +            <literal>in_hot_standby</literal> as <literal>on</literal>,
> 
> Would it be better to replace "<literal>in_hot_standby</literal>" with
> "<xref linkend="guc-in-hot-standby"/>"?
> 

Yes, it's indeed much better. Replaced <literal>in_hot_standby</literal>
with <xref linkend="guc-in-hot-standby"/>.

> As with %S, it would be helpful to explicitly document what is shown when
> connected to PostgreSQL 13 or older. For example, something like:
> 
> -----------------
> Indicates whether the connected server is running in hot standby mode.
> The value is shown as <literal>standby</literal> if the server is
> currently in hot standby and reports <xref
> linkend="guc-in-hot-standby"/> as <literal>on</literal>, and
> <literal>primary</literal> otherwise. This is useful when connecting
> to multiple servers to quickly determine the role of each connection.
> A value of <literal>?</literal> is shown when connected to a server
> running <productname>PostgreSQL</productname> 13 or older.
> -----------------

Added as you suggested.

Thanks for the quick review. Much appreciated!

Best, Jim
Attachment

pgsql-hackers by date:

Previous
From: vignesh C
Date:
Subject: Re: Skipping schema changes in publication
Next
From: "Jelte Fennema-Nio"
Date:
Subject: Re: meson: Make test output much more useful on failure (both in CI and locally)