Re: WAL to RAW devices ? - Mailing list pgsql-general

From Tom Lane
Subject Re: WAL to RAW devices ?
Date
Msg-id 3703.1188602478@sss.pgh.pa.us
Whole thread Raw
In response to WAL to RAW devices ?  (Alex Vinogradovs <AVinogradovs@clearpathnet.com>)
Responses Re: WAL to RAW devices ?  (Alex Vinogradovs <AVinogradovs@Clearpathnet.com>)
List pgsql-general
Alex Vinogradovs <AVinogradovs@clearpathnet.com> writes:
>  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.

Why would you insist on these being raw devices?  Do you enjoy writing
filesystems from scratch?

            regards, tom lane

pgsql-general by date:

Previous
From: Alex Vinogradovs
Date:
Subject: WAL to RAW devices ?
Next
From: Alex Vinogradovs
Date:
Subject: Re: WAL to RAW devices ?