I restarted after, it wasn't a change in the configuration, postgres installs default with tcp/ip enabled (or beacuse my old version pinned 7.2 was configured like this).
output of netstat gives: tcp 0 0 0.0.0.0:10080 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:2401 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:139 0.0.0.0:* LISTEN tcp 0 0 192.168.2.20:80 0.0.0.0:* LISTEN tcp 0 0 127.0.0.1:10005 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:10009 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:25 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:443 0.0.0.0:* LISTEN tcp 0 0 0.0.0.0:445 0.0.0.0:* LISTEN its apache, samba ports, cvs, email ports, mysql , ssh and tomcat, but not port 5432 for postgres, so its not listening thanks for the help hans On Tue, Feb 03, 2004 at 09:12:14AM -0500, Adam Aube wrote: > On Tuesday 03 February 2004 08:28 am, Hans Steinraht wrote: > > The only waht not is working is that I cannot connect to postgresql > > through TCP/IP. > > > In /etc/postgresql.conf I have: tcpip_socket = true, but its not > > working. > > You specified that you restarted postgresql - I assume that you did it > AFTER making the configuration change. If not, try restarting it again. > > Next, try: > > $ netstat -a -n | grep "tcp" | grep "LISTEN" > > Look for the port postgresql is supposed to listen on to make sure that > it's really listening. > > If postgresql is listening, but you can't connect to it, make sure your > firewall isn't interfering. > > Adam > > > -- > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] > -- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]