[gtaSAGE-members] pgsql synchronous duplication solution.
Thamer Al-Harbash
tmh@whitefang.com
Mon Mar 24 02:29:00 2003
I've found reasonable methods of doing asynchronous replication
on a pgsql cluster of multiple machines:
http://pgreplicator.sourceforge.net
Or by rolling my own triggers.
I'd like for a way to do synchronous replication so as to keep
the entire cluster active and maintain data integrity across them
atomically. I understand the only real way to do this is via a
wrapper postmaster that attempts the replication across all the
databases and queues anything that cannot make it due to a
temporary failure. Is there any such solution which is in
production state? Or should I just roll my own?
(DBbalancer is still alpha according to sf.net)
--
Thamer Al-Harbash http://www.whitefang.com/
(if (> pressure too-much-pressure)
'play-ac2 'work)