Re: [GENERAL] Can't rename an existnig DB because it doesn't exist???

2008-03-14 Thread Scott Marlowe
On Thu, Mar 13, 2008 at 10:45 AM, Dean Gibson (DB Administrator) 1. What SCHEMAs are these DBs in? Perhaps a search_path issue (I haven't followed all of this thread, so perhaps this has been mentioned). Tis the other way round I'm afriad. Schemas live in dbs, not the other way around.

Re: [GENERAL] Can't rename an existnig DB because it doesn't exist???

2008-03-14 Thread Dean Gibson (DB Administrator)
On 2008-03-13 23:14, Scott Marlowe wrote: Tis the other way round I'm afriad. Schemas live in dbs, not the other way around. Maybe you were thinking tablespaces? You're right; I was thinking of tables, which I routinely move around from schema to schema. That also means he should

Re: [GENERAL] Can't rename an existnig DB because it doesn't exist???

2008-03-13 Thread Dean Gibson (DB Administrator)
On 2008-03-12 21:30, Scott Marlowe wrote: ... Can't rename a db, complains that it doesn't exist. Yet psql -l shows that it does and I can connect to it ??? mmdcc228_SETUP(120)% psql stdb2 -c alter database stdb rename to stdb_tmp ERROR: database stdb does not exist

Re: [GENERAL] Can't rename an existnig DB because it doesn't exist???

2008-03-13 Thread Gauthier, Dave
the problem DBs, deleting them, recreating and reloading. -dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean Gibson (DB Administrator) Sent: Thursday, March 13, 2008 12:45 PM To: pgsql-general Subject: Re: [GENERAL] Can't rename an existnig DB because

Re: [GENERAL] Can't rename an existnig DB because it doesn't exist???

2008-03-13 Thread Tom Lane
Gauthier, Dave [EMAIL PROTECTED] writes: Can't rename a db, complains that it doesn't exist. Yet psql -l shows that it does and I can connect to it ??? mmdcc228_SETUP(120)% psql stdb2 -c alter database stdb rename to stdb_tmp ERROR: database stdb does not exist Hmm, I wonder if this

Re: [GENERAL] Can't rename an existnig DB because it doesn't exist???

2008-03-13 Thread Dean Gibson (DB Administrator)
On 2008-03-13 10:10, Gauthier, Dave wrote: Ya, I'm thinking of dumping all the problem DBs, deleting them, recreating and reloading. Last thought: have you tried uninstalling and reinstalling PostgreSQL? If something is corrupted on the disk, it's either the data or the software. An

[GENERAL] Can't rename an existnig DB because it doesn't exist???

2008-03-12 Thread Gauthier, Dave
V8.2.0 on Linux Can't rename a db, complains that it doesn't exist. Yet psql -l shows that it does and I can connect to it ??? mmdcc228_SETUP(120)% psql stdb2 -c alter database stdb rename to stdb_tmp ERROR: database stdb does not exist mmdcc228_SETUP(121)% psql -l List of

Re: [GENERAL] Can't rename an existnig DB because it doesn't exist???

2008-03-12 Thread Scott Marlowe
On Wed, Mar 12, 2008 at 10:03 AM, Gauthier, Dave [EMAIL PROTECTED] wrote: V8.2.0 on Linux Look into updating, there were some serious bugs fixed between 8.2.0 and 8.2.6 It's a pretty simple thing, since you don't need to dump / reload for it. Can't rename a db, complains that it doesn't

Re: [GENERAL] Can't rename an existnig DB because it doesn't exist???

2008-03-12 Thread Scott Marlowe
an existnig DB because it doesn't exist??? On Wed, Mar 12, 2008 at 10:03 AM, Gauthier, Dave [EMAIL PROTECTED] wrote: V8.2.0 on Linux Look into updating, there were some serious bugs fixed between 8.2.0 and 8.2.6 It's a pretty simple thing, since you don't need to dump / reload

Re: [GENERAL] Can't rename an existnig DB because it doesn't exist???

2008-03-12 Thread Joshua D. Drake
Message- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2008 1:22 PM To: Gauthier, Dave Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Can't rename an existnig DB because it doesn't exist??? On Wed, Mar 12, 2008 at 10:03 AM, Gauthier, Dave