> It listens on port 5432.
> It pools connections to both real databases.
Check out pgsql-replication. They're doing something more complex,
but will get you the multi-master model that you're proposing. It's
using a reliable multicast model based on the spread toolkit
(spread.org).
As for your idea, it sounds really good, but has two pit-falls that I
know of:
1) TCP latency could intorduce race conditions and data syncronization problems.
2) transaction WAL log syncronization.
-sc
--
Sean Chittenden