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

[Paolo Cavallini]

Use pg_services.

Il 11 gennaio 2019 01:54:24 CET, Brent Wood <Brent.Wood at niwa.co.nz> ha scritto:
>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

-- 
Sorry for being short
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190111/96865c24/attachment.html>