Issue in tablebackup

From: srini ram <seenuram777(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Issue in tablebackup
Date: 2020-07-27 09:13:03
Message-ID: CAKAsTSqZV8weqLAENeL_TpJoYVzVs20Xaj-VxtM2RTUSvopGJQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Experts,

I am facing below error while taking a table back.

producation_db=# select * into tblconfmresult27072020 from tblconfmresult;
ERROR: missing chunk number 0 for toast value 4543659 in pg_toast_24175
producation_db =#

kindly assist me in taking the backup of this error table from my
production database.

I tried table vacuum and re-index of this issue table but still, it was not
helping to resolve this issue.

*Thanks&Regards,*

*Srinivasan R*
*Ph.,:9035911976*

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Moin Akther 2020-07-27 15:28:44 Re: Issue in tablebackup
Previous Message Wells Oliver 2020-07-24 18:41:57 Re: Checking for valid UUID values?