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