Hi Greg: The installer in win32, create a user named "postgres", yes this user is not an administrator. And this is ok, security reasons. Alejandro Michelin Salomon Porto Alegre Brasil -->-----Mensagem original----- -->De: pgsql-general-owner@xxxxxxxxxxxxxx -->[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] Em nome de Greg -->Enviada em: terça-feira, 23 de maio de 2006 08:46 -->Para: pgsql-general@xxxxxxxxxxxxxx -->Assunto: Re: [GENERAL] Installing PostGreSQL automatically --> --> --> -->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 --> --> -->-- -->No virus found in this incoming message. -->Checked by AVG Free Edition. -->Version: 7.1.392 / Virus Database: 268.7.0/345 - Release -->Date: 22/5/2006 --> --> -->-- -->No virus found in this incoming message. -->Checked by AVG Free Edition. -->Version: 7.1.392 / Virus Database: 268.7.0/345 - Release -->Date: 22/5/2006 --> --> -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.7.0/345 - Release Date: 22/5/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.7.0/345 - Release Date: 22/5/2006
