Message-Id: <200606270816.k5R8GHfk023493@auth-smtp.hol.gr>
From: "Forums @ Existanze" <forums@existanze.com>
To: <pgsql-sql@postgresql.org>
Subject: Re: Fwd: Start up question about triggers
Date: Tue, 27 Jun 2006 11:16:17 +0300
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-index: AcaZL1cSuh1UGcj7T9CTPHyJWHceBgAkiBYA
In-Reply-To: <20060626144309.GA20519@phlogiston.dyndns.org>

 
Hello again,


I looked into slony, I have a question though, how would I go about
controlling slony via a jdbc driver? See this whole problem has arisen
because for some reason my client wants to keep to separate databases in two
separate locations with the same data. So he would call this partiall backup
function via a GUI client we provide, and with this information he would go
to the same GUI client in this other location and import this partiall
backup. 

Best Regards,
Fotis

PS- Hacking pgtool is way out my leage :-) But thanks for the suggestion!!!


> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org 
> [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Andrew Sullivan
> Sent: 26 June 2006 17:43
> To: pgsql-sql@postgresql.org
> Subject: Re: Fwd: [SQL] Start up question about triggers
> 
> 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? 
> <http://www.slony.info> 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
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq
>