Thread: Re: Shrinkwrap Windows Product, any issues? Anyone? (postmaster windows shell)

>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 :)

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

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.

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.

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

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.
>
> :-)
>

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

----- 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.

 

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.