I thought I sent off an email about how to do it, OK here goes:
Create a working minimal cygwin with postgres install.
Delete unwanted utilities and files.
Test if you can start, stop, initdb, and query Postgres.
Use the attached pgsql.iss script to make the install.
Notes:
My version of the console program may be different than what is up on
winmaster. I sent all my changes to Igor, but I have never been able to
compile what he sends back. I'm not sure what compiler he is using, I am
building mine with gcc and MSVC.
The registry entries are very important, make sure you don't mess with
them too much.
You asked how I managed the "run as service" issue. I handled it by
ignoring it. I do not setup the run as service option because, IMHO, it
is too hard to ensure that the setup works without any problems. I
modified the console program to take care of the issues of running
PostgreSQL under cygwin, including cygipc. If I were to add "run as a
service" I would write a service program that wrapped the cygwin and
cygipc details in much the same way as the console program does.
Further thoughts about "run as service." My install is aimed at Windows
power users, not back office guys. PostgreSQL with cygwin is not ready
for the back office, the biggest problems are the limit of concurrent
connections and performance. I don't trust cygwin as a reliable service,
so adding the option "run as a service" may just encourage them to do
so. I think that would do more harm than not having the option. When
PostgreSQL has a native Windows version, I'll add it. Until then, I
think of it more as a "desktop" version for small offices and
developers. The "server" version currently only runs on UNIX
Justin Clift wrote:
> mlw wrote:
>
>> Sorry, I think there was a misunderstanding. What were you looking for?
>
>
> Sorry Mark, I just thought you were busy.
>
> Was wondering if you were going to make a project of it somewhere, so
> we can get things together and have a really decent release for
> Windows when 7.4 comes out. :)
>
>> I used inno setup as well. If you want I can send my install script.
>
>
> That would be really cool. :)
>
> How did you handle the user and "Log on as a service" aspects of it?
>
> :)
>
>> I thought I was being very forth coming.
>
>
> Yep, you 100% have a really good attitude, that's why I thought you
> were busy.
>
> :)
>
>> I even help out on the Windows PG console window.
>
>
> Took a look at it, and the three buttons seem permanently greyed out
> in the download from the WinMaster project. Wasn't sure if it was a
> configuration issue on my part, or if the code hadn't been fleshed out
> yet.
>
> Interested in making a project on GBorg or something for the "complete
> Windows installer" as a place to work out of?
>
> :-)
>
> Regards and best wishes,
>
> Justin Clift
>
>
; PostgreSQL for Windows by Mohawk Software
; Copyright (C) 2002-2003 Mark L. Woodward
;
; This file is free software; you can redistribute it and/or
; modify it under the terms of the GNU General Public
; License as published by the Free Software Foundation; either
; version 2 of the License, or (at your option) any later version.
;
; This file is distributed in the hope that it will be useful,
; but WITHOUT ANY WARRANTY; without even the implied warranty of
; MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
; Library General Public License for more details.
;
; You should have received a copy of the GNU General Public
; License along with this file; if not, write to the Free
; Software Foundation, Inc., 59 Temple Place - Suite 330, Boston,
; MA 02111-1307, USA
;
; If you want support or to commercially license this file, the author
; can be reached at sales@mohawksoft.com
[Setup]
AppName=PostgreSQL
AppVerName=PostgreSQL 7.3 for Windows
AppPublisher=Mohawk Software
AppPublisherURL=http://www.mohawksoft.com
AppSupportURL=http://www.mohawksoft.com
AppUpdatesURL=http://www.mohawksoft.com
DefaultDirName={sd}\PostgreSQL
DisableStartupPrompt=yes
DefaultGroupName=PostgreSQL
AllowNoIcons=yes
SourceDir=e:\pginstall\source
OutputBaseFilename=pgsetup
OutputDir=e:\pginstall\PostgreSQL
[Registry]
Root: HKLM; Subkey: "SOFTWARE\Cygnus Solutions"; Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "SOFTWARE\Cygnus Solutions\Cygwin"; Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "SOFTWARE\Cygnus Solutions\Cygwin\mounts v2"; Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "SOFTWARE\Cygnus Solutions\Cygwin\mounts v2"; ValueType: String; ValueName: "cygdrive prefix";
ValueData:"/disks"; Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "SOFTWARE\Cygnus Solutions\Cygwin\mounts v2"; ValueType: dword; ValueName: "cygdrive flags";
ValueData:"34"; Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/"; ValueType: String; ValueName: "native"; ValueData:
"{app}";Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/"; ValueType: dword; ValueName: "flags"; ValueData:
"$0A";Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/bin"; ValueType: String; ValueName: "native";
ValueData:"{app}/bin"; Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/bin"; ValueType: dword; ValueName: "flags";
ValueData:"$0A"; Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/lib"; ValueType: String; ValueName: "native";
ValueData:"{app}/lib"; Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/lib"; ValueType: dword; ValueName: "flags";
ValueData:"$0A"; Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/X11R6/lib/X11/fonts"; ValueType: String;
ValueName:"native"; ValueData: "{app}\\usr\\X11R6\\lib\\X11\\fonts"; Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "SOFTWARE\Cygnus Solutions\Cygwin\mounts v2\/usr/X11R6/lib/X11/fonts"; ValueType: dword; ValueName:
"flags";ValueData: "$0A"; Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "SOFTWARE\Cygnus Solutions\Cygwin\Program Options"; Flags: uninsdeletekeyifempty
; Registry entries for PostgreSQL Server Console
Root: HKLM; Subkey: "Software\CygConsole"; Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\PostgreSQL"; Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\PostgreSQL"; ValueType: String; ValueName: "command"; ValueData:
"{app}/bin/bash--login -c ""postmaster -D /data"" "; Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\PostgreSQL"; ValueType: String; ValueName: "prerun"; ValueData:
"{app}/bin/ipc-daemon.exe";Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\PostgreSQL"; ValueType: String; ValueName: "kill"; ValueData:
"{app}/bin/kill.exe";Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\PostgreSQL"; ValueType: String; ValueName: "pidfile"; ValueData:
"{app}/data/postmaster.pid";Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\PostgreSQL"; ValueType: String; ValueName: "bindir"; ValueData: "{app}/bin";
Flags:uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\PostgreSQL"; ValueType: String; ValueName: "logfile"; ValueData:
"{app}\postgresql.log";Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\PostgreSQL"; ValueType: String; ValueName: "logout"; ValueData: "TRUE"; Flags:
uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\PostgreSQL"; ValueType: String; ValueName: "title"; ValueData: "PostgreSQL
Server";Flags: uninsdeletekeyifempty
; Registry entries for pgsetup
Root: HKLM; Subkey: "Software\CygConsole\pgsetup"; ValueType: String; ValueName: "command"; ValueData: "{app}/bin/bash
--login-c ""pgsetup.sh {username}"" "; Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\pgsetup"; ValueType: String; ValueName: "prerun"; ValueData:
"{app}/bin/ipc-daemon.exe";Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\pgsetup"; ValueType: String; ValueName: "kill"; ValueData: ""; Flags:
uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\pgsetup"; ValueType: String; ValueName: "pidfile"; ValueData: ""; Flags:
uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\pgsetup"; ValueType: String; ValueName: "bindir"; ValueData: "{app}/bin";
Flags:uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\pgsetup"; ValueType: String; ValueName: "title"; ValueData: "Creating Database
Environment";Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\pgsetup"; ValueType: String; ValueName: "stopquit"; ValueData: "TRUE"; Flags:
uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\pgsetup"; ValueType: String; ValueName: "shutdown"; ValueData: "PostgreSQL
Shutdown";Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\pgsetup"; ValueType: String; ValueName: "logfile"; ValueData:
"{app}\setup.log";Flags: uninsdeletekeyifempty
Root: HKLM; Subkey: "Software\CygConsole\pgsetup"; ValueType: String; ValueName: "logout"; ValueData: "TRUE"; Flags:
uninsdeletekeyifempty
[Components]
Name: pgsql; Description: "Install PostgreSQL Database Environment"; types: full compact custom;
ExtraDiskSpaceRequired:32657356
Name: initdb; Description: "Create initial database (This is required to use PostgreSQL)"; types: full compact custom
;ExtraDiskSpaceRequired: 24478715;
Name: unix; Description: "Text Console Administration Tools (For Power Users)"; ExtraDiskSpaceRequired: 1024; types:
fullcompact;
[Tasks]
Name: lowperf; Description: "Light performance (Uses less memory)"; GroupDescription: "Performance"; Components: pgsql;
Flags:exclusive unchecked ;
Name: userperf; Description: "Standard performance"; GroupDescription: "Performance"; Flags: exclusive ; Components:
pgsql
Name: highperf; Description: "High performance (Uses more memory)"; GroupDescription: "Performance"; Flags: exclusive
unchecked ; Components: pgsql
Name: open; Description: "No Network Security (All clients can connect)"; GroupDescription: "Network Security"; Flags:
exclusiveunchecked ; Components: pgsql
Name: user; Description: "Only local users can access database"; GroupDescription: "Network Security"; Flags:
exclusive ; Components: pgsql
Name: closed; Description: "Very secure (User must configure system)"; GroupDescription: "Network Security"; Flags:
exclusiveunchecked ; Components: pgsql
Name: startmenu; Description: "Put PostgreSQL in Startup Folder"; GroupDescription: "Startup Options"; Components:
pgsql;Flags:exclusive unchecked ;
[Files]
Source: "PostgreSQL\*.*"; DestDir: "{app}"; CopyMode: alwaysoverwrite; Flags: recursesubdirs; Components: pgsql
Source: "cygconsole.exe"; DestDir: "{app}\bin"; CopyMode: alwaysoverwrite ; Components: pgsql
Source: "pgsetup.sh"; DestDir: "{app}\bin"; CopyMode: alwaysoverwrite; Components: pgsql
Source: "pgsql.bat"; DestDir: "{app}\bin"; CopyMode: alwaysoverwrite; Components: pgsql
Source: "pgshell.bat"; DestDir: "{app}\bin"; CopyMode: alwaysoverwrite; Components: pgsql
Source: "profile"; DestDir: "{app}\etc"; CopyMode: alwaysoverwrite; Components: pgsql
; Choose which postgresql.conf.sample to install
Source: "postgresql.conf.highperf"; DestDir: "{app}/usr/share/postgresql"; DestName: postgresql.conf.sample; Tasks:
highperf ; Components: pgsql
Source: "postgresql.conf.user"; DestDir: "{app}/usr/share/postgresql"; DestName: postgresql.conf.sample; Tasks:
userperf; Components: pgsql
Source: "postgresql.conf.sample"; DestDir: "{app}/usr/share/postgresql"; DestName: postgresql.conf.sample; Tasks:
lowperf; Components: pgsql
; Choose which pg_hba.conf.sample to install
Source: "pg_hba.conf.user"; DestDir: "{app}/usr/share/postgresql"; DestName: pg_hba.conf.sample; Tasks: user ;
Components:pgsql
Source: "pg_hba.conf.open"; DestDir: "{app}/usr/share/postgresql"; DestName: pg_hba.conf.sample; Tasks: open ;
Components:pgsql
Source: "pg_hba.conf.closed"; DestDir: "{app}/usr/share/postgresql"; DestName: pg_hba.conf.sample; Tasks: closed ;
Components:pgsql
[Icons]
Name: "{group}\PostgreSQL Server"; Filename: "{app}\bin\cygconsole.exe" ; WorkingDir: "{app}\bin"; Parameters:
"PostgreSQL";Components: pgsql ; Flags: runminimized;
Name: "{userstartup}\PostgreSQL Server"; Filename: "{app}\bin\cygconsole.exe" ; WorkingDir: "{app}\bin"; Parameters:
"PostgreSQL";Components: pgsql; Tasks: startmenu;
Name: "{group}\PSQL Samples"; Filename: "{app}\bin\pgsql.bat" ; WorkingDir: "{app}\bin"; Parameters: "{app}\bin
samples" ; Components: unix
Name: "{group}\PSQL Public"; Filename: "{app}\bin\pgsql.bat" ; WorkingDir: "{app}\bin"; Parameters: "{app}\bin public"
;Components: unix
Name: "{group}\PostgreSQL System Console"; Filename: "{app}\bin\pgshell.bat" ; WorkingDir: "{app}\bin"; Parameters:
"{app}\bin" ; Components: unix;
[run]
Filename: "{app}\bin\cygconsole"; Description: "Creating Database Structure"; Parameters: "pgsetup"; Components: initdb
[Messages]
WelcomeLabel2=This program installs The PostgreSQL Server
