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 ignore
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 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 u
"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 won
'm thinking of dumping all 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
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
> mmd
ate0|
> > |cells_dev|
> > |stdb2|
> > |stdb|
> > |stdb_standby|
> > |cells|
> > (8 rows)
> >
> >
> >
> >
> >
> > -Original Message-
> > From: Scott Marlowe [mailto:[EMAIL PROTECTED]
> > Sent
h 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
> <[EMAIL PROTECTED]> wrote:
> >
> >
&g
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 does
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
10 matches
Mail list logo