Re: Read-only postgres instance - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Read-only postgres instance
Date
Msg-id 4E411F60020000250003FCD3@gw.wicourts.gov
Whole thread Raw
In response to Read-only postgres instance  (Vladimir Protasov <eoranged@ya.ru>)
Responses Re: Read-only postgres instance
List pgsql-admin
Vladimir Protasov <eoranged@ya.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

pgsql-admin by date:

Previous
From: Raghavendra
Date:
Subject: Re: Postgres process
Next
From: iliya g
Date:
Subject: Re: Postgres process