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 omitted the 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 empty as 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 him to 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 the problem -- is it on the same host? John DeSoi, Ph.D. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
