Dear friends,

In the past, there were several discussions in order to find suitable answers 
for MS Windows users willing to install and run PostgreSQL.

Some of you suggested that users should "install GNU/Linux over Windows". Not 
so easy for the basic MySQL or Ms Windows user, who need technical 
assistance ... and fear to destroy their machine.

Therefore, I would like to draw some attention on the Morphix CD project from  
http://sourceforge.net/projects/morphix.

Morphix is an auto-bootable Debian GNU/Linux distribution based on Knoppix.

What makes Morphix different is that the project has several graphical 
installers and wizards in preparation (written in plain C, using GTK-2 
libraries and Glade-2) ... which could possibly be used to install GNU/Linux 
and PostgreSQL tools over MS Windows.

You can download a preview CD of Morphix from this address:
http://prdownloads.sourceforge.net/morphix/MorphixCombined-Gnome-0.4-1.iso?download

Except for the installer itself, the wizards are not yet available in the main 
Morphix CD. To have a look at them, you will need to checkout from CVS 
(http://cvs.sourceforge.net/viewcvs.py/morphix) and open the files in 
Glade-2.

I also made some screenshots here:

- morphixinstaller: once Morphix has booted in demo mode, you can use this 
wizard to install Morphix on the disk. Screenshots:
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step1.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step2.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step3.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step4.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step5.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step6.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step7.png

- isomorphgui: graphical distribution maker (select the requested packages for 
your distribution and burn the ISO). Screenshots:
http://developer.pgadmin.org/jean-michel/morphix/iso_morph_gui_1.png
http://developer.pgadmin.org/jean-michel/morphix/iso_morph_gui_2.png

- partitionmorpher: resize partitions on the fly (GTK-2 interface to 
libparted). Screenshots:
http://developer.pgadmin.org/jean-michel/morphix/partition_morpher_1.png
http://developer.pgadmin.org/jean-michel/morphix/partition_morpher_2.png

IMHO opinion, there is a need to study the Morphix project in more details.

Morphix could be a possible solution to the MS Windows migration problems. It 
probably involves 50 times less work than migrating PostgreSQL to MS Windows 
(and is a complete different project except for the fact that it could well 
bring as much new users to PostgreSQL than a native Win port and is less 
risky).

The possible steps for such a project could be (just a guess):

1) Validate Morphixinstaller, isomorphgui and partitionmorpher wizards. These 
wizards are still in early stages of development. They are developed by one 
person, who would probably like to receive some help.

2) Create a wizard for PostgreSQL post-installation steps using GTK-2 and 
Glade-2: configuration of hosts and authentication, tuning and optimization 
of various parameters (Mainly a graphical interface to pg_hba.conf and 
postgresql.conf).

3) Gather all known PostgreSQL related Debian packages, including pgAdmin III, 
PhpPgAdmin, as well as PHP, Apache and report tools (and much more) and burn 
Morphix-PostgreSQL CDs.

There could be a "light PostgreSQL CD" as well as a "complete PostgreSQL CD".

4) Create a single website in 30 languages (http://installer.postgresql.org?) 
dedicated to releasing the installation CD.

Based on the pgAdmin experience, there could well be more than 50.000 
downloads every month, out of which 70% would be migrating from MS Windows to 
GNU/Linux.

Comments and ideas are welcome. I would like to help anyone interested in 
becoming the lead of such a project.

Best regards,
Jean-Michel Pouré




Thu, 22 Jan 2004 16:15:36 +0100
Jean-Michel POURE <jm@poure.com>
PostgreSQL installation CD based on Morphix
Jean-Michel POURE said:
>
> Morphix could be a possible solution to the MS Windows migration
> problems. It  probably involves 50 times less work than migrating
> PostgreSQL to MS Windows  (and is a complete different project except
> for the fact that it could well  bring as much new users to PostgreSQL
> than a native Win port and is less  risky).
>

This is a fantasy, IMNSHO. Windows users will want a native program that
they can run just like other Windows programs, and alongside them.
Requiring the installation of a complete Linux distribution, no matter how
nicely packaged, is hardly likely to win many Windows converts to postgres.

If I were a data center manager, I would not think of allowing such a
hybrid machine into it. I would insist that we either ran postgres as a
native windows service, or run it on a pur *nix machine, or not at all.

It would be a massive and unnecessary distraction, for no benefit, for
postgresql hackers to go down this route.

BTW, the major pieces of the Windows port are falling into place quite
nicely, with little evidence so far of the risks you mention. Of course,
there will be a few teething troubles, but nobody has yet seen a major
blocker. The biggest problems (forking and signal emulation) appear to
have been solved.

cheers

andrew




Thu, 22 Jan 2004 12:12:11 -0500 (EST)
"Andrew Dunstan" <andrew@dunslane.net>
Re: [HACKERS] PostgreSQL installation CD based on Morphix
We (Japan PostgreSQL User Group) have just created "PostgreSQL LiveCD"
based KNOPPIX to promote PostgreSQL to newbies. It includes

 - PostgreSQL 7.4.1
 - PHP 4.3.4
 - Apache 1.3.29
 - Tomcat 4.1.9 (but J2SDK is not included because of license.)
 - phpPgAdmin 3.2.1
 - pgAdmin3 1.0.2
 - phpbb
 - Full text search in these manuals

Screen shot:
http://www.postgresql.jp/~snaga/shot.png

If you boot your machine with this CD-ROM, all of them are running and
you can start web application development without any installation.

We will introduce this CD-ROM on NET&COM 2004(Feb.4-6) at Tokyo.

Jean-Michel POURE <jm@poure.com> wrote:
> Dear friends,
> 
> In the past, there were several discussions in order to find suitable answers 
> for MS Windows users willing to install and run PostgreSQL.
> 
> Some of you suggested that users should "install GNU/Linux over Windows". Not 
> so easy for the basic MySQL or Ms Windows user, who need technical 
> assistance ... and fear to destroy their machine.
> 
> Therefore, I would like to draw some attention on the Morphix CD project from  
> http://sourceforge.net/projects/morphix.
> 
> Morphix is an auto-bootable Debian GNU/Linux distribution based on Knoppix.
> 
> What makes Morphix different is that the project has several graphical 
> installers and wizards in preparation (written in plain C, using GTK-2 
> libraries and Glade-2) ... which could possibly be used to install GNU/Linux 
> and PostgreSQL tools over MS Windows.
> 
> You can download a preview CD of Morphix from this address:
> http://prdownloads.sourceforge.net/morphix/MorphixCombined-Gnome-0.4-1.iso?download
> 
> Except for the installer itself, the wizards are not yet available in the main 
> Morphix CD. To have a look at them, you will need to checkout from CVS 
> (http://cvs.sourceforge.net/viewcvs.py/morphix) and open the files in 
> Glade-2.
> 
> I also made some screenshots here:
> 
> - morphixinstaller: once Morphix has booted in demo mode, you can use this 
> wizard to install Morphix on the disk. Screenshots:
> http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step1.png
> http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step2.png
> http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step3.png
> http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step4.png
> http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step5.png
> http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step6.png
> http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step7.png
> 
> - isomorphgui: graphical distribution maker (select the requested packages for 
> your distribution and burn the ISO). Screenshots:
> http://developer.pgadmin.org/jean-michel/morphix/iso_morph_gui_1.png
> http://developer.pgadmin.org/jean-michel/morphix/iso_morph_gui_2.png
> 
> - partitionmorpher: resize partitions on the fly (GTK-2 interface to 
> libparted). Screenshots:
> http://developer.pgadmin.org/jean-michel/morphix/partition_morpher_1.png
> http://developer.pgadmin.org/jean-michel/morphix/partition_morpher_2.png
> 
> IMHO opinion, there is a need to study the Morphix project in more details.
> 
> Morphix could be a possible solution to the MS Windows migration problems. It 
> probably involves 50 times less work than migrating PostgreSQL to MS Windows 
> (and is a complete different project except for the fact that it could well 
> bring as much new users to PostgreSQL than a native Win port and is less 
> risky).
> 
> The possible steps for such a project could be (just a guess):
> 
> 1) Validate Morphixinstaller, isomorphgui and partitionmorpher wizards. These 
> wizards are still in early stages of development. They are developed by one 
> person, who would probably like to receive some help.
> 
> 2) Create a wizard for PostgreSQL post-installation steps using GTK-2 and 
> Glade-2: configuration of hosts and authentication, tuning and optimization 
> of various parameters (Mainly a graphical interface to pg_hba.conf and 
> postgresql.conf).
> 
> 3) Gather all known PostgreSQL related Debian packages, including pgAdmin III, 
> PhpPgAdmin, as well as PHP, Apache and report tools (and much more) and burn 
> Morphix-PostgreSQL CDs.
> 
> There could be a "light PostgreSQL CD" as well as a "complete PostgreSQL CD".
> 
> 4) Create a single website in 30 languages (http://installer.postgresql.org?) 
> dedicated to releasing the installation CD.
> 
> Based on the pgAdmin experience, there could well be more than 50.000 
> downloads every month, out of which 70% would be migrating from MS Windows to 
> GNU/Linux.
> 
> Comments and ideas are welcome. I would like to help anyone interested in 
> becoming the lead of such a project.
> 
> Best regards,
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
> 


-- 
NAGAYASU Satoshi <snaga@snaga.org>


Fri, 23 Jan 2004 10:45:11 +0900
Satoshi Nagayasu <snaga@snaga.org>
Re: [HACKERS] PostgreSQL installation CD based on Morphix
If you want to install to your hard drive, KNOPPIX installation script
can help you.

However, I think "without any installation" is more important for
newbies.

Any comments?

Satoshi Nagayasu <snaga@snaga.org> wrote:
> We (Japan PostgreSQL User Group) have just created "PostgreSQL LiveCD"
> based KNOPPIX to promote PostgreSQL to newbies. It includes
> 
>  - PostgreSQL 7.4.1
>  - PHP 4.3.4
>  - Apache 1.3.29
>  - Tomcat 4.1.9 (but J2SDK is not included because of license.)
>  - phpPgAdmin 3.2.1
>  - pgAdmin3 1.0.2
>  - phpbb
>  - Full text search in these manuals
> 
> Screen shot:
> http://www.postgresql.jp/~snaga/shot.png
> 
> If you boot your machine with this CD-ROM, all of them are running and
> you can start web application development without any installation.
> 
> We will introduce this CD-ROM on NET&COM 2004(Feb.4-6) at Tokyo.
> 
> Jean-Michel POURE <jm@poure.com> wrote:
> > Dear friends,
> > 
> > In the past, there were several discussions in order to find suitable answers 
> > for MS Windows users willing to install and run PostgreSQL.
> > 
> > Some of you suggested that users should "install GNU/Linux over Windows". Not 
> > so easy for the basic MySQL or Ms Windows user, who need technical 
> > assistance ... and fear to destroy their machine.
> > 
> > Therefore, I would like to draw some attention on the Morphix CD project from  
> > http://sourceforge.net/projects/morphix.
> > 
> > Morphix is an auto-bootable Debian GNU/Linux distribution based on Knoppix.
> > 
> > What makes Morphix different is that the project has several graphical 
> > installers and wizards in preparation (written in plain C, using GTK-2 
> > libraries and Glade-2) ... which could possibly be used to install GNU/Linux 
> > and PostgreSQL tools over MS Windows.
> > 
> > You can download a preview CD of Morphix from this address:
> > http://prdownloads.sourceforge.net/morphix/MorphixCombined-Gnome-0.4-1.iso?download
> > 
> > Except for the installer itself, the wizards are not yet available in the main 
> > Morphix CD. To have a look at them, you will need to checkout from CVS 
> > (http://cvs.sourceforge.net/viewcvs.py/morphix) and open the files in 
> > Glade-2.
> > 
> > I also made some screenshots here:
> > 
> > - morphixinstaller: once Morphix has booted in demo mode, you can use this 
> > wizard to install Morphix on the disk. Screenshots:
> > http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step1.png
> > http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step2.png
> > http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step3.png
> > http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step4.png
> > http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step5.png
> > http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step6.png
> > http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step7.png
> > 
> > - isomorphgui: graphical distribution maker (select the requested packages for 
> > your distribution and burn the ISO). Screenshots:
> > http://developer.pgadmin.org/jean-michel/morphix/iso_morph_gui_1.png
> > http://developer.pgadmin.org/jean-michel/morphix/iso_morph_gui_2.png
> > 
> > - partitionmorpher: resize partitions on the fly (GTK-2 interface to 
> > libparted). Screenshots:
> > http://developer.pgadmin.org/jean-michel/morphix/partition_morpher_1.png
> > http://developer.pgadmin.org/jean-michel/morphix/partition_morpher_2.png
> > 
> > IMHO opinion, there is a need to study the Morphix project in more details.
> > 
> > Morphix could be a possible solution to the MS Windows migration problems. It 
> > probably involves 50 times less work than migrating PostgreSQL to MS Windows 
> > (and is a complete different project except for the fact that it could well 
> > bring as much new users to PostgreSQL than a native Win port and is less 
> > risky).
> > 
> > The possible steps for such a project could be (just a guess):
> > 
> > 1) Validate Morphixinstaller, isomorphgui and partitionmorpher wizards. These 
> > wizards are still in early stages of development. They are developed by one 
> > person, who would probably like to receive some help.
> > 
> > 2) Create a wizard for PostgreSQL post-installation steps using GTK-2 and 
> > Glade-2: configuration of hosts and authentication, tuning and optimization 
> > of various parameters (Mainly a graphical interface to pg_hba.conf and 
> > postgresql.conf).
> > 
> > 3) Gather all known PostgreSQL related Debian packages, including pgAdmin III, 
> > PhpPgAdmin, as well as PHP, Apache and report tools (and much more) and burn 
> > Morphix-PostgreSQL CDs.
> > 
> > There could be a "light PostgreSQL CD" as well as a "complete PostgreSQL CD".
> > 
> > 4) Create a single website in 30 languages (http://installer.postgresql.org?) 
> > dedicated to releasing the installation CD.
> > 
> > Based on the pgAdmin experience, there could well be more than 50.000 
> > downloads every month, out of which 70% would be migrating from MS Windows to 
> > GNU/Linux.
> > 
> > Comments and ideas are welcome. I would like to help anyone interested in 
> > becoming the lead of such a project.
> > 
> > Best regards,
> > 
> > 
> > 
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 7: don't forget to increase your free space map settings
> > 
> 
> 
> -- 
> NAGAYASU Satoshi <snaga@snaga.org>
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html
> 


-- 
NAGAYASU Satoshi <snaga@snaga.org>


Fri, 23 Jan 2004 11:08:32 +0900
Satoshi Nagayasu <snaga@snaga.org>
Re: [pgsql-advocacy] [HACKERS] PostgreSQL installation CD based on
	Morphix
Le Vendredi 23 Janvier 2004 03:08, Satoshi Nagayasu a écrit :
> If you want to install to your hard drive, KNOPPIX installation script
> can help you.
> However, I think "without any installation" is more important for
> newbies.
> Any comments?

Dear Satoshi,

Your Knoppix-based CD-ROM is a great way to promote PostgreSQL. My Debian 
workstation was installed using Knoppix. It worked like a charm without any 
problem until now.

My point of view is that Knoppix text-based installation scripts are not 
enough user-friendly for most MS Windows users.

This opinion comes from a self-study that I conducted visiting my neighbours 
in order to demonstrate and install Debian. My neighbours are mostly casual 
MS Windows users with no special background in computing.

Some accepted to replace MS Windows with Debian, others did not. But all of 
them had problems with Knoppix text-based installation scripts.

Therefore, my personal opinion is that Knoppix with good graphical 
installation wizards would 'rock'. This is how I turned to Morphix ... which 
is mostly based on Knoppix. The problem is that Morphix wizards are still 
very unstable.

Now, if you allow it, I will contact you privately to propose for help the 
best I can ...

Best regards,
Jean-Michel


Fri, 23 Jan 2004 10:18:16 +0100
Jean-Michel POURE <jm@poure.com>
Re: [pgsql-advocacy] [HACKERS] PostgreSQL installation CD based on
	Morphix
What do people think about putting an .iso of this on the postgresql ftp
server and/or the sourceforge site?

Robert Treat

On Thu, 2004-01-22 at 21:08, Satoshi Nagayasu wrote:
> If you want to install to your hard drive, KNOPPIX installation script
> can help you.
> 
> However, I think "without any installation" is more important for
> newbies.
> 
> Any comments?
> 
> Satoshi Nagayasu <snaga@snaga.org> wrote:
> > We (Japan PostgreSQL User Group) have just created "PostgreSQL LiveCD"
> > based KNOPPIX to promote PostgreSQL to newbies. It includes
> > 
> >  - PostgreSQL 7.4.1
> >  - PHP 4.3.4
> >  - Apache 1.3.29
> >  - Tomcat 4.1.9 (but J2SDK is not included because of license.)
> >  - phpPgAdmin 3.2.1
> >  - pgAdmin3 1.0.2
> >  - phpbb
> >  - Full text search in these manuals
> > 
> > Screen shot:
> > http://www.postgresql.jp/~snaga/shot.png
> > 
> > If you boot your machine with this CD-ROM, all of them are running and
> > you can start web application development without any installation.
> > 
> > We will introduce this CD-ROM on NET&COM 2004(Feb.4-6) at Tokyo.
> > 
> > Jean-Michel POURE <jm@poure.com> wrote:
> > > Dear friends,
> > > 
> > > In the past, there were several discussions in order to find suitable answers 
> > > for MS Windows users willing to install and run PostgreSQL.
> > > 
> > > Some of you suggested that users should "install GNU/Linux over Windows". Not 
> > > so easy for the basic MySQL or Ms Windows user, who need technical 
> > > assistance ... and fear to destroy their machine.
> > > 
> > > Therefore, I would like to draw some attention on the Morphix CD project from  
> > > http://sourceforge.net/projects/morphix.
> > > 
> > > Morphix is an auto-bootable Debian GNU/Linux distribution based on Knoppix.
> > > 
> > > What makes Morphix different is that the project has several graphical 
> > > installers and wizards in preparation (written in plain C, using GTK-2 
> > > libraries and Glade-2) ... which could possibly be used to install GNU/Linux 
> > > and PostgreSQL tools over MS Windows.
> > > 
> > > You can download a preview CD of Morphix from this address:
> > > http://prdownloads.sourceforge.net/morphix/MorphixCombined-Gnome-0.4-1.iso?download
> > > 
> > > Except for the installer itself, the wizards are not yet available in the main 
> > > Morphix CD. To have a look at them, you will need to checkout from CVS 
> > > (http://cvs.sourceforge.net/viewcvs.py/morphix) and open the files in 
> > > Glade-2.
> > > 
> > > I also made some screenshots here:
> > > 
> > > - morphixinstaller: once Morphix has booted in demo mode, you can use this 
> > > wizard to install Morphix on the disk. Screenshots:
> > > http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step1.png
> > > http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step2.png
> > > http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step3.png
> > > http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step4.png
> > > http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step5.png
> > > http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step6.png
> > > http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step7.png
> > > 
> > > - isomorphgui: graphical distribution maker (select the requested packages for 
> > > your distribution and burn the ISO). Screenshots:
> > > http://developer.pgadmin.org/jean-michel/morphix/iso_morph_gui_1.png
> > > http://developer.pgadmin.org/jean-michel/morphix/iso_morph_gui_2.png
> > > 
> > > - partitionmorpher: resize partitions on the fly (GTK-2 interface to 
> > > libparted). Screenshots:
> > > http://developer.pgadmin.org/jean-michel/morphix/partition_morpher_1.png
> > > http://developer.pgadmin.org/jean-michel/morphix/partition_morpher_2.png
> > > 
> > > IMHO opinion, there is a need to study the Morphix project in more details.
> > > 
> > > Morphix could be a possible solution to the MS Windows migration problems. It 
> > > probably involves 50 times less work than migrating PostgreSQL to MS Windows 
> > > (and is a complete different project except for the fact that it could well 
> > > bring as much new users to PostgreSQL than a native Win port and is less 
> > > risky).
> > > 
> > > The possible steps for such a project could be (just a guess):
> > > 
> > > 1) Validate Morphixinstaller, isomorphgui and partitionmorpher wizards. These 
> > > wizards are still in early stages of development. They are developed by one 
> > > person, who would probably like to receive some help.
> > > 
> > > 2) Create a wizard for PostgreSQL post-installation steps using GTK-2 and 
> > > Glade-2: configuration of hosts and authentication, tuning and optimization 
> > > of various parameters (Mainly a graphical interface to pg_hba.conf and 
> > > postgresql.conf).
> > > 
> > > 3) Gather all known PostgreSQL related Debian packages, including pgAdmin III, 
> > > PhpPgAdmin, as well as PHP, Apache and report tools (and much more) and burn 
> > > Morphix-PostgreSQL CDs.
> > > 
> > > There could be a "light PostgreSQL CD" as well as a "complete PostgreSQL CD".
> > > 
> > > 4) Create a single website in 30 languages (http://installer.postgresql.org?) 
> > > dedicated to releasing the installation CD.
> > > 
> > > Based on the pgAdmin experience, there could well be more than 50.000 
> > > downloads every month, out of which 70% would be migrating from MS Windows to 
> > > GNU/Linux.
> > > 
> > > Comments and ideas are welcome. I would like to help anyone interested in 
> > > becoming the lead of such a project.
> > > 
> > > Best regards,
> > > 
> > > 
> > > 
> > > 
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 7: don't forget to increase your free space map settings
> > > 
> > 
> > 
> > -- 
> > NAGAYASU Satoshi <snaga@snaga.org>
> > 
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> > 
> >                http://www.postgresql.org/docs/faqs/FAQ.html
> > 
> 
> 
> -- 
> NAGAYASU Satoshi <snaga@snaga.org>
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


23 Jan 2004 08:14:17 -0500
Robert Treat <xzilla@users.sourceforge.net>
Re: [HACKERS] PostgreSQL installation CD based on
Robert, Satoshi,

> What do people think about putting an .iso of this on the postgresql ftp
> server and/or the sourceforge site?

I really, really, really want this CD for OSCON and LinuxWorld this summer.   
Can we put an ISO up somewhere?  Please? Please?

I'd be happy to have it on a postgresql.org site, but Marc will have to speak 
to the bandwidth issues.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


Fri, 23 Jan 2004 09:25:26 -0800
Josh Berkus <josh@agliodbs.com>
Re: [HACKERS] PostgreSQL installation CD based on
Josh Berkus wrote:
> I really, really, really want this CD for OSCON and LinuxWorld this
> summer. Can we put an ISO up somewhere?  Please? Please?

Looking at the screenshots, it might be a bit too Japanese for the 
average guy's taste. ;-)

If we want to have a PostgreSQL promotion CD by the summer, we still 
have some time to work on it.  Especially, we might want to have some 
updated software on it.  It looks like we're going to LinuxTag as well 
this year (June), and I'm pulling some strings to get a CD done for 
that, so maybe we could coordinate that with the events in North 
America.


Fri, 23 Jan 2004 18:38:33 +0100
Peter Eisentraut <peter_e@gmx.net>
Re: [HACKERS] PostgreSQL installation CD based on
Maybe this is a good time to tell you that No Starch Press (I forgot to 
mention it) said there would be no problem using their knoppix CD that I 
told you guys about earlier this month.


Robert


Peter Eisentraut wrote:

>Josh Berkus wrote:
>  
>
>>I really, really, really want this CD for OSCON and LinuxWorld this
>>summer. Can we put an ISO up somewhere?  Please? Please?
>>    
>>
>
>Looking at the screenshots, it might be a bit too Japanese for the 
>average guy's taste. ;-)
>
>If we want to have a PostgreSQL promotion CD by the summer, we still 
>have some time to work on it.  Especially, we might want to have some 
>updated software on it.  It looks like we're going to LinuxTag as well 
>this year (June), and I'm pulling some strings to get a CD done for 
>that, so maybe we could coordinate that with the events in North 
>America.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
>  
>


Fri, 23 Jan 2004 12:46:18 -0500
Robert Bernier <robert.bernier5@sympatico.ca>
Re: [HACKERS] PostgreSQL installation CD based on
On Fri, 23 Jan 2004, Josh Berkus wrote:

> Robert, Satoshi,
>
> > What do people think about putting an .iso of this on the postgresql ftp
> > server and/or the sourceforge site?
>
> I really, really, really want this CD for OSCON and LinuxWorld this summer.
> Can we put an ISO up somewhere?  Please? Please?
>
> I'd be happy to have it on a postgresql.org site, but Marc will have to speak
> to the bandwidth issues.

how big is it?

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Fri, 23 Jan 2004 14:04:13 -0400 (AST)
"Marc G. Fournier" <scrappy@postgresql.org>
Re: [HACKERS] PostgreSQL installation CD based on


Peter Eisentraut <peter_e@gmx.net> wrote:
> Josh Berkus wrote:
> > I really, really, really want this CD for OSCON and LinuxWorld this
> > summer. Can we put an ISO up somewhere?  Please? Please?
> 
> Looking at the screenshots, it might be a bit too Japanese for the 
> average guy's taste. ;-)

Yes. It is based on Japanized-KNOPPIX and it includes localized
applicaitons for our language-environment.
This CD-ROM will be published to promote in Japan. :)

> If we want to have a PostgreSQL promotion CD by the summer, we still 
> have some time to work on it.  Especially, we might want to have some 
> updated software on it.  It looks like we're going to LinuxTag as well 
> this year (June), and I'm pulling some strings to get a CD done for 
> that, so maybe we could coordinate that with the events in North 
> America.

Building PostgreSQL-KNOPPIX is not so difficult for me, and  I can
provide an experimental iso in a few days.
Does anyone want to evaluate it?

But I also want to learn more about Morphix because its screenshots are
cool. :)

-- 
NAGAYASU Satoshi <snaga@snaga.org>


Sat, 24 Jan 2004 08:17:03 +0900
Satoshi Nagayasu <snaga@snaga.org>
Re: [HACKERS] PostgreSQL installation CD based on
How about BitTorrent?
http://bitconjurer.org/BitTorrent/

I'm using BitTorrent to distribute large iso files.
I like this P2P software.

"Marc G. Fournier" <scrappy@postgresql.org> wrote:
> On Fri, 23 Jan 2004, Josh Berkus wrote:
> 
> > Robert, Satoshi,
> >
> > > What do people think about putting an .iso of this on the postgresql ftp
> > > server and/or the sourceforge site?
> >
> > I really, really, really want this CD for OSCON and LinuxWorld this summer.
> > Can we put an ISO up somewhere?  Please? Please?
> >
> > I'd be happy to have it on a postgresql.org site, but Marc will have to speak
> > to the bandwidth issues.
> 
> how big is it?
> 
> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 


-- 
NAGAYASU Satoshi <snaga@snaga.org>


Sat, 24 Jan 2004 08:17:17 +0900
Satoshi Nagayasu <snaga@snaga.org>
Re: [HACKERS] PostgreSQL installation CD based on

Definitely is an option ... we already have the server running for it ...

On Sat, 24 Jan 2004, Satoshi Nagayasu wrote:

> How about BitTorrent?
> http://bitconjurer.org/BitTorrent/
>
> I'm using BitTorrent to distribute large iso files.
> I like this P2P software.
>
> "Marc G. Fournier" <scrappy@postgresql.org> wrote:
> > On Fri, 23 Jan 2004, Josh Berkus wrote:
> >
> > > Robert, Satoshi,
> > >
> > > > What do people think about putting an .iso of this on the postgresql ftp
> > > > server and/or the sourceforge site?
> > >
> > > I really, really, really want this CD for OSCON and LinuxWorld this summer.
> > > Can we put an ISO up somewhere?  Please? Please?
> > >
> > > I'd be happy to have it on a postgresql.org site, but Marc will have to speak
> > > to the bandwidth issues.
> >
> > how big is it?
> >
> > ----
> > Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> > Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> >
>
>
> --
> NAGAYASU Satoshi <snaga@snaga.org>
>
>

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Fri, 23 Jan 2004 19:18:15 -0400 (AST)
"Marc G. Fournier" <scrappy@postgresql.org>
Re: [HACKERS] PostgreSQL installation CD based on
Jean-Michel,

> Morphix is an auto-bootable Debian GNU/Linux distribution based on Knoppix.
>
> What makes Morphix different is that the project has several graphical
> installers and wizards in preparation (written in plain C, using GTK-2
> libraries and Glade-2) ... which could possibly be used to install
> GNU/Linux and PostgreSQL tools over MS Windows.

Nice idea, but the Japanese PostgreSQL User's Group has already stolen a march 
on you.  They have a Knoppix distribution with PostgreSQL, phpPgAdmin, 
PGAdminIII, phpBB and Linux+KDE already built ... we just need to get it 
localized to English.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

Fri, 23 Jan 2004 17:47:21 -0800
Josh Berkus <josh@agliodbs.com>
Re: [pgsql-advocacy] PostgreSQL installation CD based on Morphix
OK.
I've started working on the PostgreSQL-KNOPPIX English version.

Could anyone tell me postgresql related events schedule?
Are OSCON(June, Portland) and LinuxWorld(August, San Francisco) nearest?

Josh Berkus <josh@agliodbs.com> wrote:
> Jean-Michel,
> 
> > Morphix is an auto-bootable Debian GNU/Linux distribution based on Knoppix.
> >
> > What makes Morphix different is that the project has several graphical
> > installers and wizards in preparation (written in plain C, using GTK-2
> > libraries and Glade-2) ... which could possibly be used to install
> > GNU/Linux and PostgreSQL tools over MS Windows.
> 
> Nice idea, but the Japanese PostgreSQL User's Group has already stolen a march 
> on you.  They have a Knoppix distribution with PostgreSQL, phpPgAdmin, 
> PGAdminIII, phpBB and Linux+KDE already built ... we just need to get it 
> localized to English.
> 
> -- 
> Josh Berkus
> Aglio Database Solutions
> San Francisco
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 


-- 
NAGAYASU Satoshi <snaga@snaga.org>


Sat, 24 Jan 2004 12:17:29 +0900
Satoshi Nagayasu <snaga@snaga.org>
Re: [pgsql-advocacy] PostgreSQL installation CD based on Morphix
On Sat, 24 Jan 2004, Satoshi Nagayasu wrote:

> OK.
> I've started working on the PostgreSQL-KNOPPIX English version.

Satoshi ... Robert Bernier just reminded me that we currently have an
English version sitting in our office ... Of course, I don't have it here
with me, but maybe Robert can comment on what is on it before u spend alot
of time recreating it?  It might be something you two can collaborate on,
if it doesn't contain everything your Japanese version already does?


----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Fri, 23 Jan 2004 23:40:28 -0400 (AST)
"Marc G. Fournier" <scrappy@postgresql.org>
Re: [pgsql-advocacy] PostgreSQL installation CD based on Morphix
Oops. Sorry I missed that thread.
(Because I was working on my master thesis...)

I'll read the past msgs before coming back this topic.

"Marc G. Fournier" <scrappy@postgresql.org> wrote:
> On Sat, 24 Jan 2004, Satoshi Nagayasu wrote:
> 
> > OK.
> > I've started working on the PostgreSQL-KNOPPIX English version.
> 
> Satoshi ... Robert Bernier just reminded me that we currently have an
> English version sitting in our office ... Of course, I don't have it here
> with me, but maybe Robert can comment on what is on it before u spend alot
> of time recreating it?  It might be something you two can collaborate on,
> if it doesn't contain everything your Japanese version already does?
> 
> 
> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
> 


-- 
NAGAYASU Satoshi <snaga@snaga.org>


Sat, 24 Jan 2004 12:55:38 +0900
Satoshi Nagayasu <snaga@snaga.org>
Re: [pgsql-advocacy] PostgreSQL installation CD based on Morphix
I've read past thread and I know about new book from No Starch Press.

Now, I need some comments about applications which should be included in
such LiveCD.  Which application is appealing for PostgreSQL promotions
or demonstrations?

Or which kind of applications (admin tools, middleware, languages, user
apps) should be included?

Any suggestions or recommendations?

No Starch Press's KNOPPIX includes all of server-side stuffs, pgAdmin3
and pgaccess. Right?


Satoshi Nagayasu <snaga@snaga.org> wrote:
> Oops. Sorry I missed that thread.
> (Because I was working on my master thesis...)
> 
> I'll read the past msgs before coming back this topic.
> 
> "Marc G. Fournier" <scrappy@postgresql.org> wrote:
> > On Sat, 24 Jan 2004, Satoshi Nagayasu wrote:
> > 
> > > OK.
> > > I've started working on the PostgreSQL-KNOPPIX English version.
> > 
> > Satoshi ... Robert Bernier just reminded me that we currently have an
> > English version sitting in our office ... Of course, I don't have it here
> > with me, but maybe Robert can comment on what is on it before u spend alot
> > of time recreating it?  It might be something you two can collaborate on,
> > if it doesn't contain everything your Japanese version already does?
> > 
> > 
> > ----
> > Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> > Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
> > 
> 
> 
> -- 
> NAGAYASU Satoshi <snaga@snaga.org>
> 


-- 
NAGAYASU Satoshi <snaga@snaga.org>


Sat, 24 Jan 2004 13:59:34 +0900
Satoshi Nagayasu <snaga@snaga.org>
Re: [pgsql-advocacy] PostgreSQL installation CD based on Morphix
Satoshi,

The postgres, knoppix CD that I created last summer was compiled to work 
with plpgsql, plperl(u), plpythonu, pltcl(u). It has ODBC and JDBC 
drivers compiled into it too: I had some problems with Java initially 
but overcame it after I tinkered with the ant startup script.

I recompiled the kernel to get the 'elephant' (does it have a name??) 
icon rather than 'tux' in the frame buffer as it booted up, I also 
changed the knoppix bootup background to that of a picture of a huge 
looking elephant. The desktop was redesigned to offer full documentation 
references using konquorer (html and pdf). The desktop also includes 
links to pgadmin3 and pgaccess. A link was installed that would invoke 
psql straight into the sample databases that I had included.

The trick to making postgres work on the CD was quite trivial, I edited 
the init script to identify if it was reading itself off a CD 
installation and subsequently copied the entire database cluster over to 
the virtual drive. The postgres server also works after its been 
committed to the PC harddrive too using the knoppix hdinstall script.

You will find a detailed article that I wrote on how to create a knoppix 
CD at the orielly site, 
http://linux.oreillynet.com/pub/a/linux/2003/11/20/knoppix.html . There 
are also references made to it off the knoppix users site and the linux 
show, 
http://www2.thelinuxshow.com/archives/2003/upcoming-2003-11-25.html 
among others. The article was rated by O'Reilly as among its top 5 for 
the month of November.

The book's publishing date has been scheduled for late spring/early 
summer so I had always planned to going back and updating the CD such as 
maybe including pl/r.

It became apparent that a postgres CD would be quite useful at OSCON 
since "No Starch Press" and O'Reilly have an existing business 
relationship. Since I already write for O'Reilly I thought  would be 
interesting to see if I could kill several birds with one stone.

regards


Robert


Satoshi Nagayasu wrote:

>I've read past thread and I know about new book from No Starch Press.
>
>Now, I need some comments about applications which should be included in
>such LiveCD.  Which application is appealing for PostgreSQL promotions
>or demonstrations?
>
>Or which kind of applications (admin tools, middleware, languages, user
>apps) should be included?
>
>Any suggestions or recommendations?
>
>No Starch Press's KNOPPIX includes all of server-side stuffs, pgAdmin3
>and pgaccess. Right?
>
>
>Satoshi Nagayasu <snaga@snaga.org> wrote:
>  
>
>>Oops. Sorry I missed that thread.
>>(Because I was working on my master thesis...)
>>
>>I'll read the past msgs before coming back this topic.
>>
>>"Marc G. Fournier" <scrappy@postgresql.org> wrote:
>>    
>>
>>>On Sat, 24 Jan 2004, Satoshi Nagayasu wrote:
>>>
>>>      
>>>
>>>>OK.
>>>>I've started working on the PostgreSQL-KNOPPIX English version.
>>>>        
>>>>
>>>Satoshi ... Robert Bernier just reminded me that we currently have an
>>>English version sitting in our office ... Of course, I don't have it here
>>>with me, but maybe Robert can comment on what is on it before u spend alot
>>>of time recreating it?  It might be something you two can collaborate on,
>>>if it doesn't contain everything your Japanese version already does?
>>>      
>>>


Sat, 24 Jan 2004 08:31:27 -0500
Robert Bernier <robert.bernier5@sympatico.ca>
Re: [pgsql-advocacy] PostgreSQL installation CD based on Morphix
On Sat, 24 Jan 2004, Robert Bernier wrote:

> I recompiled the kernel to get the 'elephant' (does it have a name??)

Slonik ...


----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

Sat, 24 Jan 2004 11:57:06 -0400 (AST)
"Marc G. Fournier" <scrappy@postgresql.org>
Re: [pgsql-advocacy] PostgreSQL installation CD based on Morphix
Le Samedi 24 Janvier 2004 02:47, Josh Berkus a écrit :
> Nice idea, but the Japanese PostgreSQL User's Group has already stolen a
> march on you.  They have a Knoppix distribution with PostgreSQL,
> phpPgAdmin, PGAdminIII, phpBB and Linux+KDE already built ... we just need
> to get it localized to English.

Dear Josh,

In my e-mail, I wanted to ring a bell that, it could prove usefull to invest 
time into studying Morphix installation tools.

Morphix = Knoppix + graphical installation tools
Morphix = Debian + graphical installation tools + direct boot for demo

Most users, coming from MS Windows or MySQL, have no idea:
1) How to install a Debian distribution,
2) How to configure PostgreSQL for a first connection.

A possible solution could be to:
1) Validate Morphix wizards, which are still alpha.
2) Create PostgreSQL installation/configuration wizards (Glade-2 + GTK2).

This involves programming, not only marketing. For some PostgreSQL gurus, 
these programming steps could be a matter of weeks.

Cheers, Jean-Michel

*******************
Screenshots from Morphix wizards (which make Morphix different from Knoppix):

- morphixinstaller: once Morphix has booted in demo mode, you can use this 
wizard to install Morphix on the disk. Screenshots:
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step1.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step2.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step3.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step4.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step5.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step6.png
http://developer.pgadmin.org/jean-michel/morphix/morphix_installer_step7.png

- isomorphgui: graphical distribution maker (select the requested packages for 
your distribution and burn the ISO). Screenshots:
http://developer.pgadmin.org/jean-michel/morphix/iso_morph_gui_1.png
http://developer.pgadmin.org/jean-michel/morphix/iso_morph_gui_2.png

- partitionmorpher: resize partitions on the fly (GTK-2 interface to 
libparted). Screenshots:
http://developer.pgadmin.org/jean-michel/morphix/partition_morpher_1.png
http://developer.pgadmin.org/jean-michel/morphix/partition_morpher_2.png

Cheers,
Jean-Michel Pouré


Sun, 25 Jan 2004 12:16:19 +0100
Jean-Michel POURE <jm@poure.com>
Re: PostgreSQL installation CD based on Morphix