Silent start of Postgres in XP
I need to start Postgres 8.1 database in XP without any user intervention
even when Postgres is not installed.
I have implemented this for Apache2 by running the following commands:
Apache.exe -k stop
Apache.exe -k uninstall
Apache.exe -k install
Apache.exe -k start
@rem if user has no privileges to install service, start Apache as
application:
Apache.exe
This causes Apache to run under SYSTEM account .
Trying to use same approach with Postgres fails. Postgres requires special
user account and is not capable to create this account without user
intervention.
How to force Postgres to install itself as service running under SYSTEM or
under LOCAL SERVICE account?
Andrus.
Andrus wrote:
How to force Postgres to install itself as service running under SYSTEM or
under LOCAL SERVICE account?
You can download the source, take out the check for non-administrator
accounts and recompile.
The core developers have made it pretty clear that they don't hold with
running a network-accessible service as an administrator. For my money,
I think they're probably right.
--
Richard Huxton
Archonet Ltd
This causes Apache to run under SYSTEM account .
Trying to use same approach with Postgres fails. Postgres
requires special user account and is not capable to create
this account without user intervention.
Sure, it's very much capable of diong that. See
http://pginstaller.projects.postgresql.org/silent.html, specifically
look for SERVICEACCOUNT, SERVICEPASSWORD and CREATESERVICEUSER.
How to force Postgres to install itself as service running
under SYSTEM or under LOCAL SERVICE account?
Can't do that with stock postgresql, you'll need to hack up your own
version.
//Magnus
Import Notes
Resolved by subject fallback
Trying to use same approach with Postgres fails. Postgres
requires special user account and is not capable to create
this account without user intervention.Sure, it's very much capable of diong that. See
http://pginstaller.projects.postgresql.org/silent.html, specifically
look for SERVICEACCOUNT, SERVICEPASSWORD and CREATESERVICEUSER.
Is there some executable file which I can call with -install switch and
which creates account without running installer ?
How to force Postgres to install itself as service running
under SYSTEM or under LOCAL SERVICE account?Can't do that with stock postgresql, you'll need to hack up your own
version.
How to add some command-line switch to this, like
-installusingsystemaccount
Andrus.