X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D0FB89F9FE3 for ; Mon, 26 Jun 2006 11:43:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 76058-07 for ; Mon, 26 Jun 2006 11:43:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 195219F9AD3 for ; Mon, 26 Jun 2006 11:43:15 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1FusPJ-0002iN-UD for pgsql-sql@postgresql.org; Mon, 26 Jun 2006 10:49:46 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 147134172; Mon, 26 Jun 2006 10:43:09 -0400 (EDT) Date: Mon, 26 Jun 2006 10:43:09 -0400 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: Fwd: Start up question about triggers Message-ID: <20060626144309.GA20519@phlogiston.dyndns.org> References: <20060626104312.GB15992@phlogiston.dyndns.org> <200606261359.k5QDxE2p004593@auth-smtp.hol.gr> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200606261359.k5QDxE2p004593@auth-smtp.hol.gr> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/267 X-Sequence-Number: 25503 On Mon, Jun 26, 2006 at 04:59:26PM +0300, Forums @ Existanze wrote: > Hello again, > > The problem is not tracking WHAT changed, this can be done, as we have > discussed in this thread, the problem is how to replicate the necessary > commands that will alter a mirror database to reflect what has been changed, > sequencially and in the order that it has occurred. > > I you can find my first question (I can repost), you will see that this > problem has arisen due of lack of proper design. This is a requirement that > has just come into the picture and we have to find a solution for it. Ah. That was not, in fact, clear to me. What is it about Slony that doesn't solve this problem? You've checked it out, right? will get you there. A -- Andrew Sullivan | ajs@crankycanuck.ca If they don't do anything, we don't need their acronym. --Josh Hamilton, on the US FEMA