Just a simple "logon as service" User with no administrative privileges, in no administrator group or similiar whatsoever. BTW... that "logon as service" is one of the challenging parts; be carefull with Group Policies. Harald On 5/23/06, Greg <greg@xxxxxxxxxxxxxx> wrote:
Ok, I have installed PostGreSQL as a service with pg_ctl. But when I try to start the service using pg_ctl start, I am told I have to run the service under a non-administrator account. Which account is used/created by the standard PostGreSQL MSI installer? -----Original Message----- From: Harald Armin Massa [mailto:haraldarminmassa@xxxxxxxxx] Sent: 23 May 2006 08:43 AM To: Greg Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: [GENERAL] Installing PostGreSQL automatically Greg, all the registry-entries are for "convenience", that is: to make it possible for the installer to check if PostgreSQL is installed. So to use PostgreSQL on Win32, simple distribute the files found within <programs>PostgreSQL/8.1/ from a normal installation. ["normal" is quite a challenge nontheless, as "normally" client & server libs are distributed; together with PG-Admin in default installation] Your challenge in not using the installer remains: a) arranging the path correctly so that all libs are found b) creating a user with appropriate privilges [in corporate environments that is often better done by whatever user administration tool they use] c) creating the service [check pg_ctl --help] d) initialising the datadir (initdb --help) I tried to went down that road because of problems with earlier pg-installers (8.0.0 beta and before); and it was harder than it sounds, so I moved back to the installer. I recommend to you to do the same - or report back your sucess. On http://pgfoundry.org/projects/pginstaller/ you can find the source to the installer; to recheck what exactly that MSI is doing; maybe Installshield is even able to "include" the MSI definitions from there (they are made for the "free" tools from MS to build installers) Best wishes Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - PostgreSQL - supported by a community that does not put you on hold ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
-- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - PostgreSQL - supported by a community that does not put you on hold
