[Qgis-user] PostGIS change Server

L.W. eaglelw at gmx.de
Sat Sep 25 09:59:23 PDT 2021


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 ...

Thx.

Am 25.09.2021 um 13:29 schrieb 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
> <mailto: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 <mailto:Qgis-user at lists.osgeo.org>
>     List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>     <https://lists.osgeo.org/mailman/listinfo/qgis-user>
>     Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>     <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/cbd957da/attachment.html>


More information about the Qgis-user mailing list