Error while vacuuming - Mailing list pgsql-general

From Akash Garg
Subject Error while vacuuming
Date
Msg-id 89058be205071809221a07ac7f@mail.gmail.com
Whole thread Raw
Responses Re: Error while vacuuming
List pgsql-general
I get this error when I run a VACUUM:

INFO:  vacuuming "pg_toast.pg_toast_100194"
vacuumdb: vacuuming of database "friend" failed: ERROR:  could not
open segment 1 of relation "pg_toast_100194_index" (target block
1226167840): No such file or directory

I'm assuming I can just delete and recreate the index in question,
although I'm not sure which index or table it's talking about.  Any
ideas?

Akash

pgsql-general by date:

Previous
From: Akash Garg
Date:
Subject: Re: Seg fault in postgres 7.4.7?
Next
From: Bob Pawley
Date:
Subject: ODBC