Postgres Pro
Downloads
Home   >   mailing lists

Re: synchronize DTAP - Mailing list pgsql-general

From Brent Wood
Subject Re: synchronize DTAP
Date
Msg-id eef5ee2841024daea3188a9dcf352cb9@welwex02.niwa.local
Whole thread Raw
In response to synchronize DTAP  (Willy-Bas Loos <willybas@gmail.com>)
List pgsql-general
Tree view

Gidday,


There was an interesting presentation at the Portland Postgres Users Group meeting in early Sept, from a guy who demo'd a Postgres database mounted as a FUSE filesystem. Not production ready, but with tables manifesting as directories, databases could be synch'ed using filesystem tools like rsynch - which offers intriguing backup & replication possibilities.


 http://vimeo.com/105493143


the demo of the FUSE functionality starts at 39 minutes into the presentation.


Brent Wood

Programme leader: Environmental Information Delivery
NIWA
DDI:  +64 (4) 3860529

Brent Wood
Principal Technician - GIS and Spatial Data Management
Programme Leader - Environmental Information Delivery
+64-4-386-0529 | 301 Evans Bay Parade, Greta Point, Wellington | www.niwa.co.nz
NIWA
From: pgsql-general-owner@postgresql.org <pgsql-general-owner@postgresql.org> on behalf of Willy-Bas Loos <willybas@gmail.com>
Sent: Tuesday, September 30, 2014 8:58 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] synchronize DTAP
 

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




Attachment

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [SQL] pg_multixact issues
Next
From: Adam Brusselback
Date:
Subject: Re: table versioning approach (not auditing)