Restoring a database dump is probably the best approach, especially if you want to retain certain metadata, relations, and ownership information etc.
If it's just the data itself you want to migrate and you're not 100% comfortable with database administration, an easy option is to connect to both databases from the qgis browser and then just drag and drop the tables/ layers from the old schema to the new one, then qgis will handle loading the data for you. On Sat, 25 Sep 2021, 19:16 chris hermansen, <[email protected]> wrote: > L.W. and list > > On Sat, Sep 25, 2021, 09:59 L.W. <[email protected]> wrote: > >> Ok, I forgot the auto-find feature. >> >> Next I have to find out the best way to get the tables from old to new >> server ... >> > > pg_dump will turn your old database into a script that you can run on your > new server with psql to recreate the database there. > >> >> _______________________________________________ > 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 >
_______________________________________________ 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
