Cannot connect to Postgre SQL
Posted:
Tue Feb 04, 2014 1:09 pm
by Msrmek
Unable to login to database (postgres). Reason: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "???"
and accepting TCP/IP connections on port 5432
That's what I get. I tried booting computer and internet and still doesn't work.
Re: Cannot connect to Postgre SQL
Posted:
Tue Feb 04, 2014 1:28 pm
by kraada
Click Start type services.msc and click on it when it appears. Do you see PostgreSQL in the list? If so, can you start it?
Re: Cannot connect to Postgre SQL
Posted:
Tue Feb 04, 2014 2:09 pm
by Msrmek
http://gyazo.com/6177fb9481c0c294e8997396626433e4It shows "hidden" like that and cannot be proceeded, käynnistä means start.
Edit: Got it to start, will see what happens soon, it's loading but very slowly.
This is what popped up:
http://gyazo.com/f0fe17594e15d435e8a115bc2894011cIt means PostgreSQL cannot be started. Error 1053: Application didn't answer in time for start-up or control request.
Re: Cannot connect to Postgre SQL
Posted:
Tue Feb 04, 2014 3:16 pm
by kraada
Click Start, type Event Viewer and click on it when it appears. Expand Applications and look for errors in the center pane relating to PostgreSQL. What do those errors say?
Re: Cannot connect to Postgre SQL
Posted:
Tue Feb 04, 2014 4:32 pm
by Msrmek
I found something like this from yesterday when I shut down my PC and postgreSQL havent work since:
http://gyazo.com/2949e1e2019d601499712eb76448ccbfhttp://gyazo.com/d34b2e518312e93a72964015b8cda834Edit: It was funny when I was opening PostgreSQL manually, it opened well until halfway through and then went ultra slow and eventually caused the delay error.
Re: Cannot connect to Postgre SQL
Posted:
Tue Feb 04, 2014 5:18 pm
by kraada
Locate and delete the postmaster.pid file and then the server should start normally.