Re: Catalog corruption - Mailing list pgsql-hackers

From Asim R P
Subject Re: Catalog corruption
Date
Msg-id CANXE4TeYbXdNfGSmRsKbeWm+=LD8kVrNYe=UDE8FvZtuMh3W3w@mail.gmail.com
Whole thread Raw
In response to Catalog corruption  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Responses Re: Catalog corruption
List pgsql-hackers
On Tue, Aug 28, 2018 at 7:36 AM, Mariel Cherkassky
<mariel.cherkassky@gmail.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?


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: More parallel pg_dump bogosities
Next
From: Tom Lane
Date:
Subject: pg_dump --load-via-partition-root vs. parallel restore