Re: locate DB corruption - Mailing list pgsql-general

From Adrian Klaver
Subject Re: locate DB corruption
Date
Msg-id a53fd1f1-cc41-32af-cb70-c95e196decc7@aklaver.com
Whole thread Raw
In response to Re: locate DB corruption  (Dave Peticolas <dave@krondo.com>)
Responses Re: locate DB corruption  (Dave Peticolas <dave@krondo.com>)
List pgsql-general
On 09/01/2018 04:45 PM, Dave Peticolas wrote:

> Well restoring from a backup of the primary does seem to have fixed the 
> issue with the corrupt table.

Pretty sure it was not that the table was corrupt but that transaction 
information was missing from pg_clog.

In a previous post you mentioned you ran tar to do the snapshot of 
$PG_DATA.

Was there any error when tar ran the backup that caused you problems?


-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Dave Peticolas
Date:
Subject: Re: error in vacuum
Next
From: Adrian Klaver
Date:
Subject: Re: error in vacuum