 | Warning The following describes changes in the low-level Nuxeo configuration files. Starting with Nuxeo 5.3.2, a template system is used to change Nuxeo configuration, and by default the files described below will be overwritten by those from the templates at each startup. See the documentation on [How to configure Nuxeo EP] for more about templates. |
The Visible Content Store (VCS) is the default storage backend shipped with Nuxeo EP 5.3. It uses H2 as default embedded database but this is not the one recommended for production use: Nuxeo recommends the use of PostgreSQL as storage backend.
The following describes the files you need to configure for Nuxeo to use PostgreSQL with VCS.
First, make sure you have followed the recommendations described at Configuring PostgreSQL for configuration of the database itself.
JDBC Driver
Download the latest JDBC3 or JDBC4 driver from: http://jdbc.postgresql.org/download.html#current. If you use Java 5, use a JDBC3 driver. For Java 6 (which is the default since Nuxeo 5.4), use the JDBC4 driver.
Note that you can use a later driver with an earlier database version, for instance the 9.0 driver still works with PostgreSQL 8.3 or 8.4.
The downloaded JAR (for instance postgresql-9.0-801.jdbc4.jar) must then be placed in $JBOSS/server/default/lib/ or $TOMCAT/lib/.
JBoss configuration
- config/default-repository-config.xml:
- datasources/default-repository-ds.xml:
Adapt this code to use your database name and set appropriate login and password.
Note that this file contains the version number of the SQL connector, here 1.6.0. Don't forget to replace it with the version number of your Nuxeo EP instance (1.6.x is a core version number, see the actual full name of the RAR inside the system directory).
- Don't forget to also update the datasources/nxtags-ds.xml to follow the same DB instance, the Tag Service is required to work in the same table space as the default-repository. Accordingly, this file would look like
- You can also configure datasources/unified-nuxeo-ds.xml to store all other datas in your PostgreSQL database
For a transactional configuration:
For a non transactional configuration:
- If you changed the database used to store Jena data, you also have to change a property in config/sql.properties:
Check http://community.jboss.org/wiki/configdatasources for configuration options.
Tomcat configuration
To use PostgreSQL (8.3/8.4) with the Tomcat distribution of Nuxeo, you need to change some files:
The resources should looks like:
for each resource.
Also change:
The configuration should looks like:
And finally:
- nxserver/config/commentService-config-bundle.xml
- nxserver/config/nxrelations-default-jena-bundle.xml
- nxserver/config/sql.properties
where you should change "databaseType" property from "Derby" to "PostgreSQL" and "databaseTransactionEnabled" property set to "true".