From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Pavlov, Vladimir <Vladimir.Pavlov@tns-global.ru>
Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Re: MultiXact member wraparound protections
Date: Wed, 30 Mar 2016 18:46:50 -0300
Message-ID: <20160330214650.GA48839@alvherre.pgsql> (raw)
In-Reply-To: <B38B34EC5621E34DABCE13E8B18936E602DC2C14BE68@EXSERV.Gallup.tns>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Pavlov, Vladimir wrote:
> 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?
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@2ndquadrant.com, Vladimir.Pavlov@tns-global.ru
Subject: Re: MultiXact member wraparound protections
In-Reply-To: <20160330214650.GA48839@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox