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.
Here,I’ve modified the
host all all 218.3.A.B trust and reloaded.But it didn’t work either.
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
postgresql.conf file is found in your postgresql data directory, which is often something like
listen_addresses parameter is documented here.