Thread: Installing PostGreSQL automatically
Hi,
I am creating a Windows Application in .NET that will use PostGreSQL for the database.
I will be using Installshield to install to my application, and would like PgSQL to be installed in the background.
What files/registry entries do I need to make to have this done?
Thanks
Greg
Greg, http://pginstaller.projects.postgresql.org/silent.html read on there. best wishes, Harald On 5/22/06, Greg <greg@officium.co.za> wrote: > > > > > Hi, > > > > I am creating a Windows Application in .NET that will use PostGreSQL for the > database. > I will be using Installshield to install to my application, and would like > PgSQL to be installed in the background. > > > > What files/registry entries do I need to make to have this done? > > > > Thanks > > Greg > > -- 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
After trying this, it is close, but not really what I want. I would prefer to bundle the selected files in my Installshield installer, and write the necessary registry entries. Could somebody please tell me which files, and which registry entries I need to have PostGreSQL installed? -----Original Message----- From: Harald Armin Massa [mailto:haraldarminmassa@gmail.com] Sent: 22 May 2006 04:51 PM To: Greg Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Installing PostGreSQL automatically Greg, http://pginstaller.projects.postgresql.org/silent.html read on there. best wishes, Harald On 5/22/06, Greg <greg@officium.co.za> wrote: > > > > > Hi, > > > > I am creating a Windows Application in .NET that will use PostGreSQL for the > database. > I will be using Installshield to install to my application, and would like > PgSQL to be installed in the background. > > > > What files/registry entries do I need to make to have this done? > > > > Thanks > > Greg > > -- 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
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
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
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@officium.co.za> 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@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 > -- 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
> -----Original Message----- > From: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Greg > Sent: 23 May 2006 12:46 > To: pgsql-general@postgresql.org > Subject: 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? It creates one for you, normally called postgres. See http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pginstaller/pginst/ca/user.c ?rev=1.19&content-type=text/x-cvsweb-markup Regards, Dave.
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
Hi Harald, I have tried to install the database silently, according to that document you gave me http://pginstaller.projects.postgresql.org/silent.html but the documentation seems to be out of date... As the document specifies... Normal none Normal interactive user installation Reduced /qr No user interaction. "Full size" progress window including progress descriptions. Basic /qb No user interaction. Just a basic progressbar and not full descriptions. Silent /qn No user information at all. Yet, these switches don't do what they say. /qr - still requires user interaction /qb - shows no progress bar, in fact it shows nothing. My hard drive light flashes, but when finished, nothing is installed and the BASEDIR is still empty! Please help. -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Harald Armin Massa 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 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
> Normal none Normal interactive user installation > Reduced /qr No user interaction. "Full size" progress window including > progress descriptions. > Basic /qb No user interaction. Just a basic progressbar and not full > descriptions. > Silent /qn No user information at all. > > > Yet, these switches don't do what they say. AFAIK, they do :P What exact commandline are you using? > /qr - still requires user interaction In what form? Meaning what are you prompted for? > /qb - shows no progress bar, in fact it shows nothing. My > hard drive light > flashes, but when finished, nothing is installed and the > BASEDIR is still > empty! Weird. One guess could be you're running against postgresql-8.1.msi and not postgresql-8.1-int.msi, could that be it? //Magnus
Greg, did you try to start the installer like postgresql814.msi /qb ..... ??? That is rather doomed to failure. You should try the msiexec <whatever parms> If you call msiexec without parms, it will give you a online help with all the parms. Thoes /q<whatever> are from Microsoft, not from Magnus :) best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 - on different matter: did you ever dream of visiting CERN? The place where the antimatter for exploding Vatican is created? To eat in cantinas with the worlds highest propability to stand in queue with future or past Nobel Prize Winners? To talk about Web 2.5 at the place where Web 0.1 up to Web 1.0 were developed? register at www.europython.org!
> tried calling the '-int' MSI but I get an error telling me > "The installer has encountered an unexpected error installing > this package. This may indicate a problem with the package. > The error code is 2711." > > This is my command line > > msiexec /i postgresql-8.1.msi /qr INTERNALLAUNCH=1 > ADDLOCAL=server,psql,docs SERVICEDOMAIN="%COMPUTERNAME%" > SERVICEPASSWORD="SecretWindowsPassword123" > SUPERPASSWORD="VerySecret" BASEDIR="c:\postgres" You definitly should be using -int. You'll need to figure out what the 2711 indicates, that's an actual problem. Try enabling logging and see if that helps you (with the -int), by appending something like /log install.log And it should tell you waht is wrong. //MAgnus
Thanks, I got it working, in the log, it told me the 'docs' module could not
be found, so I removed it.
But now, further, in the installation, it tells me, invalid username
specified, Logon failure - unknown username or password.
Now my question, this installer will need to be installed on numerous
machines. So what do I put for the username and password values in the
command prompt?
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Magnus Hagander
Sent: 05 June 2006 03:30 PM
To: Greg; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Installing PostGreSQL automatically
> tried calling the '-int' MSI but I get an error telling me "The
> installer has encountered an unexpected error installing this package.
> This may indicate a problem with the package.
> The error code is 2711."
>
> This is my command line
>
> msiexec /i postgresql-8.1.msi /qr INTERNALLAUNCH=1
> ADDLOCAL=server,psql,docs SERVICEDOMAIN="%COMPUTERNAME%"
> SERVICEPASSWORD="SecretWindowsPassword123"
> SUPERPASSWORD="VerySecret" BASEDIR="c:\postgres"
You definitly should be using -int. You'll need to figure out what the
2711 indicates, that's an actual problem.
Try enabling logging and see if that helps you (with the -int), by appending
something like
/log install.log
And it should tell you waht is wrong.
//MAgnus
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly