Configure an external database for ADBM

Daria Barysheva

For production environments, it is recommended to use an external PostgreSQL database as ADBM data storage for high performance and fault tolerance. Starting with ADBM 1.7.3, to configure an external database, you need to follow the steps that are described below:

  1. Perform the following queries in PostgreSQL. The queries should be run under the default user postgres with the superuser rights:

    CREATE ROLE <user_name> LOGIN PASSWORD '<user_password>' SUPERUSER; (1)
CREATE DATABASE <database_name> WITH owner <user_name>; (2)
CREATE SCHEMA adbm;
GRANT USAGE, CREATE ON SCHEMA adbm TO <user_name>; (3)
ALTER DEFAULT PRIVILEGES IN SCHEMA adbm GRANT UPDATE, INSERT, SELECT, DELETE ON TABLES TO <user_name>;
CREATE EXTENSION pgcrypto WITH schema adbm;
CREATE EXTENSION btree_gin WITH schema adbm;
CREATE EXTENSION pg_trgm WITH schema adbm;
GRANT SELECT ON pg_extension TO <user_name>;
    1 Create the <user_name> user with appropriate rights for connecting to the external database.
    2 Create the <database_name> database with the adbm schema for ADBM data migration.
    3 Create extensions in the adbm schema and grant of their usage to the <user_name> user.
    NOTE
    The SUPERUSER option is used temporarily and will be removed in the next releases.

  2. Provide the ADBM access to the external PostgreSQL database by adding the following record to the pg_hba.conf file on the PostgreSQL server:

    host    <database_name>  <user_name>       <adbm_address>      trust

    where:

    • <database_name> — a name of the created database.

    • <user_name> — a name of the created user.

    • <adbm_address> — an IP address of ADBM with a subnet number.

  3. On the ADBM service configuration page, activate the External database parameters toggle and fill in all parameters in the list that opens. The assignment of parameters is described in the Configuration parameters → ADBM → External database parameters section.

    Parameters for connecting to the external PostgreSQL DB
    Parameters for connecting to the external PostgreSQL DB

  4. Click Save to save the ADBM configuration.

  5. Install the ADBM service using the Install service action or apply the Reconfigure & Restart action to the ADBM service if it is already installed.

Found a mistake? Seleсt text and press Ctrl+Enter to report it