Re: pg_dump backup issue

From: srini ram <seenuram777(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: pg_dump backup issue
Date: 2020-07-02 13:12:15
Message-ID: CAKAsTSq=U7fZn2o-4hoAE7CfyO7Sth=V1hEgW21hbQejNOhjeQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Can anyone support me on the blow trial email issue.

Regards,
Srinivasan R

On Mon, 29 Jun 2020, 10:48 pm srini ram, <seenuram777(at)gmail(dot)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*
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Praveen Kumar K S 2020-07-02 13:27:13 [HELP] Issue with standby server using WAL archive
Previous Message Ron 2020-07-02 13:05:43 Re: move postgrest installation