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.
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
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
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
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
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
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
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
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
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
10 matches
Mail list logo