Cloudera Edge Management Installation
Also available as:
PDF

Configure Postgres to Allow Remote Connections

It is critical that you configure Postgres to allow remote connections before you deploy CEM. If you do not perform these steps in advance of installing the EFM Server, the installation fails.

  1. Open /var/lib/pgsql/9.6/data/pg_hba.conf and update to the following
    # "local" is for Unix domain socket connections only
    local all all trust
    
    
    # IPv4 local connections:
    host all all 0.0.0.0/0 trust 
    
    
    # IPv6 local connections: 
    host all all ::/0 trust 
    
  2. Open /var/lib//pgsql/9.6/data/postgresql.conf and update to the following:
    listen_addresses = '*'
    
  3. Restart Postgres:
    systemctl stop postgresql-9.6.service
    systemctl start postgresql-9.6.service