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