Andrew Sullivan <[EMAIL PROTECTED]> writes: > On Wed, Jun 27, 2007 at 10:12:31AM +0800, Dewi Andriyanti wrote: >> I intend to build a replication system via VPN using Slony but I need more >> reference. Is Slony good in data integrity, consistency, reliability and >> response time? Is Slony better than PGCluster? What is drawbacks of Slony? >> Would anybody help me to share stable configuration for replication system >> via VPN using Slony? > > What's the bandwidth available inside the VPN? You need to make sure > you can propagate the changes fast enough. I don't believe PGCluster > can work over wide areas -- I think it has to be local.
I haven't seen any discussion of PGCluster in a while; the thing that has been discussed a lot more of late has been PGCluster-2. That's a system which shares parts of PostgreSQL shared memory across the network; I would expect that to perform extraordinarily badly across a WAN. If PGCluster uses a similar architecture, then the same would presumably be true. I'm not sure they are identical that way, though... -- select 'cbbrowne' || '@' || 'ca.afilias.info'; <http://dba2.int.libertyrms.com/> Christopher Browne (416) 673-4124 (land) _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
