[Qgis-user] PostGIS change Server

[Charles Dixon-Paver]

If you want to bulk process your layers there are a few options. If you
break the existing connection, the project will prompt you to find new
layers when it starts up, the interface for which includes features like
"auto-find" etc. There is also a plugin called changeDataSource which
provides a similar functionality to changing the data source from the layer
context menu, but I believe it supports bulk processing as well.

Personally in most instances I use a text editor to find and replace the
various data source strings within the project file, but this is context
specific and if you have complex configurations you may break things in
your project. If you want a good visual UX the plugin route is probably the
best.

Regards


On Sat, 25 Sept 2021 at 12:29, L.W. <eaglelw at gmx.de> wrote:

> Hi,
>
> I want to change the database server for my QGIS-Project.
>
> I have a new server at a new location, postgres+postgis.
> Postgis extension is activated on 2nd one.
>
> Do I have to change every single layer each at a time? Is there a batch
> option?
>
> How can I achieve this without loosing data and a lot of time?
>
> Regards
>
> _______________________________________________
> 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/9d23a5c9/attachment.html>