Hi i cannot connect to postgres database, i get this error message
My PT3 has been working before, this just hapened, please help
I am runnning vista Ultimate with no firewall
Re: Cant login to my postgres database
Posted: Mon Mar 14, 2011 11:10 am
by kraada
Click Start, type services.msc and hit enter. In the window that appears, locate the PostgreSQL service and attempt to star tit. Does it start and remain started?
Re: Cant login to my postgres database
Posted: Mon Mar 14, 2011 11:39 am
by Horuspoker7
yes i have just tried that , it attempts to start but then fails. The services remains "STOPPED" in services.msc. I have also tried this many times, what could be wrong with the postgresSQL? I even uninstalled then reinstalled postgres 8.3 which is the version im running! Iget a popup box telling me the service postgres stopped automatically because no service was using it.
I also had a look at the pg_log file for errors and there is one below
2011-03-01 22:17:29 GMT LOG: database system was shut down at 2011-02-28 03:43:22 GMT 2011-03-01 22:17:29 GMT LOG: database system is ready to accept connections 2011-03-01 22:17:29 GMT LOG: autovacuum launcher started 2011-03-01 22:17:29 GMT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-03-01 22:17:30 GMT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-03-01 22:17:46 GMT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-03-01 22:17:47 GMT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-03-01 22:17:47 GMT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-03-01 22:17:47 GMT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-03-01 22:19:21 GMT LOG: loaded library "$libdir/plugins/plugin_debugger.dll" 2011-03-01 22:20:22 GMT LOG: could not receive data from client: Unknown winsock error 10061 2011-03-01 22:20:22 GMT LOG: unexpected EOF on client connection 2011-03-01 22:20:22 GMT LOG: could not receive data from client: Unknown winsock error 10061 2011-03-01 22:20:22 GMT LOG: unexpected EOF on client connection 2011-03-01 22:20:22 GMT LOG: could not receive data from client: Unknown winsock error 10061 2011-03-01 22:20:22 GMT LOG: unexpected EOF on client connection 2011-03-01 22:20:22 GMT LOG: could not receive data from client: Unknown winsock error 10061 2011-03-01 22:20:22 GMT LOG: unexpected EOF on client connection 2011-03-01 22:20:22 GMT LOG: could not receive data from client: Unknown winsock error 10061 2011-03-01 22:20:22 GMT LOG: unexpected EOF on client connection 2011-03-01 22:20:25 GMT LOG: received fast shutdown request 2011-03-01 22:20:25 GMT LOG: aborting any active transactions 2011-03-01 22:20:25 GMT LOG: autovacuum launcher shutting down 2011-03-01 22:20:28 GMT LOG: shutting down 2011-03-01 22:20:28 GMT LOG: database system is shut down
winsock error 10061
Re: Cant login to my postgres database
Posted: Mon Mar 14, 2011 12:18 pm
by Horuspoker7
I have one question, on the services .msc postgresSQL i double click get to the logon tab and what should that read? i will post a picture of what mine looks like
the first one does not work at all the second one the service postgres begins to start but then stops