[check_postgres] Getting per-database size values

Greg Sabino Mullane greg at endpoint.com
Tue Nov 22 14:28:12 UTC 2011


> postgres at pgsql0:~$ /usr/local/bin/check_postgres.pl --output=simple,MB
> --action=database_size --db=postgis --include=postgis
> 0
...
> postgres=# SELECT pg_size_pretty(pg_database_size('postgis'));
>  pg_size_pretty 
> ----------------
>  37 MB

Looks like a bug. What does it say when you take out the MB part, 
e.g. --output=simple?


-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20111122/c2dcf701/attachment.bin 


More information about the Check_postgres mailing list