Re: pg_multixact not getting truncated - Mailing list pgsql-hackers

From Robert Haas
Subject Re: pg_multixact not getting truncated
Date
Msg-id CA+TgmoaoRaE0a9RkPNQDi-fN9dKEBCt=Pt37h5i0Y8m8RedbXA@mail.gmail.com
Whole thread Raw
In response to Re: pg_multixact not getting truncated  (Josh Berkus <josh@agliodbs.com>)
Responses Re: pg_multixact not getting truncated  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
On Thu, Nov 20, 2014 at 3:44 PM, Josh Berkus <josh@agliodbs.com> wrote:
>> So that we can have two ways to lose data?
>>
>> Forbidding connections to a database doesn't prevent XID or MXID wraparound.
>
> It does prevent the user from doing anything about it, though, since
> they can't manually vacuum template0 without knowing unpublished hackery.

True.  I don't know what to do about that.  Do you?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Doing better at HINTing an appropriate column within errorMissingColumn()
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_multixact not getting truncated