I have a QGIS project with around 100 layers referring to a postgres database.
Since we're migrating to a new server, the database will be transfered too, but will be given a new IP. The connection between all layers in my QGIS project will be lost, due to a slight alteration in the source connection.
Is there a way to change the datasource of all layers, instead of the need to refer to this new db, layer by layer?
(Extra info: the way how the postgres database is structured isn't changing, the IP is the only thing being changed.)