I am having a problem getting postgres to accept connections from my other server. Here's my setup:
- APP06 (10.55.129.31): Server running Postgres
- APP05 (10.55.129.30): Server trying to connect to Postgres
/var/lib/pgsql/data/pg_hba.conf file on app06:
# TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 10.55.129.30/32 trust host all all 10.55.129.31/32 trust host all all 0.0.0.0/0 trust # IPv6 local connections: host all all ::1/128 trust
It's not exactly what I want (I'd like to use LDAP), but it should at least work. I want to connect 10.55.129.30 to 10.44.129.31. The first
host line should be all I need. The third
host line should allow a connection from anywhere.
Now, we start up Postgres on app06
$ /etc/init.d/postgres start $ /etc/init.d/postgres status pg_ctl: server is running (PID: 30091) /usr/bin/postgres "-D" "/var/lib/pgsql/data"
Let's look at Netstat:
$ netstat -nlp | grep 5432 tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 30091/postmaster unix 2 [ ACC ] STREAM LISTENING 16490154 30091/postmaster /tmp/.s.PGSQL.5432
Okay... I think... Not being a real system administrator, I can't say exactly what that means, but it looks like PID 30091 (process postmaster) has port 5432 open.
Let's see if anything is listening on port 5432
$ telnet localhost 5432 Trying 127.0.0.1... Connected to localhost.localdomain (127.0.0.1). Escape character is '^]'.
Okay, Port 5432 is open and accepting connections.
Now, we'll go to APP05 and see if we can connect...
I've already tried running
psql from app05 with no success. Can I talk to app06?
$ ping app06 PING app06 (10.55.129.31) 56(84) bytes of data. 64 bytes from app06 (10.55.129.31): icmp_seq=1 ttl=64 time=0.901 ms 64 bytes from app06 (10.55.129.31): icmp_seq=2 ttl=64 time=0.230 ms --- app06 ping statistics --- 2 packets transmitted, 6 received, 0% packet loss, time 5001ms
Okay, I can talk to app06 from app05. Let's see if I can connect to Postgres' port:
$ telnet app06 5432 Trying 10.55.129.31... telnet: connect to address 10.55.129.31: Connection refused telnet: Unable to connect to remote host: Connection refused
I'm not able to connect to port 5432
/usr/sbin/lokkit and verified that the software firewall is turned off.
I'm not a network or system administrator by any means. I am not a postgres administrator either. It's very possible I missed some simple, stupid thing, but I don't know what.
I'm pretty sure that Port 5432 on these machines are open on the network. I tried switching the Postgres port to 8999 which I sure is not blocked, but I get the same issue.
Any idea what I am doing wrong?