>I am working on getting a shrink-wrapped version of PostgreSQL for Windows
>Currently it installs a customized version of Cygwin, PostgreSQL 7.2.3, cygipc, psqlodbc, and pgadminII
>I currently have the setup done.

Cool :)

I'm now working on postmaster windows shell. It's not finished yet but main things work.
Funcionality implemented now is :
    Console redirection for capture output from postmaster
    Starting-stoping postmaster
    Choose for shutdown mode
    System tray icon
    Postmaster options are read from registry
        -postmaster path
        -datadir
        -additional options

Funcionality not implemented yet, but planned :
    Writing captured output from postmaster to log file
    Options setup dialog
    Edit pg_hba.conf
    ??? 
    

Application is MFC free pure windows API (compiler:gcc-mingw, Dev-C++ IDE) .

Here is the screenshot



I also be GLAD to read about plans for native windows port in 7.4.
If anyone is interested i can post source code, or maybe this firrst steps can go to gborg as a separate project 
i'm not sure yet. 

PS: Excuse me for my english, I'm better in C :)
Thu, 5 Dec 2002 14:42:10 +0100
"Igor Georgiev" <gory@alphasoft-bg.com>
Re: Shrinkwrap Windows Product,
	any issues? Anyone? (postmaster windows shell)
Hey this is a cool project. I have been thinking doing the exact ame 
thing, the console Window of 2K/XP just kills the daemon, yuck.

What can I do to help?

Igor Georgiev wrote:

> >I am working on getting a shrink-wrapped version of PostgreSQL for 
> Windows
> >Currently it installs a customized version of Cygwin, PostgreSQL 
> 7.2.3, cygipc, psqlodbc, and pgadminII
> >I currently have the setup done.
>  
> Cool :)
>  
> I'm now working on postmaster windows shell. It's not finished yet but 
> main things work.
> Funcionality implemented now is :
>     Console redirection for capture output from postmaster
>     Starting-stoping postmaster
>     Choose for shutdown mode
>     System tray icon
>     Postmaster options are read from registry
>         -postmaster path
>         -datadir
>         -additional options
>  
> Funcionality not implemented yet, but planned :
>     Writing captured output from postmaster to log file
>     Options setup dialog
>     Edit pg_hba.conf
>     ???
>    
>  
> Application is MFC free pure windows API (compiler:gcc-mingw, Dev-C++ 
> IDE) .
>  
> Here is the screenshot
>  
>
> I also be GLAD to read about plans for native windows port in 7.4.
> If anyone is interested i can post source code, or maybe this firrst 
> steps can go to gborg as a separate project
> i'm not sure yet.
>  
> PS: Excuse me for my english, I'm better in C :)
Thu, 05 Dec 2002 12:52:29 -0500
mlw <pgsql@mohawksoft.com>
Re: Shrinkwrap Windows Product,
	any issues? Anyone? (postmaster windows
Igor Georgiev wrote:
<snip>
> I also be GLAD to read about plans for native windows port in 7.4.
> If anyone is interested i can post source code, or maybe this firrst 
> steps can go to gborg as a separate project
> i'm not sure yet.

Hi Igor,

This would be a really good thing to get into GBorg as a project, so 
people could work on this through CVS.

Would you like to register it as a project?

Mark, do you feel it would be better to put your installer plus this 
together into one project on GBorg too?  Not sure, it's just a thought.

:-)

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


