Skip vacuum warning when datallowconn = false and datvacuumxid = datfrozenxid?

From: "Tony Wasson" <ajwasson(at)gmail(dot)com>
To: "pgsql general" <pgsql-general(at)postgresql(dot)org>
Subject: Skip vacuum warning when datallowconn = false and datvacuumxid = datfrozenxid?
Date: 2006-05-09 19:45:24
Message-ID: 6d8daee30605091245j488d6394k32df9fa668d130a4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Currently the documentation says:

A database that is marked datallowconn = false in pg_database is
assumed to be properly frozen; the automatic warnings and wraparound
protection shutdown do not take such databases into account. Therefore
it's up to you to ensure you've correctly frozen a database before you
mark it with datallowconn = false.

http://www.postgresql.org/docs/8.1/interactive/maintenance.html#VACUUM-FOR-WRAPAROUND

When a VACUUM FREEZE is done, does "datvacuumxid = datfrozenxid"? If
so, should VACUUM skip warning about any databases that are
"datvacuumxid = datfrozenxid and datallowconn = false"?

Browse pgsql-general by date

  From Date Subject
Next Message Karl O. Pinc 2006-05-09 19:55:57 pg_dump design problem (bug??)
Previous Message Joe Kramer 2006-05-09 19:17:21 Re: pgcrypto sha256/384/512 don't work on Redhat. Please help!