From: | Ben Suffolk <ben(at)vanilla(dot)net> |
---|---|
To: | Jari Vauhkonen <jari(dot)vauhkonen(at)joensuu(dot)fi> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: TCP/IP connection problem |
Date: | 2006-10-26 15:57:51 |
Message-ID: | C3D6E6E3-817D-43FB-8A89-02FBA469375C@vanilla.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Kinsella | 2006-10-26 16:07:01 | Re: Postgres timestamps are out by one hour |
Previous Message | Tom Lane | 2006-10-26 15:52:55 | Re: Postgres timestamps are out by one hour |