Hi everyone,

Mark (mlw) put together a PostgreSQL installer for Windows (cygwin 
version) a little while ago, but he hasn't been responding to requests 
for feedback regarding it (probably busy).

As we're going to be releasing a native Windows version of PostgreSQL 
7.4 in a few months, it seems appropriate that we practise first to get 
the hang of making packages on Windows, plus encourage anyone with 
graphical talent to make attractive icon's for menu options, etc.

Anyway, spent the last two days making a brand new "PostgreSQL 7.3.1 
Proof of Concept for Windows Alpha 1" easy-installer (11,161KB) using a 
product called Inno Setup (very nice) and have a pretty good result.

It looks and feels *really* professional, and if people didn't know that 
it was using cygwin, they'd probably never guess.

Am reckoning that the best thing to do for this is to create a project 
on GBorg of some name, upload it, and everyone who is interested can 
take it from there.

Does that sound like the best approach, and does anyone have good 
suggestions for a project name?

:-)

Regards and best wishes,

Justin Clift

-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi


Sun, 26 Jan 2003 13:42:11 +1030
Justin Clift <justin@postgresql.org>
Have a PG 7.3.1 Windows (cygwin) easy installer... now what to do
	with it?
Sorry, I think there was a misunderstanding. What were you looking for?

I used inno setup as well. If you want I can send my install script.

I thought I was being very forth coming.

I even help out on the Windows PG console window.



Justin Clift wrote:

> Hi everyone,
>
> Mark (mlw) put together a PostgreSQL installer for Windows (cygwin 
> version) a little while ago, but he hasn't been responding to requests 
> for feedback regarding it (probably busy).
>
> As we're going to be releasing a native Windows version of PostgreSQL 
> 7.4 in a few months, it seems appropriate that we practise first to 
> get the hang of making packages on Windows, plus encourage anyone with 
> graphical talent to make attractive icon's for menu options, etc.
>
> Anyway, spent the last two days making a brand new "PostgreSQL 7.3.1 
> Proof of Concept for Windows Alpha 1" easy-installer (11,161KB) using 
> a product called Inno Setup (very nice) and have a pretty good result.
>
> It looks and feels *really* professional, and if people didn't know 
> that it was using cygwin, they'd probably never guess.
>
> Am reckoning that the best thing to do for this is to create a project 
> on GBorg of some name, upload it, and everyone who is interested can 
> take it from there.
>
> Does that sound like the best approach, and does anyone have good 
> suggestions for a project name?
>
> :-)
>
> Regards and best wishes,
>
> Justin Clift
>



Sat, 25 Jan 2003 22:54:35 -0500
mlw <pgsql@mohawksoft.com>
Re: Have a PG 7.3.1 Windows (cygwin) easy installer... now
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


-- 
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi


Sun, 26 Jan 2003 14:29:25 +1030
Justin Clift <justin@postgresql.org>
Re: Have a PG 7.3.1 Windows (cygwin) easy installer... now
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
>
>
Sun, 26 Jan 2003 09:47:34 -0500
mlw <pgsql@mohawksoft.com>
Re: Have a PG 7.3.1 Windows (cygwin) easy installer... now

> 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.
>
All Mark's changes are included in latest code.
----------------------------------------------------------------
Also a registry template is included - winmaster.reg.
You may edit it in accordance with your instalation and add the
information to registry
----------------------------------------------------------------
The deafult profile name are stored in
[HKEY_LOCAL_MACHINE\Software\WinMaster]
"DefProfile"="PostgreSQL"
----------------------------------------------------------------
Optional profiles may be used trough command line parameter.
To use the profile PostgreSQL723 stored in
[HKEY_LOCAL_MACHINE\Software\WinMaster\PostgreSQL723]
execute this
winmaster PostgreSQL723
----------------------------------------------------------------


Mon, 27 Jan 2003 13:57:25 +0100
"Igor Georgiev" <gory@alphasoft-bg.com>
Re: [HACKERS] Have a PG 7.3.1 Windows (cygwin) easy installer... now