pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Postgresql 9.3.9
2+ messages / 2 participants
[nested] [flat]

* Postgresql 9.3.9
@ 2015-06-25 06:19  Bhanu Gandikota <bgandikota@ebates.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Bhanu Gandikota @ 2015-06-25 06:19 UTC (permalink / raw)
  To: pgsql-admin

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?

Please advise!

Thanks,
Bhanu Gandikota

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Postgresql 9.3.9
@ 2015-06-25 22:20  Alvaro Herrera <alvherre@2ndquadrant.com>
  parent: Bhanu Gandikota <bgandikota@ebates.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Alvaro Herrera @ 2015-06-25 22:20 UTC (permalink / raw)
  To: Bhanu Gandikota <bgandikota@ebates.com>; +Cc: pgsql-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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2015-06-25 22:20 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-06-25 06:19 Postgresql 9.3.9 Bhanu Gandikota <bgandikota@ebates.com>
2015-06-25 22:20 ` Alvaro Herrera <alvherre@2ndquadrant.com>

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