Mounting a data dir read only

From: Thorsten Körner <t(dot)koerner(at)cappuccinosoft(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Mounting a data dir read only
Date: 2007-01-16 15:35:24
Message-ID: 200701161635.24603.t.koerner@cappuccinosoft.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I'm wondering if it is possible to connect a postgresql 8.2 server to a
datadir in readonly mode.
We actually want to implement a very large project, using postgresql database,
with pgpool. Our idea is, that one postgres instance, can read/write to the
files, while the other one should only read.
To avoid corruption, we want to set the second instance to read-only mode.

Is there a way to set such parameters, within startup parameters?

with Regards
Thorsten Körner
--
CappuccinoSoft Business Systems
Hamburg

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gellert, Andre 2007-01-16 15:36:34 Re: Need setup help for Postgresql 8.1.3 on Solaris 10
Previous Message Jasbinder Singh Bali 2007-01-16 15:25:56 Re: Dynamic loading of Perl Code in Postgres functions