X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E9A08DA6C4 for ; Fri, 21 Oct 2005 14:47:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13388-05 for ; Fri, 21 Oct 2005 17:47:08 +0000 (GMT) Received: from mail.travelamericas.com (unknown [206.130.134.147]) by svr1.postgresql.org (Postfix) with SMTP id E73DEDA4A3 for ; Fri, 21 Oct 2005 14:47:05 -0300 (ADT) Received: (qmail 16513 invoked from network); 21 Oct 2005 17:47:05 -0000 Received: from unknown (HELO ?10.0.0.253?) (10.0.0.253) by verkiel.travelamericas.com with SMTP; 21 Oct 2005 17:47:05 -0000 Message-ID: <43592997.2050704@metatrontech.com> Date: Fri, 21 Oct 2005 10:47:03 -0700 From: Chris Travers User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Kirby Ubben Cc: pgsql-admin@postgresql.org Subject: Re: Replication Solutions for PostgreSQL Master to Slave References: <43591734.8070202@mcmurrayhatchery.com> In-Reply-To: <43591734.8070202@mcmurrayhatchery.com> Content-Type: multipart/mixed; boundary="------------040308010408050408070607" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.018 required=5 tests=[AWL=0.018] X-Spam-Level: X-Archive-Number: 200510/242 X-Sequence-Number: 19314 This is a multi-part message in MIME format. --------------040308010408050408070607 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Kirby Ubben wrote: >-----BEGIN PGP SIGNED MESSAGE----- >Hash: SHA1 > > >We have installed a product called Quasar for accounting needs at our >company, which is back ended by PostgreSQL. It is a requirement that >the database is replicated, real time, to a secondary machine and >PostgreSQL database, in case of failure of the first. > > You are looking for synchronous replication as opposed to async? >Currently i have Slony working, but am not satisfied with how it >accomplishes replication, or it's interface, and am curious what >others are using to accomplish replication? > > Well, the two main projects that people are using are: Slony-I (Async, master/slave) PgPool (sync, load balancing possibilities) Best Wishes, Chris Travers Metatron Technology COnsulting --------------040308010408050408070607 Content-Type: text/x-vcard; charset=utf-8; name="chris.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="chris.vcf" begin:vcard fn:Chris Travers n:Travers;Chris email;internet:chris@metatrontech.com x-mozilla-html:FALSE version:2.1 end:vcard --------------040308010408050408070607--