| From: | "Greg Sabino Mullane" <greg(at)turnstep(dot)com> |
|---|---|
| To: | Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: postgres 8.2.9 can`t drop database in single user mode |
| Date: | 2009-05-05 15:21:22 |
| Message-ID: | f8db1ab54053f484e9e4f537fe757f63@biglumber.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
-----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(at)turnstep(dot)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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carol Walter | 2009-05-05 15:23:42 | Can't drop constraint? |
| Previous Message | Tom Lane | 2009-05-05 15:11:35 | Re: can't cancel a query with pg_cancel_backend |