In addition to that, I would say that first of all, you need to know what you need: Synchronous replication or Asynchronous replication.
Slony-I is Asynchronous Pgpool-II is Synchronous You should not compare Slony-I vs Pgpool-II. Daniel From: pgpool-general-boun...@pgfoundry.org [mailto:pgpool-general-boun...@pgfoundry.org] On Behalf Of Steven Crandell Sent: Thursday, January 07, 2010 3:18 PM To: erobles Cc: pgpool Subject: Re: [Pgpool-general] which is advantage of master/slave mode vsreplication on pgpool-II The details of master/slave vs replication modes are detailed pretty well here: http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html In general, master/slave mode assumes that there is some other replication software involved replicating data from the master to the slaves (slony, mammoth, etc) Replication mode means that pgpool will take care of the replication itself. I'm a big fan of the mammoth replication system so the advantage of master/slave replication mode for me is that I can use pgpool to load balance my queries while still counting on mammoth to handle my replication. I haven't use pgpool in replication mode so I can't speak to any strengths or weaknesses there. It basically comes down to apples vs. oranges. It's two completely different methods to accomplish basically the same thing. -s On Thu, Jan 7, 2010 at 9:15 AM, erobles <erob...@sensacd.com.mx> wrote: hi! like the subjects said, i am interesting on the advantages of pgpool in master/slave mode over replication mode regards! _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
_______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general