RES: Installing PostGreSQL automatically

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@postgresql.org
-->[mailto:pgsql-general-owner@postgresql.org] Em nome de Greg
-->Enviada em: terça-feira, 23 de maio de 2006 08:46
-->Para: pgsql-general@postgresql.org
-->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@gmail.com]
-->Sent: 23 May 2006 08:43 AM
-->To: Greg
-->Cc: pgsql-general@postgresql.org
-->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