Re: [GENERAL] Regarding Vacuumdb

2001-08-31 Thread Mike Mascari
Shaun Thomas wrote: > > 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 i

Re: [GENERAL] Regarding Vacuumdb

2001-08-31 Thread Jeff Eckermann
ot;Shaun Thomas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, August 31, 2001 11:48 AM Subject: Re: [GENERAL] Regarding Vacuumdb > On Tue, 28 Aug 2001, Bhuvaneswari wrote: > > > hi, > > I am g

Re: [GENERAL] Regarding Vacuumdb

2001-08-31 Thread Shaun Thomas
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 corru

Re: [GENERAL] Regarding vacuumdb

2001-08-28 Thread Tom Lane
Bhuvaneswari <[EMAIL PROTECTED]> writes: > ERROR: mdopen: couldn't open test1: No such file or directory Looks like you tried to roll back a DROP TABLE. You can get out of the immediate problem by doing touch $PGDATA/base/db1/test1 and then drop the table. Next, run do not walk to an ar