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..
ByeShridhar
--"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
