Re: 'startup waiting' status message

"Jim C. Nasby" <jnasby@pervasive.com> writes:
> postgres  2038  0.0  0.2 19628 3328 ?        S    15:04   0:00 postgres:
> aspadmin test 192.168.100.7(34223) startup waiting

> I've grepped through the source code (grep -ri startup src|grep -i
> waiting) and can't find this anywhere...

You wouldn't, because that's a composite of two messages: we are waiting
for some lock while still in startup mode.  A reasonable bet is that
someone's got a more-or-less-exclusive lock on one of the system
catalogs that startup needs to read.  The contents of pg_locks would
help, if this state persists long enough to investigate ...
        regards, tom lane