The PostgreSQL listen addresses are automatically configured by the Network Configuration Manager installer. Use this procedure to manually edit the addresses.
- Edit [Product_Directory]/db/controldb/data/postgresql.conf
- Locate the line that begins with
listen_addresses =(near line 56).Remove the leading pound sign, #, to uncomment the line. If the line is commented out, it defaults to listen only on the local loopback address. For example,
listen_addresses = 'localhost, 192.168.0.1' # Listen on localhost and 192.168.0.1 listen_addresses = '*' # Listen on all addressesThe list of listen addresses is comma delimited, and it must contain the 'localhost' address at a minimum. The list must be surrounded by single quotes. For example, to listen on all addresses, you can use an asterisk, '*'
- Save, and then Close the file.
- Stop the Sysadmin service (Linux): service sysadmin stop
- Stop the ncm-as service (Linux):
- Linux: service ncm-as stop
- Start the Sysadmin service (Linux): service sysadmin start
- Restart the controldb service (Linux):
- Linux: service controldb restart
- Start the ncm-as service (Linux):
- Linux: service ncm-as start
What to do next
Additional information on the postgresql.conf file can be found at: http://www.postgresql.org.