<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Sebastián,</p>
<p>This is an example of QGIS_PROJECT_FILE:
<a class="moz-txt-link-rfc2396E" href="postgresql://geobox:geobox@192.168.1.96:5432?sslmode=disable&dbname=geotuga&schema=qgis&project=world">"postgresql://geobox:geobox@192.168.1.96:5432?sslmode=disable&dbname=geotuga&schema=qgis&project=world"</a><br>
</p>
<p>The project name is "world" and it is stored in "qgis_projects"
table, in schema "qgis", in the database called "geotuga".</p>
<p>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).</p>
<p>Layers on project "world" must be available from the QGIS Server.<br>
</p>
<p>I hope it helps.</p>
<p>Best regards,</p>
<p>Jorge<br>
</p>
<p></p>
<div class="moz-cite-prefix">On 11/02/25 19:40, Sebastián Meyer via
QGIS-User wrote:<br>
</div>
<blockquote type="cite"
cite="mid:f6cb51f1-0bf5-461e-8a25-9ac27bd160e9@indomitux.com">Hi,
<br>
<br>
<br>
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.
<br>
<br>
So I'm stucked with apache.
<br>
<br>
My doubt is in this connection template for QGIS_PROJECT_FILE
<br>
<br>
<a class="moz-txt-link-freetext" href="postgresql://localhost:5432?sslmode=disable&dbname=mydb&schema=myschema&project=myproject">postgresql://localhost:5432?sslmode=disable&dbname=mydb&schema=myschema&project=myproject</a>
<br>
<br>
What do I have to fill in "myproject"? A project (name or full
file name) or the qgis_projects table?
<br>
<br>
Any example will be very appreciated,
<br>
<br>
<br>
--
<br>
seb
<br>
<br>
<br>
_______________________________________________
<br>
QGIS-User mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:QGIS-User@lists.osgeo.org">QGIS-User@lists.osgeo.org</a>
<br>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br>
</blockquote>
<div class="moz-signature">-- <br>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div class="moz-signature"> <img
src="cid:part1.KQO431Mk.GBlpdfcG@geomaster.pt" alt="Logo"
width="50" height="50" align="left"> <span class="im"> <b> <font
size="+2">Geomaster, LDA</font> </b> </span><br>
<div class="moz-signature"> <b> <font color="#999999"
size="-2">VENHA DESCOBRIR O CAMINHO DO OPEN SOURCE CONNOSC</font>
</b>
<table width="450" border="0" height="126" cellspacing="1"
cellpadding="2">
<tbody>
<tr>
<td width="150" height="50" valign="top"> <font
size="-1"><span class="im"> <font size="-2"> </font><br>
Rua Afonso Palmeira, 31, 7 D<br>
4715-278 Braga<br>
VAT/NIF </span><span class="im"> 510 906 109<br>
Phone</span><span class="im"> +351 253 257 173<br>
</span>Site <a href="http://geomaster.pt"
rel="noreferrer" target="_blank">geomaster.pt</a><br>
GPS 41.54627, -8.40432 </font><br>
<span class="im"></span> </td>
<td width="25" valign="top" align="right"> <font
size="-1"><span class="im"></span></font>
<hr width="2" size="100" align="right"> </td>
<td width="150" height="50" valign="top" nowrap="nowrap">
<font size="-1"> <font size="-1"> <font size="-2"> </font><br>
Jorge Gustavo Rocha </font><br>
<font color="#999999" size="-2">CTO<br>
<br>
</font>Mobile </font> <font size="-1"><span
class="im"> +351 910 333 888<br>
Email <a class="moz-txt-link-abbreviated" href="mailto:jgr@geomaster.pt">jgr@geomaster.pt</a></span></font> </td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</body>
</html>