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.

 
Notice
  • 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

Creates tables used for Airlock IAM.

Upgrades IAM 8.3 database schema for release IAM 8.4.

Upgrades IAM 8.2 database schema for release IAM 8.3.

Upgrades IAM 8.1 database schema for release IAM 8.2.

Upgrades IAM 8.0 database schema for release IAM 8.1.

Inserts an administrator “admin” with password “password” (works with demo configuration).

 
Notice

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

JDBC connector (JDBC driver)

  1. 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.
  2. Copy the driver (JAR file) to the libs folder of the common instance (or an instance's folder).
    Example:
  3.  
    Terminal box
    cp postgresql-*.jar instances/common/libs/
  4. Configure the database pool plugin (JDBC Connection Pool) accordingly:
    1. Driver Class: org.postgresql.Driver
    2. Url: The JDBC connection string (examples are given in property documentation in the Config Editor).
  6. Restart the IAM instance(s): see e.g. Starting and stopping Airlock IAM (system service integration).

Further information and links