Hi Frank,
There are several options. That's the problem.
I use pg_services. Every user has his own pg_service file, with their
credentials.
Project templates (and common styles) are stored in one specific
database, that everybody can read.
All Postgis layers are referenced by the service name. Users save their
own projects on the database to. Some resources (like SVG icons and
images used on print compositions) are stored on a WEBDAV shared folder.
Rasters are also published using PostGIS, so rasters are also available
as another PostGIS layer.
This setup is interesting, because QGIS Server is also able to read all
projects prepared by users, for web visualization. The webdav folder is
also readable by the server, so I have no problems on server side
rendering. If properly configured, you can use the server landing page
support to do a quick preview of the projects stored on each database.
Regards,
Jorge Gustavo
On 22/11/21 19:35, Frank Broniewski 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
[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
