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