[Qgis-user] QGIS project templates and PostGIS connections

[Frank Broniewski]

I just wanted to thank you all for your valuable feedback that I 
received. It's good to have so many, flexible options in QGIS, although 
the KERBEROS stuff is way over my head :-), but it's good to know that 
it is possible.

Many thanks again,

Frank



Am 22.11.21 um 20:35 schrieb Frank Broniewski:
> 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