Configuring PostgreSQL

Database creation

Create a database and user

DROP DATABASE IF EXISTS okmdb;
CREATE USER openkm WITH PASSWORD '*secret*';
CREATE DATABASE okmdb WITH OWNER openkm ENCODING 'UTF8';

or from the command line 

More info at:

• PostgreSQL 9.1 Documentation
• Guía Ubuntu: PostgreSQL

Configure your openkm.properties

Edit the file $TOMCAT_HOME/openkm.properties

hibernate.dialect=com.openkm.db.dialect.PostgreSQL92Dialect
hibernate.hbm2ddl=create-only

Configure Tomcat datasources

Edit the file $TOMCAT_HOME/openkm.properties and enable the resource named jdbc/OpenKMDS

spring.datasource.driver-class-name=org.postgresql.Driver
spring.datasource.url=jdbc:postgresql://localhost:5432/okmdb
spring.datasource.username=openkm
spring.datasource.password=*secret*
spring.datasource.validationQuery=SELECT 1 

Configure application login

Edit the file $. TOMCAT_HOME/openkm.properties

authentication.openkm.database=true

Enable native configuration parameter

Go to Administration > Configuration parameters 

native.sql.lowercase=true

Run application

As a process into OpenKM startup, the application will automatically create an empty database structure. 

Additional information

If you want to obtain the maximum performance from PostgreSQL, pgFouine will help in your task.

PostgreSQL 9.6 and upper

PostgreSQL version 9.6 and upper have changed some tables and columns of the schema. Check that you are using the correct JDBC driver.