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

2002-12-05 Thread Igor Georgiev



I am working on getting a shrink-wrapped version of PostgreSQL for 
WindowsCurrently it installs a customized version of Cygwin, PostgreSQL 
7.2.3, cygipc, psqlodbc, and pgadminIII 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 implementedyet, 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 
:)


Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster windows

2002-12-05 Thread mlw




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






Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster

2002-12-05 Thread Justin Clift
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


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html


Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster

2002-12-05 Thread mlw


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.





---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster

2002-12-05 Thread mlw
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.



---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster

2002-12-05 Thread Justin Clift
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


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster

2002-12-05 Thread mlw
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.

:-)





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



Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster

2002-12-05 Thread Justin Clift
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


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone?

2002-12-03 Thread Dave Page


 -Original Message-
 From: mlw [mailto:[EMAIL PROTECTED]] 
 Sent: 03 December 2002 06:17
 To: psqlodbc; [EMAIL PROTECTED]
 Subject: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone?
 
 
 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.
 
 The target audience is not the enterprise, it is aimed at 
 people using 
 Access wanting to upgrade.
 
 I've looked long and hard and can't find any license issues. 
 Does anyone 
 know of any that I may have missed? As far as I can see, as long as I 
 maintain GPL restrictions, I should be fine.

No problems with pgAdmin, though I do have to wonder how you've done the
installer?

Regards, Dave.

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone?

2002-12-03 Thread cbbrowne
 I've looked long and hard and can't find any license issues. Does anyone 
 know of any that I may have missed? As far as I can see, as long as I 
 maintain GPL restrictions, I should be fine.

PostgreSQL isn't licensed under the GPL, so it sounds to me as though you're 
confused about the licensing issues.
--
(concatenate 'string cbbrowne @cbbrowne.com)
http://www3.sympatico.ca/cbbrowne/lsf.html
My mom said she learned how to swim. Someone took her out in the lake
and threw  her off  the boat. That's  how she  learned how to  swim. I
said, 'Mom, they  weren't trying to teach you how  to swim.'  
-- Paula Poundstone



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



Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone?

2002-12-03 Thread mlw


[EMAIL PROTECTED] wrote:


I've looked long and hard and can't find any license issues. Does anyone 
know of any that I may have missed? As far as I can see, as long as I 
maintain GPL restrictions, I should be fine.
   


PostgreSQL isn't licensed under the GPL, so it sounds to me as though you're 
confused about the licensing issues.

I'm not confused about the licensing issues. PostgreSQL is less 
restrictive than is GPL. Maybe I should have phrased it as the most 
restrictive license is GPL, so as long as I maintain GPL restrictions I 
should be fine.

--
(concatenate 'string cbbrowne @cbbrowne.com)
http://www3.sympatico.ca/cbbrowne/lsf.html
My mom said she learned how to swim. Someone took her out in the lake
and threw  her off  the boat. That's  how she  learned how to  swim. I
said, 'Mom, they  weren't trying to teach you how  to swim.'  
-- Paula Poundstone



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

 




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



Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone?

2002-12-03 Thread Dave Page


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
 Sent: 03 December 2002 12:16
 To: [EMAIL PROTECTED]
 Subject: Re: [HACKERS] Shrinkwrap Windows Product, any 
 issues? Anyone? 
 
 
  I've looked long and hard and can't find any license issues. Does 
  anyone
  know of any that I may have missed? As far as I can see, as 
 long as I 
  maintain GPL restrictions, I should be fine.
 
 PostgreSQL isn't licensed under the GPL, so it sounds to me 
 as though you're 
 confused about the licensing issues.

No, I don't think he is - Cygwin is GPL and psqlODBC is LGPL.

Regards, Dave.

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])



Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone?

2002-12-03 Thread mlw
Dave Page wrote:


 

-Original Message-
From: mlw [mailto:[EMAIL PROTECTED]] 
Sent: 03 December 2002 06:17
To: psqlodbc; [EMAIL PROTECTED]
Subject: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone?


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.

The target audience is not the enterprise, it is aimed at 
people using 
Access wanting to upgrade.

I've looked long and hard and can't find any license issues. 
Does anyone 
know of any that I may have missed? As far as I can see, as long as I 
maintain GPL restrictions, I should be fine.
   


No problems with pgAdmin, though I do have to wonder how you've done the
installer?

Regards, Dave.



Brute force, of course!

Seriously, I have hidden the cygwin environment and simply called it 
PostgreSQL. I am managing all he environment variables in my installer, 
and I am using Windows batch files to start bash which executes the 
PostgreSQL comands.

I am using PGAdmin as the administration tool

It really looks slick


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


Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone?

2002-12-03 Thread Dave Page


 -Original Message-
 From: mlw [mailto:[EMAIL PROTECTED]] 
 Sent: 03 December 2002 12:44
 To: Dave Page
 Cc: psqlodbc; [EMAIL PROTECTED]
 Subject: Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone?
 
 
 Dave Page wrote:
 
 
 No problems with pgAdmin, though I do have to wonder how you've done 
 the installer?
 
 Regards, Dave.
 
 
 Brute force, of course!
 
 Seriously, I have hidden the cygwin environment and simply called it 
 PostgreSQL. I am managing all he environment variables in my 
 installer, 
 and I am using Windows batch files to start bash which executes the 
 PostgreSQL comands.
 
 I am using PGAdmin as the administration tool
 
 It really looks slick

I was thinking more about how you've dealt with installing pgAdmin, or
have you left it seperate? If you need any help with that side of it,
just let me know...

Sounds good though...

Regards, Dave (aka [EMAIL PROTECTED]).

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly



Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone?

2002-12-03 Thread Christopher Kings-Lynne
 Brute force, of course!

 Seriously, I have hidden the cygwin environment and simply called it
 PostgreSQL. I am managing all he environment variables in my installer,
 and I am using Windows batch files to start bash which executes the
 PostgreSQL comands.

 I am using PGAdmin as the administration tool

 It really looks slick

We've done great things at our office, using the free NullSoft installer
(WinAmp):

http://www.winamp.com/nsdn/nsis/

Chris


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]



[HACKERS] Shrinkwrap Windows Product, any issues? Anyone?

2002-12-02 Thread mlw
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.

The target audience is not the enterprise, it is aimed at people using 
Access wanting to upgrade.

I've looked long and hard and can't find any license issues. Does anyone 
know of any that I may have missed? As far as I can see, as long as I 
maintain GPL restrictions, I should be fine.




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