Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: WAL to RAW devices ?
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Alex Vinogradovs <AVinogradovs(at)clearpathnet(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: WAL to RAW devices ?
- Date: Fri, 31 Aug 2007 19:21:18 -0400
- Message-id: <3703.1188602478@sss.pgh.pa.us> <text/plain>
Alex Vinogradovs <AVinogradovs(at)clearpathnet(dot)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
- Follow-Ups:
- Re: WAL to RAW devices ?
- From: Alex Vinogradovs
- Re: WAL to RAW devices ?
- References:
- URGENT: Whole DB down ("no space left on device")
- From: Phoenix Kiula
- Re: URGENT: Whole DB down ("no space left on device")
- From: Zoltan Boszormenyi
- Re: URGENT: Whole DB down ("no space left on device")
- From: Josh Tolley
- Re: URGENT: Whole DB down ("no space left on device")
- From: Phoenix Kiula
- Re: URGENT: Whole DB down ("no space left on device")
- From: Jeff Davis
- WAL to RAW devices ?
- From: Alex Vinogradovs
- URGENT: Whole DB down ("no space left on device")
- Prev by Date: WAL to RAW devices ?
- Next by Date: Re: WAL to RAW devices ?
- Previous by thread: WAL to RAW devices ?
- Next by thread: Re: WAL to RAW devices ?
- Indexes: