As a start, zero in on the relation, index,column, table:
select 36791::regclass;
Restart the server with:
zero_damaged_pages=true
ignore_system_indexes=true
Do full vacuum again:
VACUUM FULL VERBOSE public.bodycontent;
If still a problem, consider dropping all the indexes and recreate
them. Then try to do the vacuum full again.
If you still have a problem:
Use a program like python/psycopg2 and write a loop that fetches every
row in the table and capture with exception the rows that it fails on.
Then delete those rows. Then do a dump of the table to /dev/null and
see if it completes without errors. If so, you will need to dump and
recreate the table.
Regards,
Michael Vitale
ramonpadilla1@xxxxxxxxxxx wrote:
missing chunk
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
