From ce3e0d13a293b9435ff01bde2b6c140c3129b8c7 Mon Sep 17 00:00:00 2001
From: Greg Sabino Mullane <greg@endpoint.com>
Date: Wed, 22 Jun 2011 12:02:58 -0400
Subject: [PATCH] Quick fix for cases when client_port is set to an empty
 string, per bug report 79 from Fabrice Metge

---
 check_postgres.pl | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/check_postgres.pl b/check_postgres.pl
index 438f0f4b7..e9c499939 100755
--- a/check_postgres.pl
+++ b/check_postgres.pl
@@ -7405,7 +7405,8 @@ sub check_txn_idle {
             msg('database'), $maxr->{datname},
             msg('username'), $maxr->{usename},
             $maxr->{client_addr} eq '' ? '' : (sprintf ' %s:%s', msg('address'), $maxr->{client_addr}),
-            $maxr->{client_port} < 1 ? '' : (sprintf ' %s:%s', msg('port'), $maxr->{client_port});
+            ($maxr->{client_port} eq '' or $maxr->{client_port} < 1)
+                ? '' : (sprintf ' %s:%s', msg('port'), $maxr->{client_port});
     }
 
     ## For MRTG, we can simply exit right now
-- 
2.30.2