Re: postgres 8.2.9 can`t drop database in single user mode

-----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-----