Overview
This article describes how to use the postgreSQL database software as a persistence store. PostgreSQL is a free, Open-Source database (BSD license). My personal impression is, that a postgreSQL-based repository runs somewhat faster then the Derby installation.
Setting up the properties
You have to change both instances magnoliaAuthor and magnoliaPublic
In both instances you must change the property (from
...
...derby..)
...
in
...
the
...
file
...
WEB-INF/config/default/magnolia.properties
...
(or
...
whatever
...
is
...
your
...
current
...
property
...
file)
...
to
...
this.
| Code Block |
|---|
{code} magnolia.repositories.jackrabbit.config=WEB-INF/config/repo-conf/jackrabbit-bundle-postgres-search.xml {code} h3. Config files This configured config files are not part of the bundles. You have to create them yourself. These are similar to the ones for MySql. The config files are nearly the same for both instances. Each instance works on its own database. However, you may use the same user. Here the config file (_ |
Config files
This configured config files are not part of the bundles. You have to create them yourself. These are similar to the ones for MySql. The config files are nearly the same for both instances. Each instance works on its own database. However, you may use the same user.
Here the config file (WEB-INF/config/repo-conf/jackrabbit-bundle-postgres-search.xml
...
)
...
for
...
instance magnoliaAuthor
| Code Block |
|---|
_magnoliaAuthor_ {code} <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD Jackrabbit 1.5//EN" "http://jackrabbit.apache.org/dtd/repository-1.5.dtd"> <Repository> <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"> <param name="path" value="${rep.home}/repository" /> </FileSystem> <Security appName="Jackrabbit"> <AccessManager class="org.apache.jackrabbit.core.security.SimpleAccessManager"></AccessManager> <LoginModule class="org.apache.jackrabbit.core.security.SimpleLoginModule"> <param name="anonymousId" value="anonymous" /> </LoginModule> </Security> <DataStore class="org.apache.jackrabbit.core.data.FileDataStore"> <param name="path" value="${rep.home}/repository/datastore"/> <param name="minRecordLength" value="1024"/> </DataStore> <Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default" /> <Workspace name="default"> <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"> <param name="path" value="${wsp.home}/default" /> </FileSystem> <PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager"> <param name="driver" value="org.postgresql.Driver"/> <param name="url" value="jdbc:postgresql://localhost:5432/magnolia_author" /> <param name="schema" value="postgresql" /><!-- warning, this is not the schema name, it's the db type --> <param name="user" value="magnolia" /> <param name="password" value="password" /> <param name="schemaObjectPrefix" value="${wsp.name}_" /> <param name="externalBLOBs" value="false" /> </PersistenceManager> <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex"> <param name="path" value="${wsp.home}/index" /> <param name="useCompoundFile" value="true" /> <param name="minMergeDocs" value="100" /> <param name="volatileIdleTime" value="3" /> <param name="maxMergeDocs" value="100000" /> <param name="mergeFactor" value="10" /> <param name="maxFieldLength" value="10000" /> <param name="bufferSize" value="10" /> <param name="cacheSize" value="1000" /> <param name="forceConsistencyCheck" value="false" /> <param name="autoRepair" value="true" /> <param name="analyzer" value="org.apache.lucene.analysis.standard.StandardAnalyzer" /> <param name="queryClass" value="org.apache.jackrabbit.core.query.QueryImpl" /> <param name="respectDocumentOrder" value="true" /> <param name="resultFetchSize" value="2147483647" /> <param name="extractorPoolSize" value="3" /> <param name="extractorTimeout" value="100" /> <param name="extractorBackLogSize" value="100" /> <param name="textFilterClasses" value="org.apache.jackrabbit.extractor.MsWordTextExtractor, org.apache.jackrabbit.extractor.MsExcelTextExtractor, org.apache.jackrabbit.extractor.MsPowerPointTextExtractor, org.apache.jackrabbit.extractor.PdfTextExtractor, org.apache.jackrabbit.extractor.OpenOfficeTextExtractor, org.apache.jackrabbit.extractor.RTFTextExtractor, org.apache.jackrabbit.extractor.HTMLTextExtractor, org.apache.jackrabbit.extractor.PlainTextExtractor, org.apache.jackrabbit.extractor.XMLTextExtractor" /> </SearchIndex> </Workspace> <Versioning rootPath="${rep.home}/version"> <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"> <param name="path" value="${rep.home}/workspaces/version" /> </FileSystem> <PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager"> <param name="driver" value="org.postgresql.Driver"/> <param name="url" value="jdbc:postgresql://localhost:5432/magnolia_author" /> <param name="schema" value="postgresql" /><!-- warning, this is not the schema name, it's the db type --> <param name="user" value="magnolia" /> <param name="password" value="password" /> <param name="schemaObjectPrefix" value="version_" /> <param name="externalBLOBs" value="false" /> </PersistenceManager> </Versioning> </Repository> {code} |
Here
...
the
...
config
...
file
...
(
...
WEB-INF/config/repo-conf/jackrabbit-bundle-postgres-search.xml
...
)
...
for
...
instance
...
magnoliaPublic
| Code Block |
|---|
{code} <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD Jackrabbit 1.5//EN" "http://jackrabbit.apache.org/dtd/repository-1.5.dtd"> <Repository> <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"> <param name="path" value="${rep.home}/repository" /> </FileSystem> <Security appName="Jackrabbit"> <AccessManager class="org.apache.jackrabbit.core.security.SimpleAccessManager"></AccessManager> <LoginModule class="org.apache.jackrabbit.core.security.SimpleLoginModule"> <param name="anonymousId" value="anonymous" /> </LoginModule> </Security> <DataStore class="org.apache.jackrabbit.core.data.FileDataStore"> <param name="path" value="${rep.home}/repository/datastore"/> <param name="minRecordLength" value="1024"/> </DataStore> <Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default" /> <Workspace name="default"> <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"> <param name="path" value="${wsp.home}/default" /> </FileSystem> <PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager"> <param name="driver" value="org.postgresql.Driver"/> <param name="url" value="jdbc:postgresql://localhost:5432/magnolia_public" /> <param name="schema" value="postgresql" /><!-- warning, this is not the schema name, it's the db type --> <param name="user" value="magnolia" /> <param name="password" value="password" /> <param name="schemaObjectPrefix" value="${wsp.name}_" /> <param name="externalBLOBs" value="false" /> </PersistenceManager> <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex"> <param name="path" value="${wsp.home}/index" /> <param name="useCompoundFile" value="true" /> <param name="minMergeDocs" value="100" /> <param name="volatileIdleTime" value="3" /> <param name="maxMergeDocs" value="100000" /> <param name="mergeFactor" value="10" /> <param name="maxFieldLength" value="10000" /> <param name="bufferSize" value="10" /> <param name="cacheSize" value="1000" /> <param name="forceConsistencyCheck" value="false" /> <param name="autoRepair" value="true" /> <param name="analyzer" value="org.apache.lucene.analysis.standard.StandardAnalyzer" /> <param name="queryClass" value="org.apache.jackrabbit.core.query.QueryImpl" /> <param name="respectDocumentOrder" value="true" /> <param name="resultFetchSize" value="2147483647" /> <param name="extractorPoolSize" value="3" /> <param name="extractorTimeout" value="100" /> <param name="extractorBackLogSize" value="100" /> <param name="textFilterClasses" value="org.apache.jackrabbit.extractor.MsWordTextExtractor, org.apache.jackrabbit.extractor.MsExcelTextExtractor, org.apache.jackrabbit.extractor.MsPowerPointTextExtractor, org.apache.jackrabbit.extractor.PdfTextExtractor, org.apache.jackrabbit.extractor.OpenOfficeTextExtractor, org.apache.jackrabbit.extractor.RTFTextExtractor, org.apache.jackrabbit.extractor.HTMLTextExtractor, org.apache.jackrabbit.extractor.PlainTextExtractor, org.apache.jackrabbit.extractor.XMLTextExtractor" /> </SearchIndex> </Workspace> <Versioning rootPath="${rep.home}/version"> <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"> <param name="path" value="${rep.home}/workspaces/version" /> </FileSystem> <PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager"> <param name="driver" value="org.postgresql.Driver"/> <param name="url" value="jdbc:postgresql://localhost:5432/magnolia_public" /> <param name="schema" value="postgresql" /><!-- warning, this is not the schema name, it's the db type --> <param name="user" value="magnolia" /> <param name="password" value="password" /> <param name="schemaObjectPrefix" value="version_" /> <param name="externalBLOBs" value="false" /> </PersistenceManager> </Versioning> </Repository> {code} |
You
...
need
...
to
...
download
...
the
...
jdbc-driver
...
for
...
postgreSQL.
...
You
...
find
...
drivers
...
under
...
http://jdbc.postgresql.org/download.html
...
.
...
Put
...
this
...
driver
...
into
...
the
...
WEB-INF/lib
...
folder
...
of
...
each
...
instance.
...
You
...
may
...
want
...
to
...
delete
...
unused
...
drivers
...
like
...
Derby....jar.
Please make sure that you use a matching jdbc driver for you postgre installation. Otherwise you will experience severe performance problems and/or magnolia malfunctions.
Databases
The databases first have to be created by you. Check the postgreSQl docu when you are not familar with postgreSQL.
Remote acces to PostgreSQL database
It is possible to acces database via TCP/IP connection. By default TCP/IP connection is disabled.
You have to configure postgresql.conf to allow TCP/IP communication.
| Code Block |
|---|
listen_addresses='<ip_address>'
|
And you have to configure pg_hba.conf to allow connection from another PC
| Code Block |
|---|
TYPE DATABASE USER CIDR-ADDRESS METHOD host all all x.x.x.x/32 password . h3. Databases The databases first have to be created by you. Check the postgreSQl docu when you are not familar with postgreSQL. |