From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | want to drop corrupt db |
Date: | 2007-08-02 18:20:44 |
Message-ID: | D7FF158337303A419CF4A183F48302D602EDEF9F@hdsmsx411.amr.corp.intel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ben | 2007-08-02 18:37:59 | Re: Linux distro |
Previous Message | Andrej Ricnik-Bay | 2007-08-02 18:18:01 | Re: Linux distro |