From: Wolfgang Schedl <wosforum@consult-it.biz>
To: Adam Radlowski <adamr@informatyka.gdansk.pl>
Cc: pgsql-admin@postgresql.org
Subject: Re: Cant connect to psql on winxp
Date: Mon, 9 Oct 2006 11:20:22 +0200 (CEST)
Message-ID: <1038.83.65.166.242.1160385622.squirrel@webmail.consult-it.biz> (raw)
In-Reply-To: <4529F274.7030104@informatyka.gdansk.pl>
References: <32968.62.178.153.212.1160199318.squirrel@webmail.consult-it.biz>
<4529F274.7030104@informatyka.gdansk.pl>
Thanks, point 3 did the trick! Seems, I have to read the documentation
better....
Sorry for the simple question and thanks again
Wolfgang
> 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
>>
>>
>>
>>
>
>
>
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
---------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: wosforum@consult-it.biz, adamr@informatyka.gdansk.pl
Subject: Re: Cant connect to psql on winxp
In-Reply-To: <1038.83.65.166.242.1160385622.squirrel@webmail.consult-it.biz>
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>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox