DLM Installation and Upgrade
Also available as:
PDF

Configure Postgres external database

Follow these steps to configure Postgres external database:

  1. Create the database and user for DLM engine. Replace the username, password, and the dbname.
    
    CREATE USER beacon WITH PASSWORD 'beacon';
    CREATE DATABASE beacondb;
    GRANT ALL PRIVILEGES ON DATABASE beacondb TO beacon;
    
  2. Configure the postgresql, so that the DLM engine can connect to this DB instance.
    Verify the DB access by running this command on the DLM Engine host: psql -h <postgres_server_host> -U beacon -d beacondb
    If you cannot connect to the postgres server from DLM Engine host, refer to the Postgres documentation on setting up the pg_hba.conf.
    For example:

    Add the following entries to /var/lib/pgsql/data/pg_hba.conf file:

               local beacondb      beacon trust
               host dlmenginehost  beacon 0.0.0.0/0 trust
               host dlmenginehost  beacon ::/0 trust 

    Restart the PostgreSQL service: service postgresql restart

    Verify client access: psql -h <POSTGRES_SERVER_HOSTNAME> -U beacon -d beacondb