Re: Cant connect to psql on winxp

Поиск
Список
Период
Сортировка
От Wolfgang Schedl
Тема Re: Cant connect to psql on winxp
Дата
Msg-id 3067.83.65.166.242.1160397370.squirrel@webmail.consult-it.biz
обсуждение исходный текст
Ответ на Re: Cant connect to psql on winxp  (Ray Stell <stellr@cns.vt.edu>)
Список pgsql-admin
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
---------------------------------------


В списке pgsql-admin по дате отправления:

Предыдущее
От: Ray Stell
Дата:
Сообщение: Re: Cant connect to psql on winxp
Следующее
От: "Fourat Zouari"
Дата:
Сообщение: Copying data from table to table (cloned tables)