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

[Laurence Béchet]

Thanks for the answers. Sorry have not checked Brent's suggestion as the 
pg_services just work beautifully.

Maybe I have not been looking carefully, but it would be nice if it were 
a bit more documented in qgis doc - at least mentioned with an example ;o)

Kind regards
Laurence
Ark in the Park volunteer co-ordinator
On 11/01/2019 8:00 PM, Paolo Cavallini wrote:
> 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
>
>
>
>     <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/20190125/95aaeb6f/attachment.html>