Postgres Pro
Downloads
Home   >   mailing lists

Re: Issue in tablebackup - Mailing list pgsql-admin

From Moin Akther
Subject Re: Issue in tablebackup
Date
Msg-id 4FA22E13-3908-4C85-9467-3EAD844BDB22@hotmail.com
Whole thread Raw
In response to Issue in tablebackup  (srini ram <seenuram777@gmail.com>)
List pgsql-admin
Tree view

Hi Srini,

 

Try below steps

 

  1. Take dump of pg_statistic.
  2. Delete from pg_stattistic;
  3. Analyze the <<table_name>>;

 

 

 

Thanks and Best Regards,

Moin Akther

 

 

 

From: srini ram <seenuram777@gmail.com>
Date: Monday, July 27, 2020 at 2:43 PM
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: Issue in tablebackup

 

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

pgsql-admin by date:

Previous
From: srini ram
Date:
Subject: Issue in tablebackup
Next
From: Sidney Aloisio Ferreira Pryor
Date:
Subject: How can i be certain autovacuum is causing reuse if table still grows