Fri, 06 Dec 2002 09:32:49 +1100
Justin Clift <justin@postgresql.org>
Re: Shrinkwrap Windows Product, any issues? Anyone? (postmaster


Justin Clift wrote:

> Igor Georgiev wrote:
> <snip>
>
>> I also be GLAD to read about plans for native windows port in 7.4.
>> If anyone is interested i can post source code, or maybe this firrst 
>> steps can go to gborg as a separate project
>> i'm not sure yet.
>
>
> Hi Igor,
>
> This would be a really good thing to get into GBorg as a project, so 
> people could work on this through CVS.
>
> Would you like to register it as a project?
>
> Mark, do you feel it would be better to put your installer plus this 
> together into one project on GBorg too?  Not sure, it's just a thought. 


The installer is simply a script, the ino installer, and a strategy. I 
install enough Cygwin to run PostgreSQL, and a few batch files, I then 
compile that into an install file. No biggie.

Igor's console program is cool, I was thinking of writing something just 
like it.





Thu, 05 Dec 2002 18:06:38 -0500
mlw <pgsql@mohawksoft.com>
Re: Shrinkwrap Windows Product, any issues? Anyone? (postmaster
Justin Clift wrote:

>
> Hi Igor,
>
> This would be a really good thing to get into GBorg as a project, so 
> people could work on this through CVS.
>
> Would you like to register it as a project?
>
> Mark, do you feel it would be better to put your installer plus this 
> together into one project on GBorg too?  Not sure, it's just a thought.

I just want to say, the Windows installer was pretty easy once you 
decide that you are not going to give the user who installs the system 
the infinite range of options that they would have if they installed 
cygwin and went from there.

We decided on a good middle of the road installation that would work for 
advanced users. If they want an enterprise server, they will have to 
modify the installation themselves.

I have developed Windows programs since version 1,x, what I see as one 
of the bigger hurdles in providing UNIX products on Windows is that the 
UNIX philosophy is that of "Capability not Policy." Windows demands a 
"Policy," i.e. when the install is done, they should be able to press 
"start" and use it.

To do that with postgresql, you have to create an install that will work 
for most of the people that will want to use it, out of the box, with no 
fuss.

I know I am pontificating, but I do think there is a HUGE market for 
PostgreSQL on Windows, we just have to figure out how to get it.  What I 
want, is an install that application developers can use as the basis for 
their ODBC or SQL based projects, instead of MSSQL. Sort of like a 
"Developers" version of PostgreSQL.

Once we do that, the we have the hook for more reliable and powerful 
systems.



Thu, 05 Dec 2002 18:40:42 -0500
mlw <pgsql@mohawksoft.com>
Re: Shrinkwrap Windows Product, any issues? Anyone? (postmaster
mlw wrote:
<snip>
> Once we do that, the we have the hook for more reliable and powerful 
> systems.

Yep, I pretty much agree.

:-)

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


Fri, 06 Dec 2002 11:34:21 +1100
Justin Clift <justin@postgresql.org>
Re: Shrinkwrap Windows Product, any issues? Anyone? (postmaster
Justin:

Are you involved with gborg?

I have been thinking about Igor's console and my installer. I think 
there is a good enough need to host a project that contains HOWTOs, 
scripts, and tools to make PostgreSQL easy for Windows deployment.

I am working on a HOWTO, a set of Windows batch files, and the install 
scripts I would be glad to post, and I would be very glad to include 
Igor's console in the install.

It would make a cool offering.



Justin Clift wrote:

> mlw wrote:
> <snip>
>
>> Once we do that, the we have the hook for more reliable and powerful 
>> systems.
>
>
> Yep, I pretty much agree.
>
> :-)
>



Thu, 05 Dec 2002 23:26:42 -0500
mlw <pgsql@mohawksoft.com>
Re: Shrinkwrap Windows Product, any issues? Anyone? (postmaster
Hi Mark,

mlw wrote:
> Justin:
> 
> Are you involved with gborg?

Nope, that's Chris Ryan's area.  :)


> I have been thinking about Igor's console and my installer. I think 
> there is a good enough need to host a project that contains HOWTOs, 
> scripts, and tools to make PostgreSQL easy for Windows deployment.

It is good to keep all of the instructions+code together, or better to 
put the instructions somewhere (i.e. the Techdocs site) plus links to 
the Gborg project to get the code.  Either way could work, etc.

> I am working on a HOWTO, a set of Windows batch files, and the install 
> scripts I would be glad to post, and I would be very glad to include 
> Igor's console in the install.

Yep, he does seem to have created a pretty nifty console.

> It would make a cool offering.

:-)

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


Fri, 06 Dec 2002 16:05:49 +1100
Justin Clift <justin@postgresql.org>
Re: Shrinkwrap Windows Product, any issues? Anyone? (postmaster
----- Original Message ----- 
  From: mlw 
  To: Igor Georgiev 
  Cc: pgsql-hackers@postgresql.org 
  Sent: Thursday, December 05, 2002 6:52 PM
  Subject: Re: Shrinkwrap Windows Product, any issues? Anyone? (postmaster windows shell)


  Hey this is a cool project. I have been thinking doing the exact ame thing, the console Window of 2K/XP just kills the daemon, yuck.

  What can I do to help?

  ----- Original Message ----- 
  From: "Justin Clift" <justin@postgresql.org>
  To: "Igor Georgiev" <gory@alphasoft-bg.com>
  Cc: <pgsql-hackers@postgresql.org>; <pgsql@mohawksoft.com>
  Sent: Thursday, December 05, 2002 11:32 PM
  Subject: Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster windows shell)
        
  Hi Igor,
   
   This would be a really good thing to get into GBorg as a project, so 
   people could work on this through CVS.
   
   Would you like to register it as a project?
   
   Mark, do you feel it would be better to put your installer plus this 
   together into one project on GBorg too?  Not sure, it's just a thought.


Was [Re: Shrinkwrap Windows Product, any issues? Anyone? (postmaster windows shell)]


Justin :
      Current active projects: 
            Project  Role 
            winmaster (awaiting approval)  Admin 
              WinMaster - windows console for PostgreSQL 


      mlw:
      > I am working on a HOWTO, a set of Windows batch files, and the install 
      > scripts I would be glad to post, and I would be very glad to include 
      > Igor's console in the install.
      > 
      > It would make a cool offering.
      Its Ok 4 me.
     

Unfortunately i havent Windows  2K/XP so i can't test it :(.
I can send u source if u wish.
Fri, 6 Dec 2002 13:04:28 +0100
"Igor Georgiev" <gory@alphasoft-bg.com>
Postmaster windows shell