WAL to RAW devices ?

From: Alex Vinogradovs <AVinogradovs(at)clearpathnet(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: WAL to RAW devices ?
Date: 2007-08-31 22:46:56
Message-ID: 1188600416.6082.44.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi guys,

I've got a bunch of PosgreSQL servers connected to external storage,
where a single server needs to be serving as WO database dealing with
INSERTs only, and bunch of other guys need to obtain a copy of that
data for RO serving, without taking resources on WO server.
The idea is to have say 2 raw devices which would be used as 2 WAL
segments (round-robin). RO servers will go after the one that's not used
at a given time with something like xlogdump utility and produce INSERT
statements to be then executed locally. After that import is done, a
command will be issued to the WO server to switch to the other segment
so that the cycle can repeat.
The objective of that replication model is to ensure that SELECT
queries won't ever affect the performance of the WO server,
which may experience uneven loads.

Is that possible with the 8.2.4 or 8.3 capabilities, or maybe with
minor modifications ?

Thanks!

Best regards,
Alex Vinogradovs

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-08-31 23:21:18 Re: WAL to RAW devices ?
Previous Message Anton Melser 2007-08-31 22:32:39 Re: URGENT: Whole DB down ("no space left on device")