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?
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 |