Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting error during execution of pg_dump - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Getting error during execution of pg_dump
Date
Msg-id ea88c84b220e7c536e8c40126d198f6dd93e211b.camel@cybertec.at
Whole thread Raw
In response to Getting error during execution of pg_dump  (OS DB2 <opensourcedb2@gmail.com>)
List pgsql-admin
Tree view 
On Tue, 2023-05-16 at 14:27 +0530, OS DB2 wrote:
> In one of the production server we are getting below error when we are trying to take pg_dump of one of the table.
>
> Error: missing chunk number 0 for toast value 1115988058 in pg_toast_1104679371
>
> Request you to share your valuable suggestion to resolve the same.

You have data corruption.  Restore your last good backup.

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: ERROR: could not serialize access due to concurrent update
Next
From: ROHIT SACHDEVA
Date:
Subject: Re: ERROR: could not serialize access due to concurrent update