Re: [GENERAL] startup process stuck in recovery

On 11 October 2017 at 08:09, Christophe Pettus <xof@thebuild.com> wrote:
>
>> On Oct 10, 2017, at 23:54, Simon Riggs <simon@2ndQuadrant.com> wrote:
>>
>> The use case described seems incredibly
>> unreal and certainly amenable to being rewritten.
>
> While it's certainly true that this was an extreme case, it was a real-life production situation.  The concern here
isthat in the actual production situation, the only symptom was that the startup process just stopped.  There were no
logmessages or any other indication of what was going wrong. 

Which indicates it was making progress, just slowly.

Tom says "This is pretty easy to diagnose though
because it spews "out of shared memory" WARNING messages to the
postmaster log at an astonishing rate"

These don't seem to match.

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general