| From: | Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> |
|---|---|
| To: | apraveen(at)pivotal(dot)io |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Catalog corruption |
| Date: | 2018-08-29 07:28:15 |
| Message-ID: | CA+t6e1kN-U3+n-nmBF2roJHP+PQ96pPr3nNJgYBRPxZStBK2ag@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Yes indeed.
I took a cold backup - shutdown the database and copy all the data dir.
בתאריך יום ג׳, 28 באוג׳ 2018 ב-22:34 מאת Asim R P <apraveen(at)pivotal(dot)io
>:
> On Tue, Aug 28, 2018 at 7:36 AM, Mariel Cherkassky
> <mariel(dot)cherkassky(at)gmail(dot)com> wrote:
> > Afterwards I vacuumed all the databases but nothing helped. I tried to
> > reindex the databases but I got the next error :
> >
> > 2018-08-28 21:50:03 +08 db2 24360 ERROR: could not access status of
> > transaction 32212695
> > 2018-08-28 21:50:03 +08 db2 24360 DETAIL: Could not open file
> > "pg_subtrans/01EB": No such file or directory.
> >
>
> Are you sure you created a checkpoint before copying the data
> directory over to your PC?
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashutosh Bapat | 2018-08-29 07:32:11 | Re: [HACKERS] advanced partition matching algorithm for partition-wise join |
| Previous Message | Alexander Kukushkin | 2018-08-29 07:09:08 | Re: Postmaster doesn't send SIGTERM to bgworker during fast shutdown when pmState == PM_STARTUP |