Re: Read-only postgres instance

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-admin(at)postgresql(dot)org>,"Vladimir Protasov" <eoranged(at)ya(dot)ru>
Subject: Re: Read-only postgres instance
Date: 2011-08-09 16:52:00
Message-ID: 4E411F60020000250003FCD3@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Vladimir Protasov <eoranged(at)ya(dot)ru> wrote:

> I want to completely disallow postgres to write WAL and turn it to
> read-only instance WAL-compatible with another instance.
> It is guarantied that there will be no write queries to the
> server, but I need to be sure about WAL.

Have you considered setting it up as a hot standby, but then not
feeding it a WAL stream?

-Kevin

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message iliya g 2011-08-09 16:58:04 Re: Postgres process
Previous Message Raghavendra 2011-08-09 16:38:04 Re: Postgres process