Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group