Re: TCP/IP connection problem - Mailing list pgsql-admin

From Ben Suffolk
Subject Re: TCP/IP connection problem
Date
Msg-id C3D6E6E3-817D-43FB-8A89-02FBA469375C@vanilla.net
Whole thread Raw
In response to Re: TCP/IP connection problem  (Jari Vauhkonen <jari.vauhkonen@joensuu.fi>)
Responses Re: TCP/IP connection problem  (Jari Vauhkonen <jari.vauhkonen@joensuu.fi>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres timestamps are out by one hour
Next
From: "Simon Kinsella"
Date:
Subject: Re: Postgres timestamps are out by one hour