Re: Cant connect to psql on winxp

From: Adam Radlowski <adamr(at)informatyka(dot)gdansk(dot)pl>
To: wosforum(at)consult-it(dot)biz
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Cant connect to psql on winxp
Date: 2006-10-09 06:55:48
Message-ID: 4529F274.7030104@informatyka.gdansk.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)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
>
>
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message MG 2006-10-09 07:21:11 ERROR: invalid page header in block
Previous Message Wolfgang Schedl 2006-10-07 05:35:18 Cant connect to psql on winxp