Re: META vacuum - FAIL: ERROR - Mailing list pgsql-novice

I've never used 6.5, but I vaguely recall an error with heap a similar error to the one you report being something in the old/full vacuum for moving chains. I believe it was said to just stop vacuum. It might be worth a scan of the archives (I seem to recall Tom Lane gave the reason).

I would have thought just dropping the index and recreating would be ok, but have never come across this problem myself.

Regards,
- Stuart

> -----Original Message-----
> From: Albert Csaba [mailto:maka_cs@yahoo.com]
> Sent: 06 June 2002 14:43
> To: Henshall, Stuart - WCP
> Subject: Re: [NOVICE] META vacuum - FAIL: ERROR
>
>
>
> Thanks again for your answer, I really appreciate it.
> I'm using version 6.5 (yes, it's old, but because of
> warranty, I cannot upgrade it).I managed finally to
> start postgres (silly me, i gave tha table name in
> place of the database name)
>
> postgres -D /home/pgsql/base -O cobalt
>
> but the command REINDEX isn't supported in this
> version yet... so any other ideas, what could I do?
> can delete the old index and create a new one?
>
>
> Thank you,
> kind regards,
> Csaba Albert
>
>
>
>
> --- "Henshall, Stuart - WCP"
> <SHenshall@westcountrypublications.co.uk> wrote:
> >
> >
> > > -----Original Message-----
> > > From: Albert Csaba [mailto:maka_cs@yahoo.com]
> > > Sent: 06 June 2002 11:55
> > > To: Henshall, Stuart - WCP
> > > Subject: RE: [NOVICE] META vacuum - FAIL: ERROR
> > >
> > >
> > >
> > > Thank you, it helped me to start. It's my first
> > time
> > > using PostgreSQL, I've used till now only MySQL,
> > but
> > > it seems that I am forced a little bit now to use
> > it.
> > > I have on the Cobalt server PostgreSQL 6.5, and
> > trying
> > > to do what says there, I'm getting the following:
> > >
> > > postgres -D /home/pgsql/ -O
> > > pg_attribute_attrelid_index
> > > FATAL 1:  Database pg_attribute_attrelid_index
> > does
> > > not exist in pg_database
> > > FATAL 1:  Database pg_attribute_attrelid_index
> > does
> > > not exist in pg_database
> > >
> > > postgres -D /home/pgsql/base/cobalt -O
> > > pg_attribute_attrelid_index
> > > FATAL 1:  Cannot open
> > > /home/pgsql/base/cobalt/pg_database
> > > FATAL 1:  Cannot open
> > > /home/pgsql/base/cobalt/pg_database
> > >
> > > The option -P is not supported. The structure is:
> > >
> > >
> >
> /home/pgsql--base--cobalt--pg_attribute_attrelid_index
> > >
> > > Am I doing something wrong? What next?
> > >
> > > Thank you,
> > > Csaba Albert
> > >
> >
> > Hi,
> > What database version are you using? 7.2.1 is the
> > latest.
> > Is your data directory really /home/pgsql?
> > This should be the same path you used initdb on.
> > If you have PG_DATA set then you don't need the -D
> > option.
> > I just used (for instance):
> > postgres -O -P template1
> > you can give your database name instead of template1
> > hth,
> > - Stuart
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
>