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 <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> wrote:
On Sat, 24 Jan 2004, Satoshi Nagayasu wrote:
OK.Satoshi ... Robert Bernier just reminded me that we currently have an
I've started working on the PostgreSQL-KNOPPIX English version.
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?
---------------------------(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
