Re: Re: Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account - Mailing list pgsql-general

From Krystian Bigaj
Subject Re: Re: Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account
Date
Msg-id CAN=kAeGojEjRFUgdjY6fhhWhA2y9tGvwE7y7QyAvqEMs3qLKCw@mail.gmail.com
Whole thread Raw
In response to Re: Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account  (boca2608 <boca2608@gmail.com>)
List pgsql-general
(re-posting, because I've used Reply, instead of Reply all, thanks)

On 11 June 2014 18:05, boca2608 <boca2608@gmail.com> wrote:

When trying to start postgresql as a service with a domain account on a windows 2012 server, the service starts and stops immediately. The Windows event log showed a terse error about timeout (even though it did not really take more than a couple of seconds for it to fail). By the way, the server is in an internal data center and does not have open access to public Internet.


If you don't have (error) logs from PG then you could try to use Process Monitor, set filter for postgres.exe process, and start service. Look for errors in Result with eg. ACCESS_DENIED.
I've had some clients that had few different issues, and all of them was because of permissions issues (sometimes postgres.exe fails, sometimes initdb.exe fails). Setting correct permissions solved all of that problems.

PS. I'm running PG under NetworkService account, but I'm not using installer from EDB or even pg_ctl (shutdown code is buggy, but it's a postgres.exe issue).

Best regards,
Krystian Bigaj

pgsql-general by date:

Previous
From: Krystian Bigaj
Date:
Subject: Re: Re: Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account
Next
From: boca2608
Date:
Subject: Re: Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account