Windows – PostgreSQL won’t start anymore

postgresqlsqlwindows

Today, my PostgreSQL doesn't start anymore on my windows machine…

I've tried to start the service in windows services and got the following error:

Windows could not start the PostgreSQL Database Server 8.3 service on Local Computer.

Error 1053: The service did not respond to the start or control request in a timely fashion.

Then I went to the command line to manually start C:/Program Files (x86)/PostgreSQL/8.3/bin/psql.exe, and then I got this error:

psql: Could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "???" and accepting TCP/IP connections on port 5432?

Edit:
I found this in the logs:

2011-04-22 13:13:16 CEST LOG:  could not receive data from client: No connection could be made because the target machine actively refused it.


2011-04-22 13:13:16 CEST LOG:  unexpected EOF on client connection

Best Answer

PostgreSQL is having an error on startup and to find out what it is you will have to start PostgreSQL manually. PostgreSQL does not log its startup failures as often as you would hope and how i find out what is going on is by starting a cmd.exe window under the postgres user and manually starting PostgreSQL.

Run this to start a CMD.exe under the postgres user

runas /user:postgres cmd.exe

Enter in the postgres password. And then in that new CMD window start PostgreSQL

"C:/Program Files (x86)/PostgreSQL/8.3/bin/postgres.exe" -D "C:/Program Files (x86)/PostgreSQL/8.3/data"

And let us know the output...

Related Topic