Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id D72129FB593 for ; Mon, 9 Oct 2006 09:39:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 39300-05 for ; Mon, 9 Oct 2006 12:39:40 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by postgresql.org (Postfix) with ESMTP id 701549FB576 for ; Mon, 9 Oct 2006 09:39:40 -0300 (ADT) Received: by locust.cns.vt.edu (Postfix, from userid 986) id B9F29118A1C; Mon, 9 Oct 2006 08:39:38 -0400 (EDT) Date: Mon, 9 Oct 2006 08:39:38 -0400 From: Ray Stell To: Wolfgang Schedl Cc: Adam Radlowski , pgsql-admin@postgresql.org Subject: Re: Cant connect to psql on winxp Message-ID: <20061009123938.GC9700@cns.vt.edu> References: <32968.62.178.153.212.1160199318.squirrel@webmail.consult-it.biz> <4529F274.7030104@informatyka.gdansk.pl> <1038.83.65.166.242.1160385622.squirrel@webmail.consult-it.biz> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1038.83.65.166.242.1160385622.squirrel@webmail.consult-it.biz> User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.157 tagged_above=0 required=5 tests=HOT_NASTY X-Spam-Level: X-Archive-Number: 200610/55 X-Sequence-Number: 23358 On Mon, Oct 09, 2006 at 11:20:22AM +0200, Wolfgang Schedl wrote: > Thanks, point 3 did the trick! Seems, I have to read the documentation > better.... point 3 was a test, right? You are not intending to leave it that way, of course? > > 3. Try using mode "open for all": 0.0.0.0/0. If You have this mode and > > "listen_adress='*'" You have fully open PostgreSQL. If You have still > > problems, this should be TCP/IP connection problem. If You want to be > > more safe: if You are using 24 mode adress, so in pg_hba.conf You will > > have: xxx.xxx.xxx.0/24, 32 mode: xxx.xxx.xxx.xxx/32 for more read PDF > > with PostgreSQL doc (chapter 20) > > 4. Do You have really telnet service started on 5432 port ? I suggest to > > stop this service, when You are using other service on tis same port. you can use the telnet client to connect to any port, the telnet service does not have to be the service that syn/acks: [postgresql@wireworm postgresql]$ telnet stell 25 Trying 198.82.169.14... Connected to locust.cns.vt.edu (198.82.169.14). Escape character is '^]'. 220 locust.cns.vt.edu ESMTP