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, <[email protected]> wrote: > Andrew and list, > > On Tue, Jun 7, 2022, 05:30 Andrew Hughes via Qgis-user < > [email protected]> 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 > >> >>
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
