[Qgis-user] sharing project with pg user and ssl connection

[Namik SCHERZL - SLA]

Hello,

In my structure we are currently migrate our GIS architecture from ESRI to Qgis & Postgres.
We would like to know the most recommended method for authenticating PG via Qgis knowing that :

* We want to avoid transmitting login / password information between users of the same project.

* Securing the data flow.

* we are keeping a few Arcgis licences, and they should have access to the DB

I've seen that Qgis can store PG login and password in it's own local storage and in the case we define a common authcfg ID for all our users it's possible for several users to share the same project without transferring any information/ rights.

https://lists.osgeo.org/pipermail/qgis-user/2019-November/044321.html

I have carried out conclusive tests; however, I would like to ensure that this is a recommended practice and that this solution is sustainable over time.



Our service provider advises against securing our connection via an SSL certificate. For them, IP filtering is sufficient. However, I would like to know if there are any specific advantages or disadvantages to using an SSL certificate with QGIS ?



Also, do you know if a Let's Encrypt type certificate works well in this context, or are there known compatibility issues?



Thank you in advance for your feedback.



Best regards,

Namik Scherzl

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20260813/ee422224/attachment.htm>