From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Bhanu Gandikota <bgandikota@ebates.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Postgresql 9.3.9
Date: Thu, 25 Jun 2015 19:20:21 -0300
Message-ID: <20150625222021.GN3289@postgresql.org> (raw)
In-Reply-To: <BY1PR02MB119409054C84AE4636CB2674A7AE0@BY1PR02MB1194.namprd02.prod.outlook.com>
References: <BY1PR02MB119409054C84AE4636CB2674A7AE0@BY1PR02MB1194.namprd02.prod.outlook.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Bhanu Gandikota wrote:
> Hi all,
>
> Does anyone know if we need to run any vacuum (freeze) soon after patching Postgresql to version 9.3.9 [say from 9.3.4]?
> Is TXN wrap around fix effective automatically in 9.3.9 or do we have to do anything manually?
Look in your log for a message like this shortly after server start:
LOG: MultiXact member wraparound protections are now enabled
If you see it, then you're fine and nothing is needed.
If you see this message instead:
LOG: MultiXact member wraparound protections are disabled [...]
then autovacuum will have to slowly work its way out of trouble. It
might take some time, depending on the database size. You don't need
any additional measures as it's automatic. As soon as it has finished,
you will see the other message above.
--
Á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, bgandikota@ebates.com
Subject: Re: Postgresql 9.3.9
In-Reply-To: <20150625222021.GN3289@postgresql.org>
* 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