[check_postgres] Patch for multi-slony status check
Jehan-Guillaume (ioguix) de Rorthais
jgdr at dalibo.com
Mon Aug 9 15:04:42 UTC 2010
-----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
More information about the Check_postgres
mailing list