[Nagiosplug-devel] [ nagiosplug-Patches-1445062 ] check_pgsql patch for XID wraparound check

[SourceForge.net]

Patches item #1445062, was opened at 2006-03-07 19:38
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=397599&aid=1445062&group_id=29880

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Enhancement
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Cott Lang (atomicpunk)
Assigned to: Nobody/Anonymous (nobody)
Summary: check_pgsql patch for XID wraparound check

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

Preventing transaction ID wraparound is critical to
PostgreSQL servers - if it wraps around, you start
losing data immediately. This patch checks a
warning/critical threshold on all databases whenever
check_pgsql does a connection test to a database.

Postgres recommends vacuuming at the 500M xid mark and
the database itself will begin logging errors at 1500M,
so the warning and critical threshold defaults in the
patch are 500M and 1000M respectively.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=397599&aid=1445062&group_id=29880