On Mar 17, 2011, at 12:26 PM, Good, Thomas wrote:
> 4) try to run pg_dump - it fails as it is unable to lock this other guy's table
>
> tech suppt argues with me that their template is not hosed, "that is the nature of postgre," he said (not a typo, he
omittedthe trailing s)
>
> These guys are recommended by postgresql.org so I figured I'd try em...
> I have another account (for a client whom I support pro bono) and they do not have this problem. New databases are
emptyas one would expect.
>
> Can someone tell me what exactly the problem is - I am waiting for a supervisor to call me back and I'd like to lead
himto the answer so he can fix the problem.
I think you are right -- they likely have some one's stuff in the template database. On your account that does not have
theproblem -- is it on the same host?
John DeSoi, Ph.D.