Re: PG on Win2K

Folks,

Some background: our application is dependent on Postgresql and we are extremely happy with it. We've been running it Linux servers.

However, our target customers are mostly Win2k and are not expected to be IT savvy nor have any IT personnel. We are therefore trying to make it a painless install, and other than PG, we have everything figured out that would make it as simple as unzipping and starting the server.

My questions:
1. is there a simple way for pg to be installed on win2k machines?
2. Is cygwin required?
3. Can we just bundle all the software so that the end user doesn't have to do all the work and also we have a controlled environment?

The aim is to make it really easy.

*Any* help will be greatly appreciated.

Sincerely,
-n.

Nikhil,

Asynchrony Solutions has a product named Envoke, a cross platform
collaboration application which by default uses PostgreSQL on the
back-end. It is included in Envoke's Windows installation. By visiting
http://www.envoke.us, you can download a trial of the software, to see
how PostgreSQL for Windows gets installed and started automatically.

Myles

Nikhil G. Daddikar wrote:

>Folks,
>
>Some background: our application is dependent on Postgresql and we are extremely happy with it. We've been running it Linux servers.
>
>However, our target customers are mostly Win2k and are not expected to be IT savvy nor have any IT personnel. We are therefore trying to make it a painless install, and other than PG, we have everything figured out that would make it as simple as unzipping and starting the server.
>
>My questions:
>1. is there a simple way for pg to be installed on win2k machines?
>2. Is cygwin required?
>3. Can we just bundle all the software so that the end user doesn't have to do all the work and also we have a controlled environment?
>
>The aim is to make it really easy.
>
>*Any* help will be greatly appreciated.
>
>Sincerely,
>-n.
>
>
>
>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>

--
Myles Bogner, Ph.D. : VP Research & Development
PN: 314.678.2222
FX: 314.436.2559
Email: dr(dot)myles(dot)bogner(at)asolutions(dot)com

Asynchrony Solutions, Inc.
1709 Washington Ave. // Suite 200
St. Louis, MO 63103
www.asolutions.com

Nikhil,

On Fri, Aug 30, 2002 at 02:29:24PM +0530, Nikhil G. Daddikar wrote:
> My questions:
> 1. is there a simple way for pg to be installed on win2k machines?

Yes, but it will require some work on your part. My suggestion is to
script the installation steps in my README:

http://www.tishler.net/jason/software/postgresql/postgresql-7.2.1.README

> 2. Is cygwin required?

Currently yes, but soon there should be a straight Win32 version
available. If you choose to wait for the Win32 version, then you can
ignore most (if not all) of this email.

> 3. Can we just bundle all the software so that the end user doesn't
> have to do all the work and also we have a controlled environment?

Yes, I have used self-extracting zip archives to clone Cygwin
environments very successfully in the past. There is no reason why this
would not work for you.

BTW, if you deploy a Cygwin PostgreSQL based solution, then make sure
that you comply with the licensing terms:

http://cygwin.com/licensing.html

The bottom line is just include the source to *all* of the apps that
link with the Cygwin DLL (i.e., cygwin1.dll) and the Cygwin DLL itself.

> The aim is to make it really easy.

This is very achievable, but as I stated above, it will require some
effort on your part.

Jason

Nikhil,

Please keep your replies on-list...

On Fri, Aug 30, 2002 at 11:21:09PM +0530, Nikhil G. Daddikar wrote:
> : > 2. Is cygwin required?
> :
> : Currently yes, but soon there should be a straight Win32 version
> : available. If you choose to wait for the Win32 version, then you
> : can ignore most (if not all) of this email.
> :
>
> Thanks for the comprehensive information.

You are welcome.

> Is there any place where I can get more info on the win32 version?

I presume so, but I don't know where.

Jason

Hi,
We have the exact same issue here. It is very well possible, we have it
running (win9x/ME/NT4/W2K/XP).
Cygwin is required, but you can make a minimal install.
We use NSIS installer to
1) Let the user decide where to install
2) copy package all the cygwin+postgresql files in one SETUP.EXE, and
3) do some postinstall scripts.
After this everything is set up. Click start.bat and go.
Or even better: you can do the same thing as NT services.

We also have made a "cygwin-postgresql control panel", which looks a bit
like msSQL's to start/stop/backup/vacuum/schedule/change-database.

Our installer bundle will be released as freeware/applicable licences for
pg/cygwin when we think has been tested.

We also stresstested cygwin. With our app its stable, but the is a 60
concurrent user limit to the postgres-cygwin-windows combination.

A native postgres for windows version, to be released into the source tree,
is currently under developement however. No release date yet as i understand
it.

Regards, J Hondius

-----Oorspronkelijk bericht-----
Van: pgsql-cygwin-owner(at)postgresql(dot)org
[mailto:pgsql-cygwin-owner(at)postgresql(dot)org]Namens Nikhil G. Daddikar
Verzonden: vrijdag 30 augustus 2002 10:59
Aan: pgsql-cygwin(at)postgresql(dot)org
Onderwerp: [CYGWIN] PG on Win2K

Folks,

Some background: our application is dependent on Postgresql and we are
extremely happy with it. We've been running it Linux servers.

However, our target customers are mostly Win2k and are not expected to be IT
savvy nor have any IT personnel. We are therefore trying to make it a
painless install, and other than PG, we have everything figured out that
would make it as simple as unzipping and starting the server.

My questions:
1. is there a simple way for pg to be installed on win2k machines?
2. Is cygwin required?
3. Can we just bundle all the software so that the end user doesn't have to
do all the work and also we have a controlled environment?

The aim is to make it really easy.

*Any* help will be greatly appreciated.

Sincerely,
-n.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster