Re: Bizarreness at A2 Hosting

Hi John,

No the two hosts are separate and so it's two separate pg templates.
The techie told me, "well, it's ok, because you can see his table but you can't access his data..."

egads

________________________________________
From: John DeSoi [desoi(at)pgedit(dot)com]
Sent: Thursday, March 17, 2011 1:05 PM
To: Good, Thomas
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Bizarreness at A2 Hosting

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.