Connection refused with postgresql using psycopg2

psycopg2.OperationalError: could not connect to server: Connection refused

Is the server running on host “45.32.1XX.2XX” and accepting TCP/IP connections on port 5432?

Here,I’ve open my sockets.

tcp        0      0 127.0.0.1:5432          0.0.0.0:*  LISTEN      11516/postgres                
tcp6       0      0 ::1:5432                :::*       LISTEN      11516/postgres

I googled that I should modify this pg_hba.conf，but in my postgresqlroot files, I didn’t find this file at all.

Also I’ve succeed in connecting my another server.

Thanks.

Here,I’ve modified the pg_hba.conf,updated thishost all all 218.3.A.B trust and reloaded.But it didn’t work either.

Answer

Your netstat output shows that postgres is listening on 127.0.0.1, but your error suggests you are trying to connect to 45.32.1XX.2XX. I am pretty sure you have already diagnosed your problem.

You will need to modify the listen_addresses setting your postgresql.conf file (not pg_hba.conf). The postgresql.conf file is found in your postgresql data directory, which is often something like /var/lib/postgresql/data or /var/lib/pgsql/data.

The listen_addresses parameter is documented here.