After a db restore failed for reasons having to do with lack of disk space, when I try to restart the DB, I get...
dfg_suse> postmaster -D /proj/cad_sserv/cellibcmp/daveg/Postgres/DB -i > /proj/cad_sserv/cellibcmp/daveg/Postgres/postmaster.log &
[1] 29644
dfg_suse> 2007-08-02 14:17:14 LOG: database system was interrupted while in recovery at 2007-08-02 14:16:21 EDT
HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2007-08-02 14:17:14 LOG: checkpoint record is at B/258A7100
2007-08-02 14:17:14 LOG: redo record is at A/A700B9C0; undo record is at 0/0; shutdown FALSE
2007-08-02 14:17:14 LOG: next transaction ID: 64132; next OID: 73638687
2007-08-02 14:17:14 LOG: database system was not properly shut down; automatic recovery in progress
2007-08-02 14:17:14 PANIC: could not fsync control file: Disk quota exceeded
2007-08-02 14:17:14 LOG: startup process (PID 29647) was terminated by signal 6
2007-08-02 14:17:14 LOG: aborting startup due to startup process failure
[1] Exit 1 postmaster -D /proj/cad_sserv/cellibcmp/daveg/Postgres/DB -i > ...
dfg_suse>
If the DB is trashed, how can I just delete it and start from scratch?
Thanks
-dave