-----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@xxxxxxxxxxxx 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----- -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
