Re: Getting error during execution of pg_dump

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: OS DB2 <opensourcedb2(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Getting error during execution of pg_dump
Date: 2023-05-16 15:34:19
Message-ID: ea88c84b220e7c536e8c40126d198f6dd93e211b.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message ROHIT SACHDEVA 2023-05-16 16:21:53 Re: ERROR: could not serialize access due to concurrent update
Previous Message Laurenz Albe 2023-05-16 15:33:26 Re: ERROR: could not serialize access due to concurrent update