Re: no sufficient privileges to start system service

Hi. i can't complete the installation process as i have persisting problem. it
gives me the following error message: Service pgsql 8.3 failed to start.
Verify that you have sufficient privileges to start system service. where's
the problem? can you help?

To strat the service on windows, the user (postgres, incase you didn't
change during installation) needs to be have administrative privilege and
service has to run as that user.

You can use Run as in windows to run the particular executable or change the
user in services.

From: pgsql-bugs-owner(at)postgresql(dot)org
[mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of Milen Lazarov
Sent: Saturday, May 05, 2012 12:41 AM
To: pgsql-bugs(at)postgresql(dot)org
Subject: [BUGS] no sufficient privileges to start system service

Hi. i can't complete the installation process as i have persisting problem.
it
gives me the following error message: Service pgsql 8.3 failed to start.
Verify that you have sufficient privileges to start system service. where's
the problem? can you help?

On 05/05/12 2:55 AM, Amit Kapila wrote:
>
> To strat the service on windows, the user (postgres, incase you didn’t
> change during installation) needs to be have administrative privilege
> and service has to run as that user.
>
> You can use Run as in windows to run the particular executable or
> change the user in services.
>

the SERVICE account ('postgres') needs only 'run as service' privileges.
the user doing the start/stop needs admin privs.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

On 05/05/12 12:14 PM, Milen Lazarov wrote:
> sorry, but i don't understand. i am just following the steps.
> what exactly should i do?

well, normally, the windows installer just works. since it didn't, the
process has to be troubleshooted, and you've not given us sufficient
information to hazard a wild guess as to why. you didn't even say what
OS you're running under (we had to guess it was some version of MS
Windows because you mentioned 'service'), or anything else.

anyways, this isn't a bug in postgres, so it really doesn't belong on
the [bugs] list, would better be discussed on pg-general.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

Can you try installing it on different windows machine.

This should not be a bug of postgres, some problem with the way you or doing or some env. Problem.

From: Milen Lazarov [mailto:milen_lazarov(at)yahoo(dot)com]
Sent: Saturday, May 05, 2012 11:30 PM
To: Amit Kapila
Subject: Re: [BUGS] no sufficient privileges to start system service

i am not a specialist and i am not sure i understand you. i have administrative rights.

i tried to download it manually. then the following message appeared: The application has failed to start because WSOK32.dll was not found. Re-installing the application may fix this problem.

then another message: Problem running post-install step. Installation may not complete correctly. Error reading file C:/Program Files/PostgreSQL/8.3/data/postgresql.conf

reinstallation does not help. i've done it several times

From: Amit Kapila <amit(dot)kapila(at)huawei(dot)com>
To: 'Milen Lazarov' <milen_lazarov(at)yahoo(dot)com>; pgsql-bugs(at)postgresql(dot)org
Sent: Saturday, May 5, 2012 12:55 PM
Subject: RE: [BUGS] no sufficient privileges to start system service

To strat the service on windows, the user (postgres, incase you didn’t change during installation) needs to be have administrative privilege and service has to run as that user.

You can use Run as in windows to run the particular executable or change the user in services.

From:Hi. i can't complete the installation process as i have persisting problem. it
gives me the following error message: Service pgsql 8.3 failed to start.
Verify that you have sufficient privileges to start system service. where's
the problem? can you help?