On Sat, Sep 1, 2018 at 5:28 PM Dave Peticolas <dave@xxxxxxxxxx> wrote:
On Sat, Sep 1, 2018, 5:10 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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?
One thing I tried on a database restored from a primary backup that exhibits the same "found update xid" error is this:
1. pg_dump the table and its referencing tables.
2. truncate the table and its referencing tables.
3. Load the dump file.
Does that seem reasonable?
