Page 1 of 1

Cant login to my postgres database

PostPosted: Mon Mar 14, 2011 10:58 am
by Horuspoker7
Hi i cannot connect to postgres database, i get this error message

Image

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

PostPosted: 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

PostPosted: 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

PostPosted: 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

Image Image

the first one does not work at all the second one the service postgres begins to start but then stops

Re: Cant login to my postgres database

PostPosted: Mon Mar 14, 2011 12:34 pm
by kraada
Follow this tutorial then this tutorial and reboot your computer and that should fix it.

highfalutin