From: Ray Stell <stellr@cns.vt.edu>
To: Wolfgang Schedl <wosforum@consult-it.biz>
Cc: Adam Radlowski <adamr@informatyka.gdansk.pl>
Cc: pgsql-admin@postgresql.org
Subject: Re: Cant connect to psql on winxp
Date: Mon, 9 Oct 2006 08:39:38 -0400
Message-ID: <20061009123938.GC9700@cns.vt.edu> (raw)
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>
On Mon, Oct 09, 2006 at 11:20:22AM +0200, Wolfgang Schedl wrote:
> Thanks, point 3 did the trick! Seems, I have to read the documentation
> better....
point 3 was a test, right? You are not intending to leave it that way,
of course?
> > 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.
you can use the telnet client to connect to any port, the telnet service
does not have to be the service that syn/acks:
[postgresql@wireworm postgresql]$ telnet stell 25
Trying 198.82.169.14...
Connected to locust.cns.vt.edu (198.82.169.14).
Escape character is '^]'.
220 locust.cns.vt.edu ESMTP
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: stellr@cns.vt.edu, wosforum@consult-it.biz, adamr@informatyka.gdansk.pl
Subject: Re: Cant connect to psql on winxp
In-Reply-To: <20061009123938.GC9700@cns.vt.edu>
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> <20061009123938.GC9700@cns.vt.edu>
* 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