Thread: no sufficient privileges to start system service

no sufficient privileges to start system service

From
Milen Lazarov
Date:
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?

Re: no sufficient privileges to start system service

From
Amit Kapila
Date:
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@postgresql.org
[mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of Milen Lazarov
Sent: Saturday, May 05, 2012 12:41 AM
To: pgsql-bugs@postgresql.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?

Re: no sufficient privileges to start system service

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

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



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

Re: no sufficient privileges to start system service

From
John R Pierce
Date:
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

Re: no sufficient privileges to start system service

From
Amit Kapila
Date:
Can you try installing it on different windows machine.

=20

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

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

=20

i am not a specialist and i am not sure i understand you. i have administra=
tive rights.

=20

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

then another message: Problem running post-install step. Installation may n=
ot complete correctly. Error reading file C:/Program Files/PostgreSQL/8.3/d=
ata/postgresql.conf

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

=20

From: Amit Kapila <amit.kapila@huawei.com>
To: 'Milen Lazarov' <milen_lazarov@yahoo.com>; pgsql-bugs@postgresql.org=20
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=E2=80=
=99t 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 th=
e user in services.

=20

From:Hi. i can't complete the installation process as i have persisting pro=
blem. 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?

=20