[Qgis-user] QGIS Server setup <-- PostgreSQL/PostGIS

[Jorge Gustavo Rocha]

Hi Sebastián,

This is an example of QGIS_PROJECT_FILE: 
"postgresql://geobox:geobox@192.168.1.96:5432?sslmode=disable&dbname=geotuga&schema=qgis&project=world"

The project name is "world" and it is stored in "qgis_projects" table, 
in schema "qgis", in the database called "geotuga".

PostgreSQL server is running on port 5432 on server 192.168.1.96. The 
role to access PortgreSQL is "geotuga" (the password is the same).

Layers on project "world" must be available from the QGIS Server.

I hope it helps.

Best regards,

Jorge

On 11/02/25 19:40, Sebastián Meyer via QGIS-User wrote:
> Hi,
>
>
> a follow-up. I tried saving a project in the Public schema of another 
> database, and when trying to publish it the result was the same.
>
> So I'm stucked with apache.
>
> My doubt is in this connection template for QGIS_PROJECT_FILE
>
> postgresql://localhost:5432?sslmode=disable&dbname=mydb&schema=myschema&project=myproject 
>
>
> What do I have to fill in "myproject"? A project (name or full file 
> name) or the qgis_projects table?
>
> Any example will be very appreciated,
>
>
> -- 
> seb
>
>
> _______________________________________________
> 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
-- 
Logo *Geomaster, LDA *
*VENHA DESCOBRIR O CAMINHO DO OPEN SOURCE CONNOSC *

Rua Afonso Palmeira, 31, 7 D
4715-278 Braga
VAT/NIF 510 906 109
Phone  +351 253 257 173
Site geomaster.pt <http://geomaster.pt>
GPS 41.54627, -8.40432
	
------------------------------------------------------------------------
	
Jorge Gustavo Rocha
CTO

Mobile   +351 910 333 888
Email jgr at geomaster.pt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250211/0e719e85/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cropped-geomaster300x300-1.png
Type: image/png
Size: 33896 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20250211/0e719e85/attachment.png>