postgresql.conf

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

Shared port

                                        
# -----------------------------
# 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>