[Qgis-user] QGIS project templates and PostGIS connections

[Jorge Gustavo Rocha]

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