Re: Regarding Vacuumdb
От | Jeff Eckermann |
---|---|
Тема | Re: Regarding Vacuumdb |
Дата | |
Msg-id | 059901c13266$bfe6c6f0$279c10ac@INTERNAL обсуждение исходный текст |
Ответ на | Re: Regarding Vacuumdb (Shaun Thomas <sthomas@townnews.com>) |
Список | pgsql-general |
Before doing anything so drastic, you may want to check the archives for recent messages on a similar error. IIRC, this problem can be caused by rolling back a "drop table" command. The effect is that the table structure in the database remains, but the physical file is gone. The fix is to create a file with the correct name in the data directory for that database, then drop the table. If you are running version 7.1, the trick will be to figure out the correct name for that file. You can find discussion on that in the archives too. ----- Original Message ----- From: "Shaun Thomas" <sthomas@townnews.com> To: <shan@ceedees.com> Cc: <pgsql-jdbc@postgresql.org>; <pgsql-general@postgresql.org> Sent: Friday, August 31, 2001 11:48 AM Subject: Re: [GENERAL] Regarding Vacuumdb > On Tue, 28 Aug 2001, Bhuvaneswari wrote: > > > hi, > > I am getting the following error while doing vacuumdb, > > > > ERROR: mdopen: couldn't open test1: No such file or directory > > vacuumdb: database vacuum failed on db1. > > We got this error a lot in 6.5. Usually it means your table has somehow > been corrupted, and postgres doesn't want anything to do with it. It'll > show up, and you can even select from it, but doing so will crash the > back-end, and you can't run a vacuum or pg_dump on that database > successfully. > > You'll have to do a table-by-table pg_dump, destroy the DB, and reimport > everything. You'll have to rebuild the corrupted table from scratch, > since you might not be able to dump it. > > Either way, it's a lot of work. Just be careful. > > -- > +-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+ > | Shaun M. Thomas INN Database Programmer | > | Phone: (309) 743-0812 Fax : (309) 743-0830 | > | Email: sthomas@townnews.com AIM : trifthen | > | Web : hamster.lee.net | > | | > | "Most of our lives are about proving something, either to | > | ourselves or to someone else." | > | -- Anonymous | > +-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+ > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > >
В списке pgsql-general по дате отправления: