[check_postgres] Getting per-database size values
Emmanuel Lesouef
e.lesouef at crbn.fr
Tue Nov 22 14:34:30 UTC 2011
Le Tue, 22 Nov 2011 09:28:12 -0500,
Greg Sabino Mullane <greg at endpoint.com> a écrit :
> > 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?
>
>
Hi,
Here is the results :
postgres at pgsql0:~$ /usr/local/bin/check_postgres.pl --output=simple,MB
--action=database_size --db=postgis --include=postgis
0
postgres at pgsql0:~$ /usr/local/bin/check_postgres.pl --output=simple
--action=database_size --db=postgis --include=postgis
0
Seems strange to me...
Thanks for answering :)
--
Emmanuel Lesouef
CRBN/DSI/SITI
t: 0231069671
e: e.lesouef at crbn.fr
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20111122/482f8e81/attachment.bin
More information about the Check_postgres
mailing list