| 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: | Whole Thread | Raw Message | 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 |