Catch-22

["Gauthier, Dave" <dave.gauthier@xxxxxxxxx>]

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