PostgreSQL 9.1 installation and configuration
Two-phase commit
Nuxeo uses two-phase commit and needs to have the max_prepared_transactions settings updated. In \data\postgresql.conf file change:
Restart server.
Implicit casts
Jena (used for relations and comments) and jBPM (used for workflows) assume some implicit value casting in the SQL they generate.
To make Nuxeo work with PostgreSQL >= 8.3, you must therefore execute the following commands in your PostgreSQL console when connected to the template1 database, so that any database created afterward will come with the required CASTs (if your database is already created, execute the commands in your database as well):
Create the role and database for Nuxeo
From the psql command prompt:
Labels:
None