Re: Cant connect to psql on winxp - Mailing list pgsql-admin

From Wolfgang Schedl
Subject Re: Cant connect to psql on winxp
Date
Msg-id 1038.83.65.166.242.1160385622.squirrel@webmail.consult-it.biz
Whole thread Raw
In response to Re: Cant connect to psql on winxp  (Adam Radlowski <adamr@informatyka.gdansk.pl>)
Responses Re: Cant connect to psql on winxp
List pgsql-admin
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
---------------------------------------


pgsql-admin by date:

Previous
From: "MG"
Date:
Subject: ERROR: invalid page header in block
Next
From: Ray Stell
Date:
Subject: Re: Cant connect to psql on winxp