Re: can disks be read only?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mikeo <mikeo(at)spectrumtelecorp(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: can disks be read only?
Date: 2000-07-25 21:43:24
Message-ID: 8197.964561404@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

mikeo <mikeo(at)spectrumtelecorp(dot)com> writes:
> we wish to have a database that is history so we
> want to make the disks read only after loading.
> would this cause any problems with POSTGRES?

In theory you could do it given that you vacuum the tables
before locking down the files. (The vacuum is needed to
ensure that on-row commit status bits are up to date.)

In practice you'd likely have problems with the minor detail
that md.c opens everything with O_RDWR privilege requests.
You could probably do a quick hack to try O_RDONLY if
O_RDWR fails...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ryan 2000-07-25 21:43:52 Re: nested transactions
Previous Message Ian Turner 2000-07-25 21:18:18 Re: function language type?