"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