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@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
