Re: [HACKERS] Re: Clarifying "server starting" messaging in pg_ctlstart without --wait - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: [HACKERS] Re: Clarifying "server starting" messaging in pg_ctlstart without --wait
Date
Msg-id CAOuzzgozL-CWWTSD74-3zyRPJ0dB8Rgb66XDv=qYKhYB6agTyQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Re: Clarifying "server starting" messaging in pg_ctlstart without --wait  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [HACKERS] Re: Clarifying "server starting" messaging in pg_ctlstart without --wait  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers

On Wed, Jan 18, 2017 at 16:15 Robert Haas <robertmhaas@gmail.com> wrote:
On Wed, Jan 18, 2017 at 3:59 PM, Stephen Frost <sfrost@snowman.net> wrote:

> For non-cold standby configurations, pg_ctl is going to return just as

> soon as the database has finished crash recovery, which in most cases

> will probably be on the order of a few seconds.



/me is poleaxed.

--------

Yeah, that was a confused sentence- most of the time it's going to return on the order of a few seconds because we're doing regular startup without having to do any crash recovery. 

For actual crash recovery cases, it'll take between a few seconds and checkpoint_timeout, as I described up-thread, based on the amount of outstanding WAL.  

Thanks!

Stephen

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] Re: Clarifying "server starting" messaging in pg_ctlstart without --wait
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] [PATCH] fix typo in commit a4523c5