Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump backup issue - Mailing list pgsql-admin

From srini ram
Subject Re: pg_dump backup issue
Date
Msg-id CAKAsTSq=U7fZn2o-4hoAE7CfyO7Sth=V1hEgW21hbQejNOhjeQ@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump backup issue  (M Jane <mskiesewetter@gmail.com>)
List pgsql-admin
Tree view
Can anyone support me on the blow trial email issue.

Regards,
Srinivasan R

On Mon, 29 Jun 2020, 10:48 pm srini ram, <seenuram777@gmail.com> wrote:
I am facing a problem while performing a pg_dump backup.

I too verified in multiple articles to fix this issue without performing any manual table back and restore, but I couldn't found any easy troubleshooting steps.

Below mentioned are the error message while performing the pg_dump

pg_dump: [archiver (db)] query failed: ERROR:  relation "public.tblraw202012022_p9" does not exist

pg_dump: [archiver (db)] query was: LOCK TABLE public.tblraw202012022_p9 IN ACCESS SHARE MODE


Looks like table is corrupted but still, I couldn't able dop the issue table. If I try to drop the table I am getting a different error response. 


Please help me with the possible solution to fix the above issue.

Thanks&Regards,
Srinivasan R
Ph.,:9035911976

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: move postgrest installation
Next
From: Praveen Kumar K S
Date:
Subject: [HELP] Issue with standby server using WAL archive