On Fri, 9 Jan 2004, Alvaro Herrera wrote:
> On Fri, Jan 09, 2004 at 06:52:53AM -0500, Robert Bernier wrote:
> >
> > Peter Eisentraut wrote:
> >
> > >Robert Treat wrote:
> > >
> > >>There have been people on other disks asking about getting knoppix
> > >>flavored distros to carry postgresql for their own demonstrations, I
> > >>think it would be great if someone could put together a distro with
> > >>postgresql, pgadmin, pgaccess, phppgadmin, and maybe a few other tools,
> > >>that could boot from a cd to be handed out for demonstration purposes. I
> > >>won't pretend like it wouldn't be a good sized project to undertake.
> >
> > A knoppix variant with Postgres installed has already been done.
>
> Does it actually run? I thought Postgres was not prepared to run on
> read-only media. It needs a separate PGDATA area, doesn't it?
In theory, you *should* be able to build memory file systems for those
parts that require r/w ... ie. xlog stuff ... but even then, if you don't
do any update/insert/deletes, and just use the database read only, not
sure how "required" that is ... but, all you'd need to do is:
mount_mfs a memory file system
cp the xlog directory to the memory file system
mount_union (or equivalent) back to the xlog directory
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664