Re: error in vacuum - Mailing list pgsql-general

From Dave Peticolas
Subject Re: error in vacuum
Date
Msg-id CAPRbp05cyASFuieDrcQvYCTJM_TWBS2SBzPqDRf5t2S+akJV8A@mail.gmail.com
Whole thread Raw
In response to Re: error in vacuum  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: error in vacuum  (Dave Peticolas <dave@krondo.com>)
List pgsql-general
On Sat, Sep 1, 2018, 5:10 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 09/01/2018 04:47 PM, Dave Peticolas wrote:
> I'm seeing this error on a table repeatedly:
>
> found update xid 3433096759 <tel:%28343%29%20309-6759> from before
> relfrozenxid 3498422955

Where is this, your primary or the instance you are running from the backup?

This is a primary, 9.6.8 to be exact.

>
> What can I do to repair this table?
>
> thanks,
> dave
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

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