From: | Brent Wood <Brent(dot)Wood(at)niwa(dot)co(dot)nz> |
---|---|
To: | Willy-Bas Loos <willybas(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: synchronize DTAP |
Date: | 2014-09-30 08:20:11 |
Message-ID: | eef5ee2841024daea3188a9dcf352cb9@welwex02.niwa.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
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<http://www.niwa.co.nz>
[NIWA]<http://www.niwa.co.nz>
________________________________
From: pgsql-general-owner(at)postgresql(dot)org <pgsql-general-owner(at)postgresql(dot)org> on behalf of Willy-Bas Loos <willybas(at)gmail(dot)com>
Sent: Tuesday, September 30, 2014 8:58 PM
To: pgsql-general(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2014-09-30 10:34:08 | Re: BDR Global Sequences |
Previous Message | Willy-Bas Loos | 2014-09-30 07:58:38 | synchronize DTAP |