Re: Postgresql DB on a live cd - Mailing list pgsql-admin

From Ron Mayer
Subject Re: Postgresql DB on a live cd
Date
Msg-id 3FBC7DA1.3000209@cheapcomplexdevices.com
Whole thread Raw
In response to Postgresql DB on a live cd  (Lucio <luke@iond.it>)
List pgsql-admin
Lucio wrote:
> Hi,
>
> I'am trying to create a demo cd (knoppix) with a jdbc application.
>
> This application uses a static (read-only, no insert, modify or delete) 200MB
> postgresql db, so can't put pgsql/data/base and pgsql/data/pg_xlog in ramdisk.

One thing I don't think I saw mentioned yet....
I think some large sorts and temporary tables also use  ..../base/[whatevernumber]/pgsql_tmp
so you probably want to make that a symlink to something on the ramdisk
as well.

pgsql-admin by date:

Previous
From: rm_pg@cheapcomplexdevices.com
Date:
Subject: cancel <3FBC7DA1.3000209@cheapcomplexdevices.com>
Next
From: Ron Mayer
Date:
Subject: Re: Postgresql DB on a live cd