Re: [GENERAL] recovering a "lost" database

> i have a database that was "lost" -- the database is still there (i can
> see the files on disk in the database's directory), but when i try to
> connect to the database, it says that it doesn't exist in pg_database.
> what happened is that the database got dropped while the drive with the
> data on it was unmounted, but now that i thought about it, it would be
> nice to have a backup of it if i can get it. is there a way that i can
> manually add it to the pg_database table (and are there other tables i
> have to mess with?) so i can access it again?

Go into template1 database and insert a new row into the pg_database
table for the missing databases.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026