Re: TCP/IP connection problem

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

In response to

Responses

Browse pgsql-admin by date

  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