QA

Jump to bottom Edit New page

jbarrez edited this page Feb 13, 2013 · 1 revision

Enable XA transactions on postgres

By default, xa is not enabled on postgres. To enable XA:

Find postgresql.conf. At the time of writing it was found at '/var/lib/pgsql/9.0/data/postgresql.conf'. Use 'find . -name postgresql.conf' from the root if somewhere else
Set 'max_prepared_transactions' to some value (we chose 10)
/etc/init.d/posgresql-9.0 stop
/etc/init.d/posgresql-9.0 start