Обсуждение: Database on read only directory

Hello,

I'm building a database that I would eventually like to store on a read only
medium, such as a CD rom. It would then be accessed for consulting only via a
Java program.

However, from what I understood, PostgreSql needs to write to the database
directory when SELECTing from tables. Is there a simple way to force such write
accesses to a temporary directory ?

Alexandre Fayolle
http://alexandre.fayolle.free.fr

Hi Alexandre,

I was thinking about doing something similar when I get the time (very low
pirority at the moment - may never get done - darn).  I was thinking of taring the
data directory onto the CD-ROM and untaring it into a ram disk to get around the
read-only media.

John

Alexandre Fayolle wrote:

> Hello,
>
> I'm building a database that I would eventually like to store on a read only
> medium, such as a CD rom. It would then be accessed for consulting only via a
> Java program.
>
> However, from what I understood, PostgreSql needs to write to the database
> directory when SELECTing from tables. Is there a simple way to force such write
> accesses to a temporary directory ?
>
> Alexandre Fayolle
> http://alexandre.fayolle.free.fr

--
==============================================================================
"There are no kernel hackers in Ireland. They spend all their time in the pub"
Alan Cox
==============================================================================

On Fri, 6 Aug 1999, Alexandre Fayolle wrote:

    Union filesystem.

# Hello,
#
# I'm building a database that I would eventually like to store on a read only
# medium, such as a CD rom. It would then be accessed for consulting only via a
# Java program.
#
# However, from what I understood, PostgreSql needs to write to the database
# directory when SELECTing from tables. Is there a simple way to force such write
# accesses to a temporary directory ?
#
# Alexandre Fayolle
# http://alexandre.fayolle.free.fr
#
#

--
SA, beyond.com           My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________