On 4/10/07, Joachim Schipper <[EMAIL PROTECTED]> wrote:
On Tue, Apr 10, 2007 at 03:55:48PM -0500, Jacob Yocom-Piatt wrote:
> there is a pervasive sql v8 database on windows 2003 server that i would
> like to "clone" to a pgsql database on openbsd. i've not done this
> before and am not familiar with the proper technique(s) to do such a thing.
>
> the goal is to have any changes made to the pervasive DB be piped over
> to the mirror pgsql DB as the changes are made. any suggestions on how
> to setup this communication between the DBs would be very much appreicated.
You might want to consider slony-l (asynchronous replication, might not
be what you want, but rather mature) and pgcluster (synchronous, but
development appears to have ceased).
There is some documentation on the net on how to do this; I've never
gone past looking at it, myself, so couldn't help you there.
I think he's going to have to write a stored procedure and some
triggers on the pervasive box.
Greg
