Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id DFBA19FB5A2 for ; Mon, 9 Oct 2006 09:45:38 -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 37014-08 for ; Mon, 9 Oct 2006 12:45:33 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 037679FB5A0 for ; Mon, 9 Oct 2006 09:45:32 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from consult-it.biz (83-65-166-244.work.xdsl-line.inode.at [83.65.166.244]) by svr4.postgresql.org (Postfix) with ESMTP id C483B5AF894 for ; Mon, 9 Oct 2006 12:45:31 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by consult-it.biz (Postfix) with ESMTP id 2CA596B8D7; Mon, 9 Oct 2006 14:36:50 +0200 (CEST) Received: from consult-it.biz ([127.0.0.1]) by localhost (chef [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05671-09; Mon, 9 Oct 2006 14:36:10 +0200 (CEST) Received: from webmail.consult-it.biz (localhost.localdomain [127.0.0.1]) by consult-it.biz (Postfix) with ESMTP id 403E16B8D6; Mon, 9 Oct 2006 14:36:10 +0200 (CEST) Received: from 83.65.166.242 (SquirrelMail authenticated user ciwos) by webmail.consult-it.biz with HTTP; Mon, 9 Oct 2006 14:36:10 +0200 (CEST) Message-ID: <3067.83.65.166.242.1160397370.squirrel@webmail.consult-it.biz> In-Reply-To: <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> <20061009123938.GC9700@cns.vt.edu> Date: Mon, 9 Oct 2006 14:36:10 +0200 (CEST) Subject: Re: Cant connect to psql on winxp From: "Wolfgang Schedl" To: "Ray Stell" Cc: pgsql-admin@postgresql.org Reply-To: wosforum@consult-it.biz User-Agent: SquirrelMail/1.4.6-rc1 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at consult-it.biz X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.305 tagged_above=0 required=5 tests=BIZ_TLD, FORGED_RCVD_HELO, HOT_NASTY X-Spam-Level: ** X-Archive-Number: 200610/56 X-Sequence-Number: 23359 I meant, that the pga_postgres.conf-setting "listen_adress='*'" did the trick! :-) Thanks again Wolfgang > 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 > > Mit freundlichen Grüssen / Best Regards --------------------------------------- Wolfgang Schedl Mobil +43/699/143 695 77 Fax +43/699/443 695 77 mailto:wolfgang.schedl@consult-it.biz --------------------------------------- CONSULT|IT GmbH A-7311 Neckenmarkt www.consult-it.biz ---------------------------------------