[check_postgres] [commit] Put in a good ORDER BY for txn_wraparound
check_postgres at bucardo.org
check_postgres at bucardo.org
Fri Jul 18 22:06:41 UTC 2008
Committed by Greg Sabino Mullane <greg at endpoint.com>
Put in a good ORDER BY for txn_wraparound
---
check_postgres.pl | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/check_postgres.pl b/check_postgres.pl
index d25c8cc..60efe20 100755
--- a/check_postgres.pl
+++ b/check_postgres.pl
@@ -2958,7 +2958,7 @@ sub check_txn_wraparound {
default_critical => 1_400_000_000,
});
- $SQL = q{SELECT datname, age(datfrozenxid) FROM pg_database WHERE datallowconn is true};
+ $SQL = q{SELECT datname, age(datfrozenxid) FROM pg_database WHERE datallowconn is true ORDER BY 2 desc, 1};
my $info = run_command($SQL, { regex => qr[\w+\s+\|\s+\d+] } );
my ($max,$maxmsg) = (0,'?');
--
1.5.5.4
More information about the Check_postgres
mailing list