pgAdmin cannot connect to PostgreSQL 9.1
Posted
by
Nyxynyx
on Server Fault
See other posts from Server Fault
or by Nyxynyx
Published on 2013-03-26T01:46:31Z
Indexed on
2013/11/10
9:58 UTC
Read the original article
Hit count: 393
I am trying to use pgAdmin on Windows to connect to postgresql
9.1.8 running on localhost's Ubuntu 12.04 VM. The host's port 5432 forwards to VM's port 5432.
pgAdmin Error:
Error connecting to the server: could not receive data from server: Software caused connection abortion (0x00002745/10053)
postgresql.conf
#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------
# - Connection Settings -
listen_addresses = '*'
port = 5432
pg_hba.conf
local all postgres peer
# TYPE DATABASE USER ADDRESS METHOD
host all all 0.0.0.0/0 md5
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
netstat -nlp | 5432
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 29035/postgres
unix 2 [ ACC ] STREAM LISTENING 50823 29035/postgres /var/run/postgresql/.s.PGSQL.5432
iptables rule
iptables -I INPUT -p tcp --dport 5432 -j ACCEPT
PostgreSQL service has been restarted and pgAdmin still gives the error. Any ideas what have caused it?
© Server Fault or respective owner