Thread: Read-only postgres instance

Read-only postgres instance

From
Vladimir Protasov
Date:
Hi, guys!
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.

Is it possible?

--
Best regards,
Vladimir Protasov.

Re: Read-only postgres instance

From
"Kevin Grittner"
Date:
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

Re: Read-only postgres instance

From
pasman pasmański
Date:
What with queries need temporary tables?

2011/8/5, Vladimir Protasov <eoranged@ya.ru>:
> Hi, guys!
> 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.
>
> Is it possible?
>
> --
> Best regards,
> Vladimir Protasov.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>


--
------------
pasman

Re: Read-only postgres instance

From
Scott Ribe
Date:
Creating a temp table is not a read-only operation.

On Aug 9, 2011, at 11:19 AM, pasman pasmański wrote:

> What with queries need temporary tables?


--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





Re: Read-only postgres instance

From
Vladimir Protasov
Date:

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.