Search Postgresql Archives

want to drop corrupt db

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux