PostgreSQL as Airlock IAM database

This page describes how to use a PostgreSQL database with the Airlock IAM database schema.

The chosen data layer has to be well managed and monitored. IAM is not responsible for the operation and backup/recovery. For production usage, the data layer should be clustered.

Schema creation and upgrade

SQLs scripts for Oracle databases are available here:

SQL File	Description
create-medusa-schema.sql	Creates tables used for Airlock IAM.
insert-admin.sql	Inserts an administrator "admin" with password "password" (works with demo configuration).

For performance tuning hints, see: Performance tuning and scaling best practices

JDBC connector (JDBC driver)

The JDBC connector (postgresql-*.jar) can be downloaded from the PostgreSQL driver downloads website. Make sure to download a version of the JDBC Connector suitable for your PostgreSQL database.
Copy the driver (JAR file) to the libs folder of the common instance (or an instance's folder). Example: cp postgresql-*.jar instances/common/libs/
Configure the database pool plugin (JDBC Connection Pool) accordingly:

Driver Class: org.postgresql.Driver
Url: The JDBC connection string (examples are given in property documentation in the Config Editor).

Restart the IAM instance(s): see e.g. Starting and stopping Airlock IAM (system service integration).

Further information and links

Minimal required database version see System requirements