Thank you, that did it!
On 08/07/2013 03:30 PM, Tom Lane wrote:
Sebastian Kornehl <webmas...@sourcebase.org> writes:
You might be right, I found some pg_prepared_xacts from 2013-05-23. This
was a test with a XA using application, but the application is already
offline. There is also no pid available for the given transaction id's.
Do you have any idea how to close these xa transactions without
restarting the whole db?
Just use ROLLBACK PREPARED with the ID you see in pg_prepared_xacts.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
