Thread: 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
>> 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.