Re: Re: Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account

From: Krystian Bigaj <krystian(dot)bigaj(at)gmail(dot)com>
To: boca2608 <boca2608(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re: Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account
Date: 2014-06-12 14:54:45
Message-ID: CAN=kAeGojEjRFUgdjY6fhhWhA2y9tGvwE7y7QyAvqEMs3qLKCw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

(re-posting, because I've used Reply, instead of Reply all, thanks)

On 11 June 2014 18:05, boca2608 <boca2608(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message boca2608 2014-06-12 15:04:58 Re: Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account
Previous Message Krystian Bigaj 2014-06-12 14:41:57 Re: Re: Cannot start Postgresql 9.3 as a service in Windows 2012 Server with a domain account