CODEWITHSUNDEEP
pythonpostgresqlpython-3.x
M1nt_zwy
M1nt_zwy

Reputation: 927

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.

Upvotes: 21

Views: 93233

Answers (4)

Emac342007
Emac342007

Reputation: 359

Do make sure that you've started postgress with systemctl start postgresql

Upvotes: 0

David Delgado Déniz
David Delgado Déniz

Reputation: 21

Uncommenting listen_address line and introducing '*' worked for me. In the beginning was working without it (gunicorn with Postgres database)

Upvotes: 0

Rt.Tong
Rt.Tong

Reputation: 194

1. Modify two configure files
# vi /var/lib/pgsql/data/postgresql.conf
 Replace the line:
listen_addresses = 'localhost'  -> listen_addresses = '*'
# vi /var/lib/pgsql/data/pg_hba.conf
 Add the line at the very end:
host all all 0.0.0.0/0 trust
(If IPv6:
host all all ::/0 trust) 
2. Restart the database service
# service postgresql restart
3. Disable the firewall
# rcSuSEfirewall2 stop
# chkconfig SuSEfirewall2 off
# chkconfig SuSEfirewall2_init off

Upvotes: 6

larsks
larsks

Reputation: 311238

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.

Upvotes: 17

Related Questions