Configure the PostgreSQL Data Store

The Composer PostgreSQL data store must be configured so it is available to all Composer instances in the high availability environment. For more information about PostgreSQL high availability clustering, see https://www.postgresql.org/docs/12/high-availability.html.

To configure the PostgreSQL data store so it is available to all Composer instances:

1. Edit the postgresql.conf file:

   vi /var/lib/pgsql/12/data/postgresql.conf

2. Set the following property in postgresql.conf and save the file.

   listen_address='*'

3. Edit the pg_hba.conf file:

   vi /var/lib/pgsql/12/data/pg_hba.conf

4. Add the following to the pg_hba.conf file:

   # TYPE DATABASE USER ADDRESS METHOD
   # IPv4 local connections
   host all all 0.0.0.0 /0 md5

5. Save the pg_hba.conf file.

6. Restart the PostgreSQL service:

   sudo service postgresql-12 restart