PostgreSQL 9.1 installation and configuration
Nuxeo uses two-phase commit and needs to have the max_prepared_transactions settings updated. In \data\postgresql.conf file change:
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):
From the psql command prompt: