Re: starting postgres on windows - Mailing list pgsql-general

From Harald Armin Massa
Subject Re: starting postgres on windows
Date
Msg-id 7be3f35d0611270038t480cfd08v2a465db1196d6468@mail.gmail.com
Whole thread Raw
In response to starting postgres on windows  (garry saddington <garry@schoolteachers.co.uk>)
List pgsql-general
Garry,

the standard recommendation is to install PostgreSQL as a service on windows; logging in with an own low privilege user account, usually named "postgres".

That usage of a service is recommended because it solves all the usual problems of services :) (start, shut down, login as seperate user ....)

However: I guess you have an privileged user (=Member of Administrators), and want to start PostgreSQL as an unprivileged user. So just create a command shell as that user:

runas /user:postgres cmd

and start and stop PostgreSQL within that shell. (in the long run, you can change that line to immediately start PostgreSQL instead of going via cmd)

For 8.2 there is scheduled a "drop privilege" method of startup on windows, so that starting PostgreSQL as Administrator is no longer a problem, since PostgreSQL will drop it privileges immediately after start.


hth

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Development of cross-platform GUI for Open Source DBs
Next
From: "Harald Armin Massa"
Date:
Subject: Re: Development of cross-platform GUI for Open Source DBs