On Fri, Jan 9, 2009 at 11:32 AM, Gerd König <koe...@transporeon.com> wrote:
> Perhaps we should have a look at > * pg_pool(II) I can only speak of pgpool-II. It's working fine for me in a setup which is exactly the same one you have (change OpenSuse for Debian, but the rest is the same). The thing is that pgpool-II itself can become a single point of failure unless you provide HA for it (I am doing so with Heartbeat), but IMHO that would then be a failover solution, not a multimaster (from pgpool-II's point of view, not the databases behind pgpool-II). Next thing I want to do is try Slony-I with pgpool-II, but I think that is not a multimaster solution either. Of course we may have different points of view on what multimaster mean :) If you plan on using pgpool-II, take into consideration that replication is done at a SQL query level, which is cool, but has its limitations. If you use Slony-I inside pgpool-II I think you can take over those limitations, but the solution is not so... neat, so to speak :) /discuss -- Jaume Sabater http://linuxsilo.net/ "Ubi sapientas ibi libertas" -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin