Re: Frequently unable connecting to db "server doesn't listen" - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Frequently unable connecting to db "server doesn't listen"
Date
Msg-id 070182D4-A909-44FA-8861-51220E6D25AD@solfertje.student.utwente.nl
Whole thread Raw
In response to Frequently unable connecting to db "server doesn't listen"  ("Net Tree Inc." <nettreeinc@gmail.com>)
List pgsql-general
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!



pgsql-general by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Nooby Q: Should this take five hours? And counting?
Next
From: John DeSoi
Date:
Subject: converting from bytea to integers