Change join to pg_user to a left join, as the database may be owned by a role.

Thanks to Emmanuel Lesouef for the bug report and help in tracking this down.
There are probably other incorrect inner joins to pg_user in the code.

1 files changed, 1 insertions, 1 deletions

diff --git a/check_postgres.pl b/check_postgres.pl
index 622c5d437..3b5852365 100755
--- a/check_postgres.pl
+++ b/check_postgres.pl
@@ -3978,7 +3978,7 @@ SELECT pg_database_size(d.oid) AS dsize,
   datname,
   usename
 FROM pg_database d
-JOIN pg_user u ON (u.usesysid=d.datdba)$USERWHERECLAUSE
+LEFT JOIN pg_user u ON (u.usesysid=d.datdba)$USERWHERECLAUSE
 };
     if ($opt{perflimit}) {
         $SQL .= " ORDER BY 1 DESC LIMIT $opt{perflimit}";