Re: PostGreSQL Replication question !!

On Mon, 17 Feb 2003 13:20:08 -0500 Andrew Sullivan <andrew(at)libertyrms(dot)info> wrote:
> dbmirror is also in contrib/. It's free. Some people have had good
> luck with it, I understand. I believe it is still being developed.
> I don't know that there's a lot of development to do. It uses the
> primary key on a table, and multiple-column primary keys are not
> supported AFAIK. I'll bet you could modify the code to use some
> other single-column unique-indexed not null field. I haven't tried.

i'm about to start working on using dbmirror for a project. i'd say that in
its current state, it's not complete, but it can be persuaded to serve in a
useful way. it lacks conflict resolution, and it currently replicates one
master to one slave (but can be coached into something more comprehensive.)
it also makes assumptions about the initial states of the databases
involved replication.

richard
--
Richard Welty rwelty(at)averillpark(dot)net
Averill Park Networking 518-573-7592
Unix, Linux, IP Network Engineering, Security