Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 42A669F9F80 for ; Mon, 9 Oct 2006 03:56:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 67327-05 for ; Mon, 9 Oct 2006 03:56:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ns1.peker.com.pl (181-ego-2.acn.waw.pl [62.121.85.181]) by postgresql.org (Postfix) with SMTP id 7D2A79F9D99 for ; Mon, 9 Oct 2006 03:56:12 -0300 (ADT) Received: (qmail 10710 invoked by uid 540); 9 Oct 2006 06:44:01 -0000 Received: from 153.19.179.26 by ns1.peker.com.pl (envelope-from , uid 401) with qmail-scanner-1.25st (clamdscan: 0.82/760. spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:1(153.19.179.26):. Processed in 0.083599 secs); 09 Oct 2006 06:44:01 -0000 Received: from rzgw.artnet.pl (HELO ?10.4.128.107?) (informatyka-adamr@153.19.179.26) by ns1.peker.com.pl with SMTP; 9 Oct 2006 06:44:00 -0000 Message-ID: <4529F274.7030104@informatyka.gdansk.pl> Date: Mon, 09 Oct 2006 08:55:48 +0200 From: Adam Radlowski User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: wosforum@consult-it.biz CC: pgsql-admin@postgresql.org Subject: Re: Cant connect to psql on winxp References: <32968.62.178.153.212.1160199318.squirrel@webmail.consult-it.biz> In-Reply-To: <32968.62.178.153.212.1160199318.squirrel@webmail.consult-it.biz> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.339 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO, HOT_NASTY X-Spam-Level: X-Archive-Number: 200610/52 X-Sequence-Number: 23355 Four thigs: 1. Do You have in "postgresql.conf" in section "CONNECION AND AUTENTICATION" active opction (default is 'localhost'): listen_adress='*' (if You want to be more safe, read PDF with PostgreSQL doc chapter 17) 2. You're telneting 83.xxx.xxx.xxx, but You have 62.xxx.xxx.xxx in pg_hba.conf 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. With greetings Adam Wolfgang Schedl wrote: >Hello, > >I have a postgresql-server 8.1 running on a winxp-server. I want to >connect with my ubuntu at home (in the end, it should work with a >ASP.net-program) to the db, but it fails to connect. The port is open - I >can prove this with a working telnet connection. >----- >user@pc:~$ telnet 83.xxx.xxx.xxx 5432 >Trying 83.xxx.xxx.xxx... >Connected to 83.xxx.xxx.xxx. >Escape character is '^]'. >----- >The problem is, that the psql-connection fails. >----- >----- >My admin-tool for the pqsql-Server is pgadminIII. I tried to change the >pg_hba.conf and added a line with my IP-adress with the pgadminIII. The >line is correct in the pg_hba.conf. >----- >host all all 62.xxx.xxx.xxx md5 >----- >In the config-file everything looks fine, but when I start >pgadminIII->Tools->Server Configuration->pg_hba.conf, it still doesn't >show this line. Could this be the problem or is it just a >pgadminIII-WinXP-bug? > >Any ideas, how I could solve the problem? > >Thanks > >Mit freundlichen Grüssen / Best Regards >--------------------------------------- >Wolfgang Schedl > > >---------------------------(end of broadcast)--------------------------- >TIP 2: Don't 'kill -9' the postmaster > > > >