Hi, Le mar. 23 nov. 2021 à 09:13, Pekka Sarkola <pe...@gispo.fi> a écrit :
> Hi Frank and lists members, > > We use to identify different PostgreSQL clusters/databases with > PGServicefile: this gives flexibility to change PostgreSQL cluster and/or > databases without annoying users. Authentication of the users is done via a > personal authentication database. > > Old, but still valid QGIS and PostgreSQL service connection file > documentation is here: > https://docs.qgis.org/2.14/en/docs/user_manual/working_with_vector/supported_data.html#service-connection-file > > Up to date link available at https://docs.qgis.org/3.16/en/docs/user_manual/managing_data_source/opening_data.html#postgresql-service-connection-file Regards, Harrissou Rgs, > > Pekka > > Pekka Sarkola > Gispo Oy > pekka.sark...@gispo.fi - GSM +358 40 725 2042 > www.gispo.fi – www.paikkatieto.com > > > ma 22. marrask. 2021 klo 21.42 Frank Broniewski (ha...@frankbroniewski.com) > kirjoitti: > >> 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 >
_______________________________________________ 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
