Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, 12 Mar 2008 21:30:57 -0700
"Scott Marlowe" <scott.marlowe@xxxxxxxxx> wrote:

> You might want to keep this one on the list.  I'm out of my league
> with this one I think

Can you pg_dump the database? What about vacuum? What does:

SELECT * FROM pg_database; Return?

J


> 
> On Wed, Mar 12, 2008 at 11:24 AM, Gauthier, Dave
> <dave.gauthier@xxxxxxxxx> wrote:
> > stdb2=#  select '|'||datname||'|' from pg_database ;
> >     ?column?
> >  ----------------
> >   |postgres|
> >   |template1|
> >   |template0|
> >   |cells_dev|
> >   |stdb2|
> >   |stdb|
> >   |stdb_standby|
> >   |cells|
> >  (8 rows)
> >
> >
> >
> >
> >
> >  -----Original Message-----
> >  From: Scott Marlowe [mailto:scott.marlowe@xxxxxxxxx]
> >  Sent: Wednesday, March 12, 2008 1:22 PM
> >  To: Gauthier, Dave
> >  Cc: pgsql-general@xxxxxxxxxxxxxx
> >  Subject: Re:  Can't rename an existnig DB because it
> > doesn't exist???
> >
> >  On Wed, Mar 12, 2008 at 10:03 AM, Gauthier, Dave
> >  <dave.gauthier@xxxxxxxxx> 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 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 databases
> >  >
> >  >      Name     |  Owner   | Encoding
> >  >
> >  > --------------+----------+----------
> >  >  stdb         | dfgauthi | UTF8
> >  >
> >  >  stdb2        | dfgauthi | UTF8
> >  >
> >  >  stdb_standby | dfgauthi | UTF8
> >
> >  Very strange.  maybe the name has a space in it?
> >
> >  Try running this query:
> >   select '|'||datname||'|' from pg_database ;
> >  and see if you have a space or something in there.  can you run the
> >  alter database rename from the command line and just not from psql?
> >
> 


-- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit

Attachment: signature.asc
Description: PGP signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux