I'm trying to configure PostgreSQL as my default database.
According to the Nuxeo Book, I have installed the PostgreSQL JDBC driver
into $JBOSS_HOME/server/default/lib|.|
||
|Then, I edit
||$JBOSS_HOME/server/default/deploy/nuxeo.ear/config/default-repository-config.xml
and added|
||
||
<!-- Workspaces configuration. Nuxeo only uses the default workspace. -->
(...)
<PersistenceManager
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
<param name="driver" value="org.postgresql.Driver"/>
<param name="url" value="jdbc:postgresql://localhost:5432/nuxeo"/>
<param name="user" value="postgres"/>
<param name="password" value="password"/>
<param name="schema" value="postgresql"/>
<param name="schemaObjectPrefix" value="jcr_${wsp.name}_"/>
<param name="externalBLOBs" value="false"/>
</PersistenceManager>
(...)
<!-- Versioning configuration. -->
(...)
<PersistenceManager
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
<param name="driver" value="org.postgresql.Driver"/>
<param name="url" value="jdbc:postgresql://localhost:5432/nuxeo"/>
<param name="user" value="postgres"/>
<param name="password" value="password"/>
<param name="schema" value="postgresql"/>
<param name="schemaObjectPrefix" value="jcr_ver_"/>
<param name="externalBLOBs" value="false"/>
</PersistenceManager>
With my username and password.
Later, I edit the following files in datasources folder:
nxarchive-records-ds.xml, nxaudit-logs-ds.xml, nxcomment-jena-ds.xml,
nxplaceful-ds.xml, nxrelations-default-jena-ds.xml,
nxsearch-compass-ds.xml, nxsqldirectory-ds.xml, nxuidsequencer-ds.xml,
nxworkflow-document-ds.xml and nxworkflow-jbpm-ds.xml
And I configure them following the next pattern:
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>nxarchive-records</jndi-name>
<connection-url>jdbc:postgresql://localhost:5432/nxarchive-records</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>username</user-name>
<password>pass</password>
</local-tx-datasource>
</datasources>
With my username and password and using the corresponding jndi-name and
database.
I also edit the sql.properties:
# Jena database type and transaction mode
org.nuxeo.ecm.sql.jena.databaseType=PostgreSQL
org.nuxeo.ecm.sql.jena.databaseTransactionEnabled=false
And the |compass.cfg.xml file:|
||
| <connection>|
| <jdbc managed="true"|
|
dialectClass="org.apache.lucene.store.jdbc.dialect.PostgreSQLDialect"|
| deleteMarkDeletedDelta="3600000">|
| <dataSourceProvider>|
| <jndi lookup="java:/nxsearch-compass" />|
| </dataSourceProvider>|
| </jdbc>|
| </connection>|
||
|Finally, I create the following databases:|
||
|-nuxeo|
|-comment-relations|
|-nxarchive-records|
|-nxaudit-logs|
|-nxplacefulservice|
|-nxrelations-default-jena|
|-nxsearch-compass|
|-nxsqldirectory|
|-nxuidsequencer|
|-nxworkflowdocument|
|-nxworkflowjbpm|
||
||
|The logs, usernames, groups and other details are stored in my
database, but the document files are in the HSQL database. Why are not
the documents in PostgreSQL database?|
||
|Thanks in advance.|
||||
||
||
||
--
Enrique Pérez Olivares.
Dpto I+D.
Yerbabuena Software.
[EMAIL PROTECTED]
http://www.yerbabuena.es
Tlf/Fax: 902 995 246
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
