Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not beencreated yet -- apparent wraparound - Mailing list pgsql-bugs

From Phil Hildebrand
Subject Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not beencreated yet -- apparent wraparound
Date
Msg-id CAKk9fdW51WTRdczSp1c7ddhK2+hLLe1q_a8jg8ict2jq5iMdvw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not beencreated yet -- apparent wraparound  (Stephen Frost <sfrost@snowman.net>)
List pgsql-bugs
Thanks for the tip - we'll look into enabling the page checksums as well.

On Thu, Jan 3, 2019 at 1:08 PM Stephen Frost <sfrost@snowman.net> wrote:
>
> Greetings,
>
> * Phil Hildebrand (phil.hildebrand@moz.com) wrote:
> > Data page checksum version:           0
>
> You really might want to consider fixing that and using some tool to
> regularly check the checksums of all the pages in the cluster, to
> hopefully catch something like this happening again sooner than you
> might otherwise, and while you still have backups you can go to and
> restore the data from.
>
> Thanks!
>
> Stephen



-- 
Phil Hildebrand
Sr. DBE @ Moz
206.696.3413


pgsql-bugs by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: BUG #15446: Crash on ALTER TABLE
Next
From: Andres Freund
Date:
Subject: Re: BUG #15446: Crash on ALTER TABLE