Re: TCP/IP connection problem

From: Jari Vauhkonen <jari(dot)vauhkonen(at)joensuu(dot)fi>
To: Ben Suffolk <ben(at)vanilla(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: TCP/IP connection problem
Date: 2006-10-26 15:52:23
Message-ID: 1161877943.4540d9b7b6215@wwwmail.joensuu.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Quoting Ben Suffolk <ben(at)vanilla(dot)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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-10-26 15:52:55 Re: Postgres timestamps are out by one hour
Previous Message Enrico 2006-10-26 15:41:10 Re: TCP/IP connection problem