Skip site navigation (1) Skip section navigation (2)

Index problem...

From: Carol Walter <walterc(at)indiana(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Index problem...
Date: 2008-05-22 16:41:54
Message-ID: 473E95AE-4622-4B45-88A8-7CC4FB9076A3@indiana.edu (view raw or flat)
Thread:
Lists: pgsql-admin
Greetings...

I'm getting an error.  The error says...

places=# REINDEX INDEX maps_map_id_seq;
ERROR:  "maps_map_id_seq" is not an index
places=# SELECT * FROM maps;
ERROR:  missing chunk number 0 for toast value 131343627

I have tried reindexing the index, the table, and the database.  I  
continue to get this error.  What can I do to recover from this.

Carol Walter

PS  Let me say that I know this is my fault.  This index is very  
bloated.  Yesterday, I tried to vacuum.   I got errors because  
max_fsm_pages what set at a number that was too small.


Responses

pgsql-admin by date

Next:From: Tomeh, HusamDate: 2008-05-22 17:02:10
Subject: Re: Index problem...
Previous:From: Amit jainDate: 2008-05-22 13:47:45
Subject: Error while executing pg_dump "invalid memory alloc request size 4294967293"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group