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

From Vladimir Protasov
Subject Re: Read-only postgres instance
Date
Msg-id 49881312909894@web20.yandex.ru
Whole thread Raw
In response to Re: Read-only postgres instance  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin

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

--
Best regards,
Vladimir Protasov.

pgsql-admin by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Frequency of archive_cleanup_command
Next
From: Mridul Mathew
Date:
Subject: Re: FW: Character set equivalent for AL32UTF8