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.

$ createuser --pwprompt openkm
$ createdb --owner=openkm --encoding=UTF8 okmdb

More info at:

Configure your openkm.properties

Edit the file $TOMCAT_HOME/openkm.properties

spring.jpa.properties.hibernate.dialect=com.openkm.db.dialect.PostgreSQLDialectspring.jpa.hibernate.ddl-auto=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

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 the application

During 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 you with this task.

PostgreSQL 9.6 and later

PostgreSQL versions 9.6 and later have changed some tables and columns in the schema. Check that you are using the correct JDBC driver.