Thread: 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. ____________