Configure Postgres external database
Follow these steps to configure Postgres external database:
-
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;
-
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 thepg_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