This is not tested, but I think it should work Enable host based access for local connections via the server IP address in your pg_hba file and use this for all QGIS access, so you apply the same access approach for both local & remote connections.
Cheers Brent Wood Programme leader: Environmental Information Delivery NIWA DDI: +64 (4) 3860529 [cid:[email protected]]<http://www.niwa.co.nz> Brent Wood Principal Technician - GIS and Spatial Data Management Programme Leader - Environmental Information Delivery T +64-4-386-0529 National Institute of Water & Atmospheric Research Ltd (NIWA) 301 Evans Bay Parade, Greta Point, Wellington Connect with NIWA: niwa.co.nz<https://www.niwa.co.nz> Facebook<https://www.facebook.com/nzniwa> Twitter<https://twitter.com/niwa_nz> LinkedIn<https://www.linkedin.com/company/niwa> Instagram<https://www.instagram.com/niwa_science> To ensure compliance with legal requirements and to maintain cyber security standards, NIWA's IT systems are subject to ongoing monitoring, activity logging and auditing. This monitoring and auditing service may be provided by third parties. Such third parties can access information transmitted to, processed by and stored on NIWA's IT systems. ________________________________________ From: Qgis-user <[email protected]> on behalf of Laurence Béchet <[email protected]> Sent: Friday, January 11, 2019 13:04 To: [email protected] Subject: [Qgis-user] Project files with local and remote connections to postgreSQL databases Hi, I am having a basic problem with my project files. I usually run qgis locally, where the PostgreSQL database is. However, sometimes I need to have these same projects run on a remote computer (where a version a qGIS is locally installed, but the connection to the database is remote). And then the project file 'doesn't work' because the expected connection to the database is locally not remotely, and I have not figured out how to modify this parameter when the project is loaded in qGIS. My current work around is to create a specific project for the remote computer. However this solution is annoying when you have plenty of composers that you lose in the process ... and playing directly in the xml project file is a bit scary ... Anybody would have an idea how to fix the problem? Kind regards Laurence Béchet ARK IN THE PARK Volunteer Co-Ordinator Cascades Ranger Station Falls Road, Waitakere Phone: (09) 810 7014 www.arkinthepark.org.nz www.forestandbird.org.nz _______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
