[check_postgres] Getting per-database size values

[Emmanuel Lesouef]

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