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