From: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | synchronize DTAP |
Date: | 2014-09-30 07:58:38 |
Message-ID: | CAHnozTgxuV6vu0kN18HFJZKxEAY8orGHUwK9ebYfbU0Rs2xhVg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
We have an environment that has a central repository for lookups, which is
replicated to several databases, ech for different applications.
This has been arranged in a DTAP manner.
Sometimes it is necessary to synchronize the lookups of one of the DTAP
branches with another. But i can't just overwrite one database with a dump
from another branch, as the consumer databases will not follow.
What i think i need is a way to compute the differences between two
databases that have the same schema, and generate insert/update/delete
statements from that.
Since this seems as a pretty generic problem, i thought that i should ask
around before i start writing my own scripts. Does anyone know of script or
application that does this?
Cheers
--
Willy-Bas Loos
From | Date | Subject | |
---|---|---|---|
Next Message | Brent Wood | 2014-09-30 08:20:11 | Re: synchronize DTAP |
Previous Message | Jonathan Vanasco | 2014-09-29 23:20:08 | Re: Postgres as key/value store |