[Qgis-user] PostGIS change Server

[Charles Dixon-Paver]

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, <clhermansen at gmail.com> wrote:

> L.W. and list
>
> On Sat, Sep 25, 2021, 09:59 L.W. <eaglelw at gmx.de> 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
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210925/a913a5eb/attachment.html>