[Qgis-user] QGIS project templates and PostGIS connections

Bo Victor Thomsen bo.victor.thomsen at gmail.com
Mon Nov 22 12:11:35 PST 2021


This answer is somewhat old; there might be a better solution:

https://gis.stackexchange.com/questions/247454/simplify-postgis-authentication-process-from-qgis

and directory .qgis2 is replaced by a profile directory:  Menu item 
"Settings"->"Open Active Profile Folder"

Med venlig hilsen / Kind regards

Bo Victor Thomsen

Den 22-11-2021 kl. 20:35 skrev 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


More information about the Qgis-user mailing list