Re: Postgresql DB on a live cd

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Lucio <luke(at)iond(dot)it>
Subject: Re: Postgresql DB on a live cd
Date: 2003-11-20 08:38:57
Message-ID: 3FBC7DA1.3000209@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Mayer 2003-11-20 08:47:34 Re: Postgresql DB on a live cd
Previous Message Shridhar Daithankar 2003-11-20 07:42:58 Re: Point-in-time data recovery - v.7.4