Re: bi-directional syncing help request - Mailing list pgsql-general

From bricklen
Subject Re: bi-directional syncing help request
Date
Msg-id CAGrpgQ97m6dbHpTjMbBTuoyGGre41J=fAXdOA1fhDs8qX5jbZA@mail.gmail.com
Whole thread Raw
In response to Re: bi-directional syncing help request  (Bèrto ëd Sèra <berto.d.sera@gmail.com>)
Responses Re: bi-directional syncing help request  (Bèrto ëd Sèra <berto.d.sera@gmail.com>)
List pgsql-general
On Fri, Aug 9, 2013 at 8:12 AM, Bèrto ëd Sèra <berto.d.sera@gmail.com> wrote:
or you can just take a full dump from one box and import it on the other any time you switch. If it's not a big db it should probably be quicker than any alternative approach.

A pg_dump from one system or the other will effectively overwrite the database it is restored to, so any changes in one system or the other will be lost unless processes are put in place to move that data to a staging area before the reload.
The issue here is that it is a data and structure synchronization problem, which isn't something solved very easily using Postgresql's core tools.  Synchronizing the data using Bash/Python, FDW's etc is reasonably straightforward, but synchronizing the DDL changes will require some care.


pgsql-general by date:

Previous
From: Bèrto ëd Sèra
Date:
Subject: Re: bi-directional syncing help request
Next
From: Quentin Hartman
Date:
Subject: Re: Weird error when setting up streaming replication