Cant login to my postgres database

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Cant login to my postgres database

Postby Horuspoker7 » Mon Mar 14, 2011 10:58 am

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
Horuspoker7
 
Posts: 4
Joined: Wed Jun 16, 2010 3:08 pm

Re: Cant login to my postgres database

Postby kraada » Mon Mar 14, 2011 11:10 am

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?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Cant login to my postgres database

Postby Horuspoker7 » Mon Mar 14, 2011 11:39 am

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
Horuspoker7
 
Posts: 4
Joined: Wed Jun 16, 2010 3:08 pm

Re: Cant login to my postgres database

Postby Horuspoker7 » Mon Mar 14, 2011 12:18 pm

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
Horuspoker7
 
Posts: 4
Joined: Wed Jun 16, 2010 3:08 pm

Re: Cant login to my postgres database

Postby kraada » Mon Mar 14, 2011 12:34 pm

Follow this tutorial then this tutorial and reboot your computer and that should fix it.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 29 guests

cron