Hello again andrew,
Actually man I do need to be able to write to both databases, and keep them
synchronized, and all this because of the recurring xenofobia for technology
and the fear of "hackers" (I know the difference between hackers and
crackers) on the internet, I actually said, it will cost less to have an
adsl line on both location connecting to the same database than to pay me to
create the synchronization framework, but hey what can you do!
Best Regards,
Fotis
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Andrew Sullivan
> Sent: 27 June 2006 14:40
> To: pgsql-sql@postgresql.org
> Subject: Re: Fwd: [SQL] Start up question about triggers
>
> On Tue, Jun 27, 2006 at 11:16:17AM +0300, Forums @ Existanze wrote:
> >
> > 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.
>
> It is totally normal to want to keep two databases in two locations:
> that's a matter of safety. Slony does it automatically, as
> long as the daemon is running. No need to control it.
>
> _Unless_ you want to be able to write in the second database.
> That's a different problem. You can't do that with Slony.
>
> A
>
> --
> Andrew Sullivan | ajs@crankycanuck.ca
> The fact that technology doesn't work is no bar to success in
> the marketplace.
> --Philip Greenspun
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>