[Qgis-user] Sync / Reconcile Data in Postgres

[Andrew Hughes]

Thanks Chris.

Looks like that's for schema changes, and I need data changes. But thanks
all the same.

Cheers Andrew


p.s. we use Flyway https://flywaydb.org/postgresql for managing schema
changes. It's actually the reason we don't want QGIS randomly dropping and
recreating tables

On Tue, 7 Jun 2022, 4:38 pm chris hermansen, <clhermansen at gmail.com> wrote:

> 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/f6e58fe7/attachment.htm>