From: | "Alejandro Michelin Salomon \( Adinet \)" <alejmsg(at)adinet(dot)com(dot)uy> |
---|---|
To: | "'Greg'" <greg(at)officium(dot)co(dot)za> |
Cc: | "Pgsql-General" <pgsql-general(at)postgresql(dot)org> |
Subject: | RES: Installing PostGreSQL automatically |
Date: | 2006-05-23 12:03:36 |
Message-ID: | !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAhx491Ki2tUS42D/aMPFg1MKAAAAQAAAAqoKlwcbYDUCgeGplT4fCngEAAAAA@adinet.com.uy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)postgresql(dot)org
-->[mailto:pgsql-general-owner(at)postgresql(dot)org] Em nome de Greg
-->Enviada em: terça-feira, 23 de maio de 2006 08:46
-->Para: pgsql-general(at)postgresql(dot)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(at)gmail(dot)com]
-->Sent: 23 May 2006 08:43 AM
-->To: Greg
-->Cc: pgsql-general(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2006-05-23 12:15:08 | Re: [SQL] some error when executing query in pgAdmin tool |
Previous Message | Kenneth Downs | 2006-05-23 11:57:40 | Re: More confirmation: pgadmin3 freezeup fixed by wxgtk |