[check_postgres] Patch for multi-slony status check

[Jehan-Guillaume (ioguix) de Rorthais]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,

PFA a patch that allows to check the status of a bunch of slony.
Lots of actions are already able to do that in check_postgres, so I added this
functionnality to the slony_status one.

It is based on search_path instead of explicit the schema to look for sl_status
and sl_node in database.

"--schema" becomes "--search_path".

Here is some sample commands:

# will look in db1._db1_prod and db2._db2_prod
$ check_postgres.pl --action=slony_status --dbname=db1,db2 \
  --search_path=_db1_prod,_db2_prod

# will look in db1._slony and db2._slony
$ check_postgres.pl --action=slony_status --dbname=db1,db2 \
  --search_path=_slony

# will request both database to find out the slony schemas
$ check_postgres.pl --action=slony_status --dbname=db1,db2


- -- 
Jehan-Guillaume de Rorthais
DBA
http://www.dalibo.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkxgGQkACgkQXu9L1HbaT6IjfQCfX7SS0EBTVfrOqkuKuEhASnDW
QqUAoN5kW/Jnf+m+lf2WwDAfOUw+jSG3
=+eSa
-----END PGP SIGNATURE-----
-------------- next part --------------
A non-text attachment was scrubbed...
Name: check_multi-slony.patch.gz
Type: application/x-gzip
Size: 2017 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20100809/53e9d3a4/attachment.gz