I have several QGIS project files (qgz) I didn't touch in quite some time that contain several layers heavily depending on a PostGIS connection and meanwhile its port number was changed (everything else of the connection is unchanged). Now I am aware of the changeDataSource plugin and back in the days I used to textedit qgs files for that purpose
My problem is that QGIS crashes when I open said project file after I have to cancel all the db-credential prompts. So I wonder which way is more promising:
- Change the port number via editor in qgs and wrap it somehow in its qgz?
- Provide the desired port number to QGIS via proxy or SSH tunnel if that's even possible?