[Qgis-user] QGIS project templates and PostGIS connections

[Alessandro Pasotti]

Hi Frank,

you can safely use a custom authentication ID for the connection (choose
something easy to type), then instruct your users to create an
authentication configuration with the same ID but with their own
credentials.

This could be automated at the company level with a custom python init
script, you can even place that on a network folder for easy access from
sys admins.

There used to be some examples around back from Boundless times, probably a
little old but you can get the idea.

https://boundless-desktop.readthedocs.io/en/latest/system_admins/init_scripts.html#add-an-authentication-configuration

Hope this helps.


On Mon, Nov 22, 2021 at 8:42 PM Frank Broniewski <hallo at frankbroniewski.com>
wrote:

> 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
>


-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20211122/288ce195/attachment.html>