Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id D57B4634128 for ; Mon, 20 Apr 2009 08:03:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 84986-01-6 for ; Mon, 20 Apr 2009 08:03:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web33108.mail.mud.yahoo.com (web33108.mail.mud.yahoo.com [209.191.69.138]) by mail.postgresql.org (Postfix) with SMTP id 02E59638B2D for ; Mon, 20 Apr 2009 03:31:14 -0300 (ADT) Received: (qmail 36049 invoked by uid 60001); 20 Apr 2009 06:31:12 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1240209072; bh=oRHwrERBehXvSD1XdfEVyf3cPHyW8HES+9FI2h5SFfQ=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type; b=M2/6BKWDSchxYJIIT33/MK2UEOhYt39OSRa4wC61BsQASXpFXyaB7AeR5M8s2jh47tiHu+es7f7eiCF1sTLOhKO6XWA/yveuwMPf8zwW3NbQkfmFPMTvPzd2Ae8Eomcp2fhyI186lWXAyIB3Y/FYUli/FAH30PrR6eAgAeHw7PI= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type; b=Q/v8NTddPIovyKb0dIF9VmpRq9wbjmSU308JHg4beUgydw9+RzDlOpRGqCC2RtmMGuASzgYBpEDo81X0zEKmAIcq6gX02KWXBakgrlza2FkS8xG1sCcG99tzjaKIhgVRH2SJThIBETT4rzh8A/8E6dOktAOH8UZ3kRAtq9u3jcM=; Message-ID: <463255.35846.qm@web33108.mail.mud.yahoo.com> X-YMail-OSG: 9nDz5K8VM1mFV.3nmg1jEswRrMyHGhxAbs0VwFEsM9TQJlPVf95CG7PTrkK26N7AtV8tFxBMVYQQU9BcnB9n_IHauYe0kIQovQTHeOW7.GxYnhzeHQ5RNr44A2pAQJuIse86rRQuXcc2rVMVv4cuxqpewSPzTJDg26g0z9OzQZi9swHB5ECELxPdK0QYbU1B6Jx8iy0mMc8QJL1TedA2CUZY5mRokEfnqOFh306z6xCu_nv9sht.I_NmOk8e7PFnBMPsGHDIDvH007ptpTC4eatMetq6vuGi3E1Ndg.KLjBq9_POWzsCebraK87spd0ApfjgvaGRkI1dt.bKBWdIkqdixZ9h4p7_rVkTk5ywojvKxR2KeQ-- Received: from [59.99.218.58] by web33108.mail.mud.yahoo.com via HTTP; Sun, 19 Apr 2009 23:31:12 PDT X-Mailer: YahooMailRC/1277.35 YahooMailWebService/0.7.289.1 Date: Sun, 19 Apr 2009 23:31:12 -0700 (PDT) From: Rohit Suman Subject: Re: Re: [GENERAL] Frequently unable connecting to db "server doesn't listen" To: Scott Marlowe Cc: nettreeinc@gmail.com, pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-368019845-1240209072=:35846" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200904/106 X-Sequence-Number: 32452 --0-368019845-1240209072=:35846 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable I had a quite of similar problem earlier..it was with WAPPSTACK package tha= t I had installed. Both the apache server and the postgresql stopped workin= g. So, I had to uninstall and install both of them . After a day or two sam= e thing happened. Then I scanned my PC using Avast Anti-Virus and there was= a virus in my pc, so when i deleted all infected files with virus...since = then I never had such a problem.=0A=0ASo, my advice...do virus scan using a= vast and remove malwares using malwarebytes. This should solve your problem= .=0A=0A=0A=0A=0A________________________________=0AFrom: Scott Marlowe =0ATo: Net Tree Inc. =0ACc: pgsq= l-general@postgresql.org; pgsql-sql@postgresql.org=0ASent: Monday, 20 April= , 2009 8:50:35 AM=0ASubject: [SQL] Re: [GENERAL] Frequently unable connecti= ng to db "server doesn't listen"=0A=0AOn Sun, Apr 19, 2009 at 8:10 PM, Net= Tree Inc. wrote:=0A>=0A> If this e-mail address is = not intend use for asking questions using e-mail=0A> suscription, please ig= nore it. I could not find any official PostgreSQL=0A> support forum for me= to post ask questions. Appreciated if you could you=0A> refer me a few goo= d PostgreSQL support forum for me to ask questions.=0A=0AThis is a mailing = list, so you're here! No need to look for web=0Aforums or anything.=0A=0A>= The problem I am having has happened a few times within in a week. I am=0A= > repeatly not able to connect to the db and having "server doesn't listen"= =0A> message without touch anything, it just happen. First time it happen a= fter I=0A> restarting my computer that has not been restart for almost a mo= nth. After=0A> restarting and trying to connect to DB and it failed, also I= notice my=0A> computer can not be restart nor shutdown under the normal wa= y by click on=0A> "start menu" and "shutdown or restart". I can only shut i= t down use the hard=0A> way by pressing the power button, I don't know why,= but its another story.=0A> Therefore for DB, I only can fix it by uninstal= l and reinstall PostgreSQL.=0A> But it happening repeatly.=0A>=0A> Any one = experience it? or to guide me to where I can find help?=0A=0ASeveral possib= ilities. What's your max_connections set to? What does=0Athe postgresql l= og have to say (if anything) about these failed=0Aconnections? How many po= stgres processes are running when this=0Ahappens? What OS is this on? Are = you using some kind of persistent=0Aphp client? Or some other kind of pool= ing client that might be using=0Aup all the connections?=0A=0AAny other inf= o you can give us will help.=0A=0A-- =0ASent via pgsql-sql mailing list (pg= sql-sql@postgresql.org)=0ATo make changes to your subscription:=0Ahttp://ww= w.postgresql.org/mailpref/pgsql-sql=0A=0A=0A=0A Now surf faster and sm= arter ! Check out the new Firefox 3 - Yahoo! Edition http://downloads.yahoo= .com/in/firefox/ --0-368019845-1240209072=:35846 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
I had a quite of similar problem earlier..it was with WAPPSTACK pac= kage that I had installed. Both the apache server and the postgresql stoppe= d working. So, I had to uninstall and install both of them . After a day or= two same thing happened. Then I scanned my PC using Avast Anti-Virus and t= here was a virus in my pc, so when i deleted all infected files with virus.= ..since then I never had such a problem.

So, my advice...do virus sc= an using avast and remove malwares using malwarebytes. This should solve yo= ur problem.

From: Scott Marlowe <scott.marlowe@gmail.com>
T= o: Net Tree Inc. <nettreeinc@gmail.com>
Cc: pgsql-general@postgresql.org; pgsql-= sql@postgresql.org
Sent: Monday, 20 April, 2009 8:50:35 AM

On Sun, Apr 19, 2009 at 8:10 PM, N= et Tree Inc. <nettreeinc@gmail.com> wrote:
>
> I= f this e-mail address is not intend use for asking questions using e-mail> suscription, please ignore it.  I could not find any official P= ostgreSQL
> support forum for me to post ask questions. Appreciated i= f you could you
> refer me a few good PostgreSQL support forum for me= to ask questions.

This is a mailing list, so you're here!  No nee= d to look for web
forums or anything.

> The problem I am havin= g has happened a few times within in a week. I am
> repeatly not able= to connect to the db and having "server doesn't listen"
> message wi= thout touch anything, it just happen. First time it happen after I
> = restarting my computer that has not been restart for almost a month. After<= br>> restarting and trying to connect to DB and it failed, also I notice= my
> computer can not be restart nor shutdown under the normal way b= y click on
> "start menu" and "shutdown or restart". I can only shut = it down use the hard
> way by pressing the power button, I don't know= why, but its another story.
> Therefore for DB, I only can fix it by= uninstall and reinstall PostgreSQL.
> But it happening repeatly.
= >
> Any one experience it? or to guide me to where I can find help?

Several possibilities.  What's your max_connections= set to?  What does
the postgresql log have to say (if anything) ab= out these failed
connections?  How many postgres processes are runn= ing when this
happens?  What OS is this on? Are you using some kind= of persistent
php client?  Or some other kind of pooling client th= at might be using
up all the connections?

Any other info you can = give us will help.

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:<= br>http://www.postgresql.org/mailpref/pgsql-sql
=0A
Get an email ID as yourname@ymail.com= or yourname@rocketmail.com. Click here. --0-368019845-1240209072=:35846--