Catch-22 - Mailing list pgsql-general

From Gauthier, Dave
Subject Catch-22
Date
Msg-id 0836165E8EE50F40A3DD8F0D8713726720C4B0@azsmsx421.amr.corp.intel.com
Whole thread Raw
Responses Re: Catch-22  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

Hi:

 

After running intoa problem last week where I cannot rename an existing DB because it’s reported to not exist (I can attach to it and query OK, but rename gives... “database foo does not exist”), I’ve done a full dump of the DB and want to delete/recreate it with the backup. But I can’t “dropdb” because “database foo does not exist”.

 

What’s the course I should take at this point?  I could “rm –r” the DB root (the piece after the “-D” in pg_ctl commands), but that may screw things up even worse. 


Again, I have a backup and want to delete the DB, but can’t because the “dropdb” tool says the DB does not exist.

 

v8.2.0 on Linux (and yes, I’ve requested an upgrade to 8.2.6)

 

 

-dave

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: shared memory/max_locks_per_transaction error
Next
From: Erik Jones
Date:
Subject: Re: postgre vs MySQL