PostgreSQL as Airlock IAM database

This page describes how to use a PostgreSQL database with the Airlock IAM database schema. In order to use Airlock IAM with this database, a JDBC connector/driver library is required.

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.
In order to use Airlock IAM with this database, a JDBC connector/driver library is required.

Schema creation and upgrade

SQL scripts for Oracle databases are available here:

SQL File	Description
create-medusa-schema.sql	Creates tables used for Airlock IAM.
iam-schema-migration-8_0-8_1.sql	Upgrades IAM 8.0 database schema for release IAM 8.1.
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:

copy

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