Error while vacuuming

From: Akash Garg <akash(dot)garg(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Error while vacuuming
Date: 2005-07-18 16:22:34
Message-ID: 89058be205071809221a07ac7f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2005-07-18 16:41:31 ODBC
Previous Message Akash Garg 2005-07-18 16:21:31 Re: Seg fault in postgres 7.4.7?