From: "Good, Thomas" <TGood@svwsjmc.org>
To: John DeSoi <desoi@pgedit.com>
CC: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Date: Thu, 17 Mar 2011 13:27:22 -0400
Subject: Re: Bizarreness at A2 Hosting
Thread-Topic: [SQL] Bizarreness at A2 Hosting
Thread-Index: AcvkxXbJnVJbwR95Q8iHW24lWXpytAAAxyQq
Message-ID: <C3FA421FEED237488E9820D1ED668F330AB5ABC8@SVWEMAIL>
References: <C3FA421FEED237488E9820D1ED668F330AB5ABC7@SVWEMAIL>,
	<82BDCB41-761A-4615-B591-EB83FB492792@pgedit.com>
In-Reply-To: <82BDCB41-761A-4615-B591-EB83FB492792@pgedit.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

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 c=
an't access his data..."

egads

________________________________________
From: John DeSoi [desoi@pgedit.com]
Sent: Thursday, March 17, 2011 1:05 PM
To: Good, Thomas
Cc: pgsql-sql@postgresql.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 supe=
rvisor 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 sa=
me host?


John DeSoi, Ph.D.