Re: Read-only postgres instance

From: Vladimir Protasov <eoranged(at)ya(dot)ru>
To: pgsql-admin(at)postgresql(dot)org,Kevin Grittner <kevin(dot)grittner(at)wicourts(dot)gov>
Subject: Re: Read-only postgres instance
Date: 2011-08-09 17:11:34
Message-ID: 49881312909894@web20.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

09.08.2011, 20:52, "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>:
> 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?
Looks like what I've looked for.
Thanks.
>
> -Kevin

--
Best regards,
Vladimir Protasov.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message pasman pasmański 2011-08-09 17:19:21 Re: Read-only postgres instance
Previous Message iliya g 2011-08-09 16:58:04 Re: Postgres process