Re: pg_xlog question

Why not
DRDB the whole Postgres file system (possibly multiple disks) and let
WAL recovery take care, of uncommitted transactions at db startup time.

Shridhar Daithankar wrote:

>On 6 Aug 2003 at 9:56, Mario Weilguni wrote:
>
>
>>Thanks for the response, but syncing pg_xlog separatly (without DRBD device)
>>is useless, because a failover will take place when there's an error, so the
>>extra sync of pg_xlog is very likely to fail.
>>
>>
>
>Well, I googled for DRBD device. I was unfamiliar with the device.
>
>I would say it should work if data and transaction logs both of them are
>mirrored. But of course you need to test.
>
>If you could write a HOWTO, that would be real great..
>
>
>Bye
> Shridhar
>
>--
> "We have the right to survive!" "Not by killing others." -- Deela and Kirk,
>"Wink of An Eye", stardate 5710.5
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
>
>