Stephen Frost <sfr...@snowman.net> writes: > * Andres Freund (and...@anarazel.de) wrote: >> On 2021-04-20 14:56:58 -0400, Tom Lane wrote: >>> I wonder though whether we really need authentication here. pg_ping >>> already exposes whether the database is up, to anyone who can reach the >>> postmaster port at all. Would it be so horrible if the "can't accept >>> connections" error message included a detail about "recovery is X% >>> done"?
>> Unfortunately I think something like a percentage is hard to calculate >> right now. > While it obviously wouldn't be exactly accurate, I wonder if we couldn't > just look at the WAL files we have to reply and then guess that we'll go > through about half of them before we reach the end..? I mean, wouldn't > exactly be the first time that a percentage progress report wasn't > completely accurate. :) Or we could skip all the guessing and just print something like what the startup process exposes in ps status, ie "currently processing WAL file so-and-so". regards, tom lane