I have postgres 8.3 installed on windows server 2003. The postgres service is not started after windows server restart. Its startup type is automatic.

I have to set log on password again in service properties and restart the service manually.

Does anyone has the same problem? How do you resolve this?

link|improve this question
Have a look in the PostgreSQL log to see if for some reason it does start but aborts. – Eelke Jun 11 '11 at 4:46
Also take a look at the event log. – Milen A. Radev Jun 11 '11 at 8:19
feedback

migrated from stackoverflow.com Jun 12 '11 at 19:52

This question came from our site for professional and enthusiast programmers.

1 Answer

Usually you have to run the postgres service with the user "postgres", which is usually set up when you install it. Try changing the service to run with account "postgres".

If you are already doing that, check the permissions of the postgres account.

link|improve this answer
It's running with postgres. What permissions are required? – crocpulsar Jun 11 '11 at 5:08
feedback

Your Answer

 
or
required, but never shown