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

From Jari Vauhkonen
Subject Re: TCP/IP connection problem
Date
Msg-id 1161877943.4540d9b7b6215@wwwmail.joensuu.fi
Whole thread Raw
In response to Re: TCP/IP connection problem  (Ben Suffolk <ben@vanilla.net>)
Responses Re: TCP/IP connection problem
List pgsql-admin
Quoting Ben Suffolk <ben@vanilla.net>:

> >>>> actually have done anything.
> >>>
> >>> thank you for your reply. A truly amateurish mistake by me :)
> >>>
> >>> BUT fixing that one did no good. The problem remains.
> >>
> >> Did you restart the server after changing those lines?
> >>
> >> --
> >
> > Yes.
>
> When you try and connect check /var/log/messages for any errors, and
> let us know what (if any) errors are reported.
>

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?

pgsql-admin by date:

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