Installing HDF Services on an Existing HDP Cluster for IBM Power Systems
Also available as:
PDF
loading table of contents...

Configure Postgres to Allow Remote Connections

About This Task

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

Steps

  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:

  4. systemctl stop postgresql-9.6.service
    systemctl start postgresql-9.6.service