-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
"Maria L. Wilson" asked:
> Question - is there any maintenance type item that we could
> check for uncommitted transactions on a regular basis - outside
> of the pg_prepared_xacts table?
The latest version of check_postgres (a Postgres monitoring script)
has a check for this exact problem:
http://bucardo.org/check_postgres/
Details on this particular check:
http://bucardo.org/check_postgres/check_postgres.pl.html#prepared_txns
- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200905051117
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iEYEAREDAAYFAkoAWV4ACgkQvJuQZxSWSsjh+wCfcMjLHf0lj9ZfrvzN61XVx2Ui
ECsAn0yjrH6/euQHGboVmzId/xocpHo7
=sCuO
-----END PGP SIGNATURE-----