[Qgis-user] Project files with local and remote connections to postgreSQL databases

[Brent Wood]

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:imagef6a2d5.PNG at d3805356.4e8e0b4a]<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 <qgis-user-bounces at lists.osgeo.org> on behalf of Laurence Béchet <bechet.laurence at gmail.com>
Sent: Friday, January 11, 2019 13:04
To: qgis-user at lists.osgeo.org
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
Qgis-user at lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190111/b3e1f673/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: imagef6a2d5.PNG
Type: image/png
Size: 12288 bytes
Desc: imagef6a2d5.PNG
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190111/b3e1f673/attachment.png>