pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedBizarreness at A2 Hosting
3+ messages / 2 participants
[nested] [flat]
* Bizarreness at A2 Hosting
@ 2011-03-17 16:26 Good, Thomas <TGood@svwsjmc.org>
2011-03-17 17:05 ` Re: Bizarreness at A2 Hosting John DeSoi <desoi@pgedit.com>
0 siblings, 1 reply; 3+ messages in thread
From: Good, Thomas @ 2011-03-17 16:26 UTC (permalink / raw)
To: pgsql-sql
I realize this is not the right list for this question but I am just flabbergasted, am only on one list, and, know Tom Lane is here so, please excuse...
Here is the deal:
On a2 hosting I do the following:
1) create a new database in cpanel
2) login via psql
3) run \d
AND - there is ALREADY a table belonging to another user (not a privileged user, another account owner)
I can see this guy's schema but can't access the data. (I guess that's a positive)
I have repeated this three times so far...after I created a db, populated it and found a table that wasn't mine I created a test db that should have been empty.
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.
thanks much
--
Thomas A. Good, Senior Database Administrator
Saint Vincent's Hospital Westchester
A Division of Saint Joseph's Medical Center
Residential Services
75 Vanderbilt Avenue, Room 5-47
Staten Island, NY 10304
718.818.5528
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Bizarreness at A2 Hosting
2011-03-17 16:26 Bizarreness at A2 Hosting Good, Thomas <TGood@svwsjmc.org>
@ 2011-03-17 17:05 ` John DeSoi <desoi@pgedit.com>
2011-03-17 17:27 ` Re: Bizarreness at A2 Hosting Good, Thomas <TGood@svwsjmc.org>
0 siblings, 1 reply; 3+ messages in thread
From: John DeSoi @ 2011-03-17 17:05 UTC (permalink / raw)
To: Good, Thomas <TGood@svwsjmc.org>; +Cc: pgsql-sql
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Bizarreness at A2 Hosting
2011-03-17 16:26 Bizarreness at A2 Hosting Good, Thomas <TGood@svwsjmc.org>
2011-03-17 17:05 ` Re: Bizarreness at A2 Hosting John DeSoi <desoi@pgedit.com>
@ 2011-03-17 17:27 ` Good, Thomas <TGood@svwsjmc.org>
0 siblings, 0 replies; 3+ messages in thread
From: Good, Thomas @ 2011-03-17 17:27 UTC (permalink / raw)
To: John DeSoi <desoi@pgedit.com>; +Cc: pgsql-sql
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@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 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-03-17 17:27 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-03-17 16:26 Bizarreness at A2 Hosting Good, Thomas <TGood@svwsjmc.org>
2011-03-17 17:05 ` John DeSoi <desoi@pgedit.com>
2011-03-17 17:27 ` Good, Thomas <TGood@svwsjmc.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox