Re: TCP/IP connection problem

[Ben Suffolk <ben(at)vanilla(dot)net>]

> 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