Re: remote tcp connection problem PG 8.0.1 - Mailing list pgsql-general

From Richard Huxton
Subject Re: remote tcp connection problem PG 8.0.1
Date
Msg-id 4278B555.4080606@archonet.com
Whole thread Raw
In response to remote tcp connection problem PG 8.0.1  ("Michael Korotun" <michael@softasap.net>)
Responses Re: remote tcp connection problem PG 8.0.1
List pgsql-general
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

pgsql-general by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: getting the ranks of items
Next
From: merlyn@stonehenge.com (Randal L. Schwartz)
Date:
Subject: Re: getting the ranks of items