[Qgis-user] PostGIS change Server

[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 lot of time?

Regards