shutting off my firewall via 'service iptables stop' solves the problem... what needs to be modified in the iptables to allow remote pg connections?
Richard Huxton wrote:
Michael Korotun wrote:
Hi Guys,
I can't get working remote tcp connections on default port 5432. Environment is as follows
OS: Fedora Core 3 DB: Postgresql 8.0.1
1) The listen_addresses is set to '*' in postgresql.conf
2) pg_hba.conf is edited with client host ip, (the one which tries to
eastablish connection)
1. Turn connection logging on in your postgresql.conf and restart postgresql.
2. From the database server, try "telnet localhost 5432" - it should connect (and display nothing). Type "A" and hit return twice - you should be disconnected. Check your logs and there should be a message about an invalid startup packet.
3. Do the same from your client, "telnet DB-SERVER-IP-ADDRESS 5432" and repeat the test.
If step 3 works, then there's no problem with the server. If you can't connect at step 3 and PG doesn't log anything then you probably have a firewall in the way.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
