[Qgis-user] Sync / Reconcile Data in Postgres

[chris hermansen]

Andrew and list,

On Tue, Jun 7, 2022, 05:30 Andrew Hughes via Qgis-user <
qgis-user at lists.osgeo.org> wrote:

> Hi All,
>
> I have several third-party living datasets (accessible via web services)
> that I need to replicate to an internal postgres instance (ETL processes).
>
> My question is, given my script/model has obtained a copy of the dataset.
> What would you recommend I use to synchronize the new/freshly downloaded
> data with the older data in the postgres database? In other words, how do I
> sync/reconcile the database.
>

Have you considered this tool

https://michaelsogos.github.io/pg-diff/

I have no experience with it but it seems like it could do the job.

Chris

>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220607/94c246be/attachment.htm>