Kevin Kempter <cs_dba@xxxxxxxxxxxxxxxxxxx> wrote: > # select * from comments; > ERROR: missing chunk number 0 for toast value 1274882 in > pg_toast_49234 > > > I tried this: > > # reindex table pg_toast.pg_toast_49234; > REINDEX > > > but the error still persists. > > Thoughts? Your database is corrupted. Any idea how that happened? As with any database corruption, I recommend you stop the server and make a copy of the whole data directory and everything under it before any recovery attempts. You could zero in on the damage by selecting specific columns, and ranges of rows. A little more detail would be helpful. For ideas, read this: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin