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
...
| Code Block |
|---|
magnolia.repositories.jackrabbit.config=WEB-INF/config/repo-conf/jackrabbit-bundle-postgres-search.xml |
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.
...
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.
...