pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Adam Radlowski <adamr@informatyka.gdansk.pl>
To: wosforum@consult-it.biz
Cc: pgsql-admin@postgresql.org
Subject: Re: Cant connect to psql on winxp
Date: Mon, 09 Oct 2006 08:55:48 +0200
Message-ID: <4529F274.7030104@informatyka.gdansk.pl> (raw)
In-Reply-To: <32968.62.178.153.212.1160199318.squirrel@webmail.consult-it.biz>
References: <32968.62.178.153.212.1160199318.squirrel@webmail.consult-it.biz>

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
>
>
>  
>




view thread (5+ messages)  latest in thread

Message-ID: <4529F274.7030104@informatyka.gdansk.pl>
Permalink:  ../4529F274.7030104@informatyka.gdansk.pl/
Also on:    postgresql.org/message-id/4529F274.7030104@informatyka.gdansk.pl

 · 

reply

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: adamr@informatyka.gdansk.pl, wosforum@consult-it.biz
  Subject: Re: Cant connect to psql on winxp
  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>

* 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