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
