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 5B6F8DA95B for ; Fri, 21 Oct 2005 13:30:38 -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 19543-02 for ; Fri, 21 Oct 2005 16:30:36 +0000 (GMT) Received: from ydl01.graphics (unknown [65.115.205.152]) by svr1.postgresql.org (Postfix) with ESMTP id 3F127DA912 for ; Fri, 21 Oct 2005 13:30:36 -0300 (ADT) Received: from [90.0.0.9] (wlst-wireless-static-012.wmtel.net [207.177.38.109]) by ydl01.graphics (vPostMaster) with ESMTP id 944CAFF806 for ; Fri, 21 Oct 2005 11:18:17 -0500 (CDT) Message-ID: <43591734.8070202@mcmurrayhatchery.com> Date: Fri, 21 Oct 2005 11:28:36 -0500 From: Kirby Ubben User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Replication Solutions for PostgreSQL Master to Slave X-Enigmail-Version: 0.92.0.0 OpenPGP: id=04034A01 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200510/239 X-Sequence-Number: 19311 -----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. 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? Thanks in advance, k. - -- Kirby Ubben Systems Engineer McMurray Hatchery kirby@mcmurrayhatchery.com 1 515 832 1235 ext 201 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDWRc0thkzRAQDSgERAhSrAJ9Ax5nwDMlOUiRw8jcczmU7PJo8LgCeMf3a gIFKb7oH7+4zuAEZyQYowh0= =CIAC -----END PGP SIGNATURE-----