Thread: MultiXact member wraparound protections

MultiXact member wraparound protections

From
"Pavlov, Vladimir"
Date:

Hello,

The server logs contain errors:

MultiXact member wraparound protections are disabled because oldest checkpointed MultiXact 1085772411 does not exist on disk

How to enable MultiXact member wraparound protection?

 

Kind regards,

 

Vladimir Pavlov

 

Re: MultiXact member wraparound protections

From
"Pavlov, Vladimir"
Date:

Sorry, PostgreSQL version 9.3.10.

 

Kind regards,

 

Vladimir Pavlov

 

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Pavlov, Vladimir
Sent: Tuesday, March 29, 2016 4:25 PM
To: 'pgsql-admin@postgresql.org'
Subject: [ADMIN] MultiXact member wraparound protections

 

Hello,

The server logs contain errors:

MultiXact member wraparound protections are disabled because oldest checkpointed MultiXact 1085772411 does not exist on disk

How to enable MultiXact member wraparound protection?

 

Kind regards,

 

Vladimir Pavlov

 

Re: MultiXact member wraparound protections

From
Alvaro Herrera
Date:
Pavlov, Vladimir wrote:
> Hello,
> The server logs contain errors:
> MultiXact member wraparound protections are disabled because oldest checkpointed MultiXact 1085772411 does not exist
ondisk 
> How to enable MultiXact member wraparound protection?

As I understand it, autovacuum should be processing all the tables in
order to establish a safe multixact.  Have a look at the autovacuum
activity in the server.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services