pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRead-only postgres instance
5+ messages / 4 participants
[nested] [flat]
* Read-only postgres instance
@ 2011-08-05 08:16 Vladimir Protasov <eoranged@ya.ru>
2011-08-09 16:52 ` Re: Read-only postgres instance Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-08-09 17:19 ` Re: Read-only postgres instance pasman pasmański <pasman.p@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Vladimir Protasov @ 2011-08-05 08:16 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Read-only postgres instance
2011-08-05 08:16 Read-only postgres instance Vladimir Protasov <eoranged@ya.ru>
@ 2011-08-09 16:52 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-08-09 17:11 ` Re: Read-only postgres instance Vladimir Protasov <eoranged@ya.ru>
1 sibling, 1 reply; 5+ messages in thread
From: Kevin Grittner @ 2011-08-09 16:52 UTC (permalink / raw)
To: pgsql-admin; Vladimir Protasov <eoranged@ya.ru>
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Read-only postgres instance
2011-08-05 08:16 Read-only postgres instance Vladimir Protasov <eoranged@ya.ru>
2011-08-09 16:52 ` Re: Read-only postgres instance Kevin Grittner <Kevin.Grittner@wicourts.gov>
@ 2011-08-09 17:11 ` Vladimir Protasov <eoranged@ya.ru>
0 siblings, 0 replies; 5+ messages in thread
From: Vladimir Protasov @ 2011-08-09 17:11 UTC (permalink / raw)
To: pgsql-admin@postgresql.org,Kevin Grittner <kevin.grittner@wicourts.gov>
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Read-only postgres instance
2011-08-05 08:16 Read-only postgres instance Vladimir Protasov <eoranged@ya.ru>
@ 2011-08-09 17:19 ` pasman pasmański <pasman.p@gmail.com>
2011-08-09 17:30 ` Re: Read-only postgres instance Scott Ribe <scott_ribe@elevated-dev.com>
1 sibling, 1 reply; 5+ messages in thread
From: pasman pasmański @ 2011-08-09 17:19 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Read-only postgres instance
2011-08-05 08:16 Read-only postgres instance Vladimir Protasov <eoranged@ya.ru>
2011-08-09 17:19 ` Re: Read-only postgres instance pasman pasmański <pasman.p@gmail.com>
@ 2011-08-09 17:30 ` Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 5+ messages in thread
From: Scott Ribe @ 2011-08-09 17:30 UTC (permalink / raw)
To: pasman pasmański <pasman.p@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2011-08-09 17:30 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-08-05 08:16 Read-only postgres instance Vladimir Protasov <eoranged@ya.ru>
2011-08-09 16:52 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-08-09 17:11 ` Vladimir Protasov <eoranged@ya.ru>
2011-08-09 17:19 ` pasman pasmański <pasman.p@gmail.com>
2011-08-09 17:30 ` Scott Ribe <scott_ribe@elevated-dev.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox