Thread: 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!
Re: Please help! Postgres stopped working after restarting computer!
From
"Harald Armin Massa"
Date:
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!