Re: locate DB corruption

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Dave Peticolas <dave(at)krondo(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: locate DB corruption
Date: 2018-09-02 00:09:10
Message-ID: a53fd1f1-cc41-32af-cb70-c95e196decc7@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-09-02 00:10:22 Re: error in vacuum
Previous Message Dave Peticolas 2018-09-01 23:57:36 Re: error in vacuum