Re: [Qgis-user] PostGIS change Server

2021-09-25 Thread 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

Re: [Qgis-user] PostGIS change Server

2021-09-25 Thread chris hermansen
L.W. and list On Sat, Sep 25, 2021, 09:59 L.W. 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 d

Re: [Qgis-user] PostGIS change Server

2021-09-25 Thread L.W.
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

Re: [Qgis-user] PostGIS change Server

2021-09-25 Thread 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 si

[Qgis-user] PostGIS change Server

2021-09-25 Thread L.W.
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 lo