Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id B54821337B69 for ; Thu, 17 Mar 2011 14:05:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 55708-01 for ; Thu, 17 Mar 2011 17:05:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from a2s36.a2hosting.com (a2s36.a2hosting.com [216.119.134.130]) by mail.postgresql.org (Postfix) with ESMTP id DA40C1337C0D for ; Thu, 17 Mar 2011 14:05:07 -0300 (ADT) Received: from adsl-86-7-172.tys.bellsouth.net ([98.86.7.172] helo=[10.0.0.18]) by a2s36.a2hosting.com with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.69) (envelope-from ) id 1Q0GdF-0002Ea-Fs; Thu, 17 Mar 2011 13:05:06 -0400 Subject: Re: Bizarreness at A2 Hosting Mime-Version: 1.0 (Apple Message framework v1082) Content-Type: text/plain; charset=us-ascii From: John DeSoi In-Reply-To: Date: Thu, 17 Mar 2011 13:05:03 -0400 Cc: "pgsql-sql@postgresql.org" Content-Transfer-Encoding: quoted-printable Message-Id: <82BDCB41-761A-4615-B591-EB83FB492792@pgedit.com> References: To: "Good, Thomas" X-Mailer: Apple Mail (2.1082) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - a2s36.a2hosting.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - pgedit.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.399 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FM_IS_IT_OUR_ACCOUNT=2.299 X-Spam-Level: X-Archive-Number: 201103/26 X-Sequence-Number: 35228 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 >=20 > 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) >=20 > 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. >=20 > 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.