Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Storing database in WORM devices

From: <GGoshen(at)axsone(dot)com>
To: <doug(at)mcnaught(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [GENERAL] Storing database in WORM devices
Date: 2005-05-11 19:31:55
Message-ID: E8C21173A4ACCF48BEAB8DA3ABE46F24093806@mailsrv1.ctronsoft.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
Why? Any specific reason that you are aware of ?
Are there any writes done to the database when read only SQL statements are issued?  


-----Original Message-----
From: Douglas McNaught [mailto:doug(at)mcnaught(dot)org]
Sent: Wednesday, May 11, 2005 2:51 PM
To: Goshen, Galit
Cc: pgsql-general(at)postgresql(dot)org; pgsql-admin(at)postgresql(dot)org
Subject: Re: [GENERAL] Storing database in WORM devices


<GGoshen(at)axsone(dot)com> writes:

> I would like to store the complete database into a WORM device (Write Once
> Read Many). I would like to access this database directly from the WORM
> device and perform read only SQL statements against this device.
>  
> Does anyone have such installation, or can determine if this is possible?

AFAIK Postgres will not currently run on a read-only filesystem.

-Doug

Responses

pgsql-admin by date

Next:From: Alex TurnerDate: 2005-05-11 19:41:21
Subject: Re: [GENERAL] Storing database in WORM devices
Previous:From: Douglas McNaughtDate: 2005-05-11 18:51:12
Subject: Re: [GENERAL] Storing database in WORM devices

pgsql-general by date

Next:From: Alex TurnerDate: 2005-05-11 19:41:21
Subject: Re: [GENERAL] Storing database in WORM devices
Previous:From: Douglas McNaughtDate: 2005-05-11 18:51:12
Subject: Re: [GENERAL] Storing database in WORM devices

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group