daveg <daveg@sonic.net> writes:
> It does not seem restricted to pg_authid:
> 2011-08-24 18:35:57.445 24987 c23 apps ERROR: lock AccessShareLock on object 16403/2615/0
> And I think I've seen it on other tables too.
Hmm. 2615 = pg_namespace, which most likely is the first catalog
accessed by just about any SQL command that's going to access tables at
all, so I suspect that this is mostly just a "the first access failed"
thing and not something peculiar to pg_namespace. But we still don't
have a clue why the locks are not getting released by the previous
owner of the PGPROC slot. Have you trawled your logs to see if there's
any sign of any distress at all, shortly before the problem starts to
happen?
regards, tom lane