[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)