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
I try do vacuum a database:
[PostgreSQL 6.5.0 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: ecoscan
ecoscan=> vacuum;
ERROR: Inde
Akash Garg <[EMAIL PROTECTED]> writes:
> 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 directo
Akash Garg <[EMAIL PROTECTED]> writes:
> Sounds good -- I will try that. Will this REINDEX lock any queries
> that are currently running on the database? And is there anway to
> find out what table this toast table is related to?
IIRC, 100194 is the OID of the owning table.
Mon, 18 Jul 2005 10:35:40 -0700
Subject: Re: [GENERAL] Error while vacuuming
> Sounds good -- I will try that. Will this REINDEX lock any queries
> that are currently running on the database? And is there anway to
> find out what table this toast table is related to?
>
> Thanks,
>
Sounds good -- I will try that. Will this REINDEX lock any queries
that are currently running on the database? And is there anway to
find out what table this toast table is related to?
Thanks,
Akash
On 7/18/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> Akash Garg <[EMAIL PROTECTED]> writes:
> > I g
Hello,
When I run vacuum, I get:
vacuumdb: vacuuming of database "pm50" failed: ERROR: catalog is
missing 1 attribute(s) for relid 4210163
How do I go about debugging this? I have googled around and tried a few
things to no avail.
Any pointers will be appreciated.
Thanks.
Nikhil
--
Sent