From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | Junwang Zhao <zhjwpku(at)gmail(dot)com> |
Cc: | Nathan Bossart <nathandbossart(at)gmail(dot)com>, Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>, Crisp Lee <litianxiang01(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers(at)lists(dot)postgresql(dot)org, Bruce Momjian <bruce(at)momjian(dot)us> |
Subject: | Re: make pg_ctl more friendly |
Date: | 2024-01-17 08:53:58 |
Message-ID: | 202401170853.oe4gvq4ocaki@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I think this needs more comments. First, in the WaitPMResult enum, we
currently have three values -- READY, STILL_STARTING, FAILED. These are
all pretty self-explanatory. But this patch adds SHUTDOWN_IN_RECOVERY,
and that's not at all self-explanatory. Did postmaster start or not?
The enum value's name doesn't make that clear. So I'd do something like
typedef enum
{
POSTMASTER_READY,
POSTMASTER_STILL_STARTING,
/*
* postmaster no longer running, because it stopped after recovery
* completed.
*/
POSTMASTER_SHUTDOWN_IN_RECOVERY,
POSTMASTER_FAILED,
} WaitPMResult;
Maybe put the comments in wait_for_postmaster_start instead.
Secondly, the patch proposes to add new text to be returned by
do_start() when this happens, which would look like this:
waiting for server to start... shut down while in recovery
update recovery target settings for startup again if needed
Is this crystal clear? I'm not sure. How about something like this?
waiting for server to start... done, but not running
server shut down because of recovery target settings
variations on the first phrase:
"done, no longer running"
"done, but no longer running"
"done, automatically shut down"
"done, automatically shut down after recovery"
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"Now I have my system running, not a byte was off the shelf;
It rarely breaks and when it does I fix the code myself.
It's stable, clean and elegant, and lightning fast as well,
And it doesn't cost a nickel, so Bill Gates can go to hell."
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Guo | 2024-01-17 09:01:36 | Re: Oversight in reparameterize_path_by_child leading to executor crash |
Previous Message | Maiquel Grassi | 2024-01-17 08:52:33 | RE: New Window Function: ROW_NUMBER_DESC() OVER() ? |