From: | "michael(at)sqlexec(dot)com" <michael(at)sqlexec(dot)com> |
---|---|
To: | ramonpadilla1(at)yahoo(dot)co(dot)uk |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_dump ERROR: missing chunk number 0 for toast value |
Date: | 2017-03-23 12:25:35 |
Message-ID: | 58D3BEBF.9020701@sqlexec.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)yahoo(dot)co(dot)uk wrote:
> missing chunk
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-03-23 13:47:58 | Re: - Need Clarification about filenodes under base database directory |
Previous Message | Samed YILDIRIM | 2017-03-23 11:40:01 | Re: Replication Between heterogeneous Databases |