Configure PostgreSQLExternal Database

Follow these steps to configure PostgreSQL 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