Failure to connect to postgresql database with 5432 refused

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Getting the following error when trying to connect to postgresql database:

Nov 19 23:22:02:814 [attach_socket, postgresql] Error connecting to postgresql database :Connection to <server>:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

Environment

Version: 20.4, 23.4
Component: postgresql probe

Resolution

Uncomment/update the following lines in the postgresql.conf file:

listen_addresses = '*' # what IP address(es) to listen on;

# comma-separated list of addresses;

# defaults to 'localhost'; use '*' for all

# (change requires restart)

port = 5432 # (change requires restart)

max_connections = 100 # (change requires restart)