Skip site navigation (1) Skip section navigation (2)

Re: How do i compare 2 postgresql instanses ?

From: "Michael Nacos" <m(dot)nacos(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: How do i compare 2 postgresql instanses ?
Date: 2008-07-08 15:21:46
Message-ID: 407fa4640807080821w3e33c567u82fbdc4fe6d08712@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Thanks Kevin... I am working on something different right now but I'll soon
have to give it a go, one way or the other...

Michael

On Tue, Jul 8, 2008 at 3:28 PM, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
wrote:

>
> Our home-grown replication technique does synchronization checks
> during idle time.  It works pretty well for us, and we do use md5sum
> techniques to minimize bandwidth.
>
> In summary, a process requests a middle tier on a "source" machine to
> send "sync" information; that middle tier reads some set of rows and
> sends the md5 sum of all data in the rows, along with information on
> what rows from which table were used to develop the number.  The
> requesting process then asks similar middle tiers on all replication
> targets to return their md5sum for the same set of rows.  If there are
> any differences, the source and all differing replication targets are
> queried for the actual values, which are compared using match-merge
> type logic on the primary key sequence.
>
> Something similar might work for you.
>
> -Kevin
>

In response to

pgsql-admin by date

Next:From: kevin kempterDate: 2008-07-08 15:31:28
Subject: Dupes inserted that violate the PK
Previous:From: Kevin GrittnerDate: 2008-07-08 14:28:14
Subject: Re: How do i compare 2 postgresql instanses ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group