| From: | Naveen Kumar <naveenchowdaryon(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | ERROR: unexpected chunk number 452 (expected 0) for toast value 94674063 in pg_toast_56980977 |
| Date: | 2018-07-18 15:45:52 |
| Message-ID: | CADk76joUrW0c3nBWbuHUbmEZbTUBOuwLAE65gRDat0yBQ2=xHA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello Experts,
What could be the reason for bellow errors. Can one help me to fix this?
PostgreSQL Database: [~rptdb~] Data Backup Failed with PostgreSQL Error:
[~pg_dump: Dumping the contents of table "document" failed: PQgetResult()
failed.pg_dump: Error message from server: ERROR: unexpected chunk number
452 (expected 0) for toast value 94674063 in pg_toast_56980977pg_dump: The
command was: COPY reports_extended.document (document_id, access_key,
created_date, document_name, document_size, document_status, document_type,
encryption_type, external_system_storage_id, external_system_storage_url,
last_updated_date, md5_hash, source_system_name, storage_type, created_by,
customer_org_id, content_type, tags, file, ownedby) TO stdout;~].
Thanks & Regards,
Naveen Kumar .M,
Sr. PostgreSQL Database Administrator,
Mobile: 7755929449.
My attitude will always be based on how you treat me.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shreeyansh Dba | 2018-07-18 16:01:49 | Re: ERROR: unexpected chunk number 452 (expected 0) for toast value 94674063 in pg_toast_56980977 |
| Previous Message | Rui DeSousa | 2018-07-18 15:30:51 | Re: [Admin] Reclaim Space from 4 TB Database |