Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

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

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

    
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

1 Answer 1

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.

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.