Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group