pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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