pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Frequently unable connecting to db "server doesn't listen" 4+ messages / 4 participants [nested] [flat]
* Frequently unable connecting to db "server doesn't listen" @ 2009-04-20 02:10 Net Tree Inc. <nettreeinc@gmail.com> 2009-04-20 03:20 ` Re: Frequently unable connecting to db "server doesn't listen" Scott Marlowe <scott.marlowe@gmail.com> 2009-04-20 08:53 ` Re: Frequently unable connecting to db "server doesn't listen" Alban Hertroys <dalroi@solfertje.student.utwente.nl> 0 siblings, 2 replies; 4+ messages in thread From: Net Tree Inc. @ 2009-04-20 02:10 UTC (permalink / raw) To: pgsql-general@postgresql.org; pgsql-sql If this e-mail address is not intend use for asking questions using e-mail suscription, please ignore it. I could not find any official PostgreSQL support forum for me to post ask questions. Appreciated if you could you refer me a few good PostgreSQL support forum for me to ask questions. Problem: The problem I am having 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 without touch anything, it just happen. First time it happen after I restarting my computer that has not been restart for almost a month. After 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 by 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? ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Frequently unable connecting to db "server doesn't listen" 2009-04-20 02:10 Frequently unable connecting to db "server doesn't listen" Net Tree Inc. <nettreeinc@gmail.com> @ 2009-04-20 03:20 ` Scott Marlowe <scott.marlowe@gmail.com> 1 sibling, 0 replies; 4+ messages in thread From: Scott Marlowe @ 2009-04-20 03:20 UTC (permalink / raw) To: Net Tree Inc. <nettreeinc@gmail.com>; +Cc: pgsql-general@postgresql.org; pgsql-sql On Sun, Apr 19, 2009 at 8:10 PM, Net Tree Inc. <nettreeinc@gmail.com> wrote: > > If this e-mail address is not intend use for asking questions using e-mail > suscription, please ignore it. I could not find any official PostgreSQL > support forum for me to post ask questions. Appreciated if 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 need to look for web forums or anything. > The problem I am having 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 without touch anything, it just happen. First time it happen after I > restarting my computer that has not been restart for almost a month. After > 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 by 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) about these failed connections? How many postgres processes are running when this happens? What OS is this on? Are you using some kind of persistent php client? Or some other kind of pooling client that might be using up all the connections? Any other info you can give us will help. ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Frequently unable connecting to db "server doesn't listen" 2009-04-20 02:10 Frequently unable connecting to db "server doesn't listen" Net Tree Inc. <nettreeinc@gmail.com> @ 2009-04-20 08:53 ` Alban Hertroys <dalroi@solfertje.student.utwente.nl> 1 sibling, 0 replies; 4+ messages in thread From: Alban Hertroys @ 2009-04-20 08:53 UTC (permalink / raw) To: Net Tree Inc. <nettreeinc@gmail.com>; +Cc: pgsql-general@postgresql.org; pgsql-sql On Apr 20, 2009, at 4:10 AM, Net Tree Inc. wrote: > The problem I am having 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 without touch anything, it just happen. First time > it happen after I restarting my computer that has not been restart > for almost a month. After 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 by 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. That's probably a (maybe _the_) cause of your troubles. After the DB was shut down the hard way it will probably be in recovery mode the next time you start it. You can't connect to the DB while it's in recovery mode. I think the first thing you need to focus on is to find out why you can't shut down your system normally. If you can't find a solution for that, at least stop the PostgreSQL service (I'm guessing the name, I don't have PG on my game box) before you press the power button. > Therefore for DB, I only can fix it by uninstall and reinstall > PostgreSQL. But it happening repeatly. Reinstalling shouldn't be necessary, it's probably enough to wait until recovery is complete. The logs can tell you what's going on. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:737,49ec3820129741572128411! ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Re: [GENERAL] Frequently unable connecting to db "server doesn't listen" @ 2009-04-20 06:31 Rohit Suman <handsome_94@yahoo.com> 0 siblings, 0 replies; 4+ messages in thread From: Rohit Suman @ 2009-04-20 06:31 UTC (permalink / raw) To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: nettreeinc@gmail.com; pgsql-sql I had a quite of similar problem earlier..it was with WAPPSTACK package that I had installed. Both the apache server and the postgresql stopped 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 there 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 scan using avast and remove malwares using malwarebytes. This should solve your problem. ________________________________ From: Scott Marlowe <scott.marlowe@gmail.com> To: Net Tree Inc. <nettreeinc@gmail.com> Cc: pgsql-general@postgresql.org; pgsql-sql@postgresql.org Sent: Monday, 20 April, 2009 8:50:35 AM Subject: [SQL] Re: [GENERAL] Frequently unable connecting to db "server doesn't listen" On Sun, Apr 19, 2009 at 8:10 PM, Net Tree Inc. <nettreeinc@gmail.com> wrote: > > If this e-mail address is not intend use for asking questions using e-mail > suscription, please ignore it. I could not find any official PostgreSQL > support forum for me to post ask questions. Appreciated if 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 need to look for web forums or anything. > The problem I am having 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 without touch anything, it just happen. First time it happen after I > restarting my computer that has not been restart for almost a month. After > 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 by 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) about these failed connections? How many postgres processes are running when this happens? What OS is this on? Are you using some kind of persistent php client? Or some other kind of pooling client that 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: http://www.postgresql.org/mailpref/pgsql-sql Now surf faster and smarter ! Check out the new Firefox 3 - Yahoo! Edition http://downloads.yahoo.com/in/firefox/ ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2009-04-20 08:53 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2009-04-20 02:10 Frequently unable connecting to db "server doesn't listen" Net Tree Inc. <nettreeinc@gmail.com> 2009-04-20 03:20 ` Scott Marlowe <scott.marlowe@gmail.com> 2009-04-20 08:53 ` Alban Hertroys <dalroi@solfertje.student.utwente.nl> 2009-04-20 06:31 Re: Re: [GENERAL] Frequently unable connecting to db "server doesn't listen" Rohit Suman <handsome_94@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox