want to drop corrupt db

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

Responses

Browse pgsql-general by date

  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