Thread: Basic replication query

Hello,

I am looking for ways to replicate several remote dataabses over night,
and perhapse at intervals during the day.

My setup will have a master DB at the head office, and copies at each
branch.

The update will happen over a dial up, that is each branch will dial up
the main office to replicate.  So this will have to happen twice each
night. First the branch will upload it's changes, get in changes from
the main office, then later on check in to get changes from the other
branches...

Any ideas on how to go about it,  should I use pgreplica or roll my own?

Thanks

--

On Thu, Jul 18, 2002 at 11:07:30AM +1200, Rob Brown-Bayliss wrote:
> Hello,
>
> I am looking for ways to replicate several remote dataabses over night,
> and perhapse at intervals during the day.
>
> Any ideas on how to go about it,  should I use pgreplica or roll my own?

It depends on what you know about.  Since I know how the
contrib/rserv code works, I'd use that.

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110