Thread: Cannot createdb a database I just "destroydb"'d

Please help - in order to solve the problem of a VERY large pg_log file,
I used "destroydb" to destroy the database, nulled the pg_log file and
then tried to "createdb" the database in order to restore the data. I
get a "database already exists" error even though it does not appear in
the /base directory.

Any help would be greatly appreciated.

John Pilley <jpilley@spescrow.com> writes:
> Please help - in order to solve the problem of a VERY large pg_log file,
> I used "destroydb" to destroy the database, nulled the pg_log file and
                                              ^^^^^^^^^^^^^^^^^^^^^^

That was a real bad move.  I think you have no useful recovery method
short of initdb now :-(.  Hope you have a recent backup of your other
databases...

            regards, tom lane