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 Rgs, Pekka Pekka Sarkola Gispo Oy [email protected] - GSM +358 40 725 2042 www.gispo.fi – www.paikkatieto.com ma 22. marrask. 2021 klo 21.42 Frank Broniewski ([email protected]) 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 > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
