Hello again,
I did some research on your suggestions with Slony-I and logshipping, one
major drawback we just realized is that the server where postgres will sit
on runs Windows XP. Our client has this techie that only knows how to manage
a windows box, and he runs some other services that we cannot port to linux.
Is there anything similar to slony-I that we could run on windows?
On the install notes of Slony 1.1.5 we didn't find any information about
compiling and running Slony-I on windows and we know that it will be
available in version 1.2
Best Regards,
Fotis
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Joe
> Sent: 27 June 2006 15:15
> To: Andrew Sullivan
> Cc: pgsql-sql@postgresql.org
> Subject: Re: Fwd: [SQL] Start up question about triggers
>
> Andrew Sullivan wrote:
> > 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.
>
> But with file-based log shipping (see
> http://linuxfinances.info/info/logshipping.html) one could
> write a Java app to control when the updates are applied.
>
> Joe
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org
> so that your
> message can get through to the mailing list cleanly
>