Re: remote tcp connection problem PG 8.0.1

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