Re: [pgsql-advocacy] PostgreSQL installation CD based on Morphix - Mailing list pgadmin-hackers

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