Re: PostGreSQL Replication question !! - Mailing list pgsql-general

From Richard Welty
Subject Re: PostGreSQL Replication question !!
Date
Msg-id E18kq9W-0002Nh-00@skipper.averillpark.net
Whole thread Raw
In response to Re: PostGreSQL Replication question !!  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-general
On Mon, 17 Feb 2003 13:20:08 -0500 Andrew Sullivan <andrew@libertyrms.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@averillpark.net
Averill Park Networking                                         518-573-7592
              Unix, Linux, IP Network Engineering, Security

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: shmget problem with Win NT services
Next
From: "Gregory Wood"
Date:
Subject: Re: PostGreSQL Replication question !!