[Qgis-user] QGIS project templates and PostGIS connections

[Dirk.Pispers at STADT-KOELN.DE]

Hi Frank,

in our city administration we have many QGIS projects, that are used by a number of different users and includes PostgreSQL-Connections.
The way we handle this is that every user creates an authentication configuration with the same id. If you have only one PostgreSQL instance or if username/password in all instances is the same, you have only one authentication configuration that is used in every database connection.
That is not a very convenient solution, but the best one i figured out.
In the next step we will setup all PostgreSQL instances for authentication against our active directory.
The last step hopefuly will be to switching this to Kerberos authentication, which means an single sign on without any username/password handling in QGIS.
See https://www.fossgis-konferenz.de/2020/attachments/UPPG8U_fossgis_ad_postgresql_schulz_2_EDa0QTa.pdf for more informations about Kerberos. 

Regards
Dirk
-----
Hi fellow QGIS user!

I am scratching my head on the following problem. I want to create a QGIS project template which has PostGIS layers in it. I want to be able to pass this template to other users who might use them for different tasks.

The problem now is the connection string to the PostGIS database. When using the authentication manager each PostGIS connection gets its own ID which in turn is then referenced in the connection string to the layer. 
But now this ID to the PostGIS connection is different for each user, so the stored connection string in the template is not valid anymore. And each user has his own credentials for logging into PostGIS as well.

I see that I can give a custom ID to a connection in the authentication manager, but it is locked by default, so I am hesitant to unlock it. But is this a viable option? Create the PostGIS connection under the same ID for each user?

There's also the PostgreSQL connection service file [1] which might be an option? Does anyone have some experience to share, especially when talking Windows PC?

How do you manage PostGIS connections for "simple" users on a somewhat larger scale? I am talking about 20 users, just enough to be annoying enough for manual deployment ...

Many thanks for any tips,

Frank


[1] https://www.postgresql.org/docs/12/libpq-pgservice.html


_______________________________________________
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