postgresql.conf

The /var/lib/pgsql/9.6/data/postgresql.conf file controls the behavior of the PostgreSQL database.

Shared port

If the database and the datamart are using the same port (port 5432), this configuration file supports both.
If the database and the datamart are on separate boxes, identical copies of this configuration file must exist in /var/lib/pgsql/9.6/data on both boxes.

                                        
# -----------------------------
# PostgreSQL configuration file
# -----------------------------
#
<snip>

#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------

# - Connection Settings -

#listen_addresses = 'localhost'		# what IP address(es) to listen on;
					# comma-separated list of addresses;
					# defaults to 'localhost', '*' = all
					# (change requires restart)

listen_addresses = '127.0.0.1,<database_host_ip>'		# what IP address(es) to listen on; 
#port = 5432 # (change requires restart)


<snip>

Separate ports

If the database and the datamart are on the same box but using separate ports, copies of this configuration file must exist in both /var/lib/pgsql/9.6/data and /var/lib/pgsql/9.6/reports. Each copy must identify a different port.

This file is in /var/lib/pgsql/9.6/data.

This copy of the file is in /var/lib/pgsql/9.6/reports. Note the different port number.

                                        
# -----------------------------
# PostgreSQL configuration file
# -----------------------------
#
<snip>

#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------

# - Connection Settings -

#listen_addresses = 'localhost'		# what IP address(es) to listen on;
					# comma-separated list of addresses;
					# defaults to 'localhost', '*' = all
					# (change requires restart)

listen_addresses = '127.0.0.1,<database_host_ip>'		# what IP address(es) to listen on; 
#port = 5632 # (change requires restart)


<snip>