Thread: Silent start of Postgres in XP

Silent start of Postgres in XP

From
"Andrus"
Date:
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.



Re: Silent start of Postgres in XP

From
Richard Huxton
Date:
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

Re: Silent start of Postgres in XP

From
"Magnus Hagander"
Date:
> 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

Re: Silent start of Postgres in XP

From
"Andrus"
Date:
>> 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.