Re: pg_dump backup issue
| От | Erik Serrano |
|---|---|
| Тема | Re: pg_dump backup issue |
| Дата | |
| Msg-id | CA+dvXXuudYs3_QYC1MeSwk7mA6X=Q5fnOfF_+-M2w7NhwMGneg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: pg_dump backup issue (M Jane <mskiesewetter@gmail.com>) |
| Список | pgsql-admin |
Hi Srini,
What pg_dump is telling you is that the table does not exist, if you are still viewing it it is surely still in memory. Before doing the pg_dump do a vacum parse the table and tell me.
Bye.
Erik Serrano Saavedra
El jue., 2 de jul. de 2020 10:04 a. m., M Jane <mskiesewetter@gmail.com> escribió:
Hi Srini,What version are you running postgres on? What is the command you are running that gives the error?Have there been any changes prior to the error occurring?Regards,MarianOp do 2 jul. 2020 om 15:12 schreef srini ram <seenuram777@gmail.com>:Can anyone support me on the blow trial email issue.
Regards,Srinivasan ROn 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_dumppg_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.Ph.,:9035911976Thanks&Regards,Srinivasan R
В списке pgsql-admin по дате отправления: