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

2004-01-24 Thread Josh Berkus
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


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

2004-01-24 Thread Satoshi Nagayasu
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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


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

2004-01-24 Thread Satoshi Nagayasu
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.
> > 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: [EMAIL PROTECTED]   Yahoo!: yscrappy  ICQ: 7615664
> 


-- 
NAGAYASU Satoshi <[EMAIL PROTECTED]>


---(end of broadcast)---
TIP 8: explain analyze is your friend


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

2004-01-24 Thread Satoshi Nagayasu
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.
> > > 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: [EMAIL PROTECTED]   Yahoo!: yscrappy  ICQ: 7615664
> > 
> 
> 
> -- 
> NAGAYASU Satoshi <[EMAIL PROTECTED]>
> 


-- 
NAGAYASU Satoshi <[EMAIL PROTECTED]>


---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [pgadmin-hackers] [pgsql-advocacy] PostgreSQL installation CD

2004-01-24 Thread andrej misovic
hello,
I think, that versions in other langs should be also interested..
what you think about that?
		andrej

Satoshi Nagayasu wrote:
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 <[EMAIL PROTECTED]> 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



--

  >>  jabber: [EMAIL PROTECTED]   <<
  >>  e-mail: [EMAIL PROTECTED]  <<

// just visit> http://www.nirvanaclub.sk


--

  >>  jabber: [EMAIL PROTECTED]   <<
  >>  e-mail: [EMAIL PROTECTED]  <<

// just visit> http://www.nirvanaclub.sk


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faqs/FAQ.html


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

2004-01-24 Thread Robert Bernier
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 <[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.
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?
 



---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
 joining column's datatypes do not match


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

2004-01-24 Thread Marc G. Fournier
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: [EMAIL PROTECTED]   Yahoo!: yscrappy  ICQ: 7615664

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