Well, could this be your firewall blocking things? try to do this and restart postmaster...
iptables -I INPUT -d 127.0.0.0 -j ACCEPT Regards, Virat On 4/24/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > On 4/24/06, Devdas Bhagat <[EMAIL PROTECTED]> wrote: > > On 24/04/06 10:37 +0530, Raj Mathur wrote: > > <snip> > > > lazylabs> netstat -an shows that postmaster process is listening > > > lazylabs> on *:5432. > > > > > <snip> > > > > > > PostgreSQL doesn't listen on the TCP interface by default. You'll > > > have to enable tcpip_socket = true in postgresql.conf and restart > > > PostgreSQL. > > > > More likely a firewall, if the nestat result is true. OTOH, it might not > > be a postmaster on 5432 at all. lsof is your friend. > > firewall... iptables --list does not show anything.. > stock debian sarge is installed on this box.. > > it is indeed postmaster on 5432.. > $ netstat -anp | grep postmaster > tcp 0 0.0.0.0:5432 0.0.0.0:* LISTEN 1019/postmaster > > something is going crazy here.. > $ ping 127.0.0.1 > shows 100% packet loss > > ifconfig shows loopback interface (lo) UP and RUNNING.. > > howvever, trying to add route fails > $ route add -net 127.0.0.0 netmask 255.0.0.0 lo > says "No device" > > Also, there is some highly noticeable packet loss on interface eth0.. > is this bcoz of a bad ethernet card?? this is a 3com 905 card > $ lspci shows > 3Com 3c905C-TX/TX-M [Tornado] (rev 6c) > > seems like it has nothing to do with postgresql... :-) > > will try to get a new kernel as well.. > this machine runs 2.4.27 which is supposed to be quite stable.. > > but is it faulty hardware?? lo shud hav worked.. > > > ------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmdlnk&kid0709&bid&3057&dat1642 > _______________________________________________ > linux-india-help mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/linux-india-help > ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642 _______________________________________________ linux-india-help mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/linux-india-help
