Re: TCP/IP connection problem

Поиск
Список
Период
Сортировка
От Ben Suffolk
Тема Re: TCP/IP connection problem
Дата
Msg-id C3D6E6E3-817D-43FB-8A89-02FBA469375C@vanilla.net
обсуждение исходный текст
Ответ на Re: TCP/IP connection problem  (Jari Vauhkonen <jari.vauhkonen@joensuu.fi>)
Ответы Re: TCP/IP connection problem
Список pgsql-admin
> 1) These are the latest messages ( /var/log/messages )
> Only my test of closing down & reopening postgresql.
>
> Oct 26 18:33:25 joymap su(pam_unix)[4901]: session opened for user
> postgres by
> root(uid=0)
> Oct 26 18:33:25 joymap su(pam_unix)[4901]: session closed for user
> postgres
> Oct 26 18:33:33 joymap postgresql: postmaster shutdown succeeded
> Oct 26 18:33:35 joymap su(pam_unix)[4951]: session opened for user
> postgres by
> root(uid=0)
> Oct 26 18:33:35 joymap su(pam_unix)[4951]: session closed for user
> postgres
>
> 2) Enrico's firewall propotion:
> There is a firewall in WinXP ( F-Secure ). I allready tried
> disabling it. I have
> also configured the Red Hat security level. Right now it allows all
> traffic
> thru eth0.
>
> 3) I managed to get a connection-lookalike:
> netstat print:
>   tcp 0 0 <my_psql_server_domain>:postgres <my_client_domain>:2429
> TIME_WAIT
>
> What next?


I suggest you try and connect from the pgsql machine locally using
tcp :-

 > psql -h = same.host.as.configured.from.windows.box -p = 5432  db user

Then we can see if the problem still lies with pgsql, or with the
firewall.

BEn

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Postgres timestamps are out by one hour
Следующее
От: "Simon Kinsella"
Дата:
Сообщение: Re: Postgres timestamps are out by one hour