"Chris Waters" <chris.waters@networkchemistry.com> writes:
> My first instinct was a stale lock so I look in pg_locks and sure enough a
> lock exists. Now the question is, how do I free this lock? This is just a
> single machine installation and there are no processes running that could
> hold the lock.
Oh? Exactly what process does pg_locks show is holding the lock then?
> How do people normally deal with this type of problem?
Either you're misdescribing it, or it's not a normal type of problem.
regards, tom lane