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 27C2ADA4A3 for ; Fri, 21 Oct 2005 14:05:43 -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 32587-01 for ; Fri, 21 Oct 2005 17:05:36 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id 9382CDA41F for ; Fri, 21 Oct 2005 14:05:36 -0300 (ADT) Received: by flake.decibel.org (Postfix, from userid 1001) id 5D11815255; Fri, 21 Oct 2005 12:05:35 -0500 (CDT) Date: Fri, 21 Oct 2005 12:05:35 -0500 From: "Jim C. Nasby" To: Kirby Ubben Cc: pgsql-admin@postgresql.org Subject: Re: Replication Solutions for PostgreSQL Master to Slave Message-ID: <20051021170535.GD16682@pervasive.com> References: <43591734.8070202@mcmurrayhatchery.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <43591734.8070202@mcmurrayhatchery.com> X-Operating-System: FreeBSD 4.11-RELEASE-p10 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 required=5 tests=[AWL=0.007] X-Spam-Level: X-Archive-Number: 200510/240 X-Sequence-Number: 19312 Unfortunately, the only syncronous replication I know of is http://pgfoundry.org/projects/pgcluster/, which is statement-based. That means it's got some substantial drawbacks... On Fri, Oct 21, 2005 at 11:28:36AM -0500, 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. > > 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----- > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461