Обсуждение: Please help! Postgres stopped working after restarting computer!

Here is the general info:

Bug reference:      4172
Logged by:          alex
Email address:      shaselai@yahoo.com
PostgreSQL version: 8.3.1
Operating system:   windows xp
Description:        postgres stops working after
restart
Details: 

I installed 8.3.1 fine and the service starts and
works fine. However,after
I restart the computer and opens up pgAdmin3.exe and
try to start the
service again i get error message:
"Failed to start server pgsql-8.3:Errcode=1069. Check
event log for
details."

The log folder doesn't show any error problems. When I
run the psql.exeon
the command line i get:
"psql: could not connect to server: Connection refused(0x0000274D/10061)       Is the server running on host "???" and
accepting       TCP/IP connections on port 5432? "
I checked using netstat -an and 5432 is not even
listed being in
use/listening. I also tried changing the port in
pgadmin to somethingelse
like 5050  but same error.

Right now the only "fix" i can come up with is to
uninstall andreinstall...


is there a fix to this problem? thanks!

     

Wei,

> PostgreSQL version: 8.3.1
> Operating system:   windows xp
> Description:        postgres stops working after
> restart
> Details:
> I installed 8.3.1 fine and the service starts and
> works fine. However, after I restart the computer and opens up pgAdmin3.exe and

> "Failed to start server pgsql-8.3:Errcode=1069. Check
> event log for
> details."

So, propably you have installed PostgreSQL as a service (= standard on Windows )

Please digg out the eventlog of Windows (eventvwr is the programm) and
look into the application log.

To see what failed, also open services.msc and try to start pgsql-8.3
manually. After failure, recheck application error log with eventvwr
(do not forget to refresh)

> The log folder doesn't show any error problems. When I
What is EXACTLY created within data\pg_log?

is there a new logfile with a name/timestamp indicating it was created
"just at last system start" ? what is in that logfile?

Best wishes,

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!