From: Wolfgang Schedl <wosforum@consult-it.biz>
To: Ray Stell <stellr@cns.vt.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Cant connect to psql on winxp
Date: Mon, 9 Oct 2006 14:36:10 +0200 (CEST)
Message-ID: <3067.83.65.166.242.1160397370.squirrel@webmail.consult-it.biz> (raw)
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>
I meant, that the pga_postgres.conf-setting "listen_adress='*'" did the
trick! :-)
Thanks again
Wolfgang
> 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
>
>
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
---------------------------------------
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: wosforum@consult-it.biz, stellr@cns.vt.edu
Subject: Re: Cant connect to psql on winxp
In-Reply-To: <3067.83.65.166.242.1160397370.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> <20061009123938.GC9700@cns.vt.edu> <3067.83.65.166.242.1160397370.squirrel@webmail.consult-it.biz>
* 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