<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Aptos;}
@font-face
{font-family:"Open Sans";}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Lato;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
h2
{mso-style-priority:9;
mso-style-link:"Überschrift 2 Zchn";
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:18.0pt;
font-family:"Calibri",sans-serif;
font-weight:bold;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
code
{mso-style-priority:99;
font-family:"Courier New";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.berschrift2Zchn
{mso-style-name:"Überschrift 2 Zchn";
mso-style-priority:9;
mso-style-link:"Überschrift 2";
font-family:"Calibri",sans-serif;
font-weight:bold;}
span.productname
{mso-style-name:productname;}
span.E-MailFormatvorlage26
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:394475845;
mso-list-template-ids:-1319082594;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1
{mso-list-id:1586450399;
mso-list-type:hybrid;
mso-list-template-ids:-824808294 134676481 134676483 134676485 134676481 134676483 134676485 134676481 134676483 134676485;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">Hallo Peter,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">vielen Dank für deine Antwort!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">Die ALKIS Daten werden von unseren Kunden (Kommunen) im XML-Format zur Verfügung gestellt.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">Mit dem norGIS ALKIS Import spielen wir die ALKIS-Daten strukturiert in die entsprechenden Kunden-DBs. Daraus können wir die ALKIS-Karte mit dem Signaturenkatalog in
die entsprechenden QGIS-Projekte einbinden. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">Eine andere / bessere Vorgehensweise ist uns für diesen Anwendungsfall bisher nicht bekannt?!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">Um die ALKIS-Daten auch in einem Lizmap-Projekt als Hintergrundgarte darstellen zu können, sind entsprechende ALKIS-Daten auch in der Cloud-PostGIS-DB eingespielt.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">In die für das Lizmap-Projekt angelegte QGIS-Datei auf dem Server lassen sich auch die ALKIS-Daten einbinden. Was nicht geht, ist die Einbindung mittels pg_service
Konfiguration.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">Dies wird aber unsererseits benötig, dass Server und wir von Lokal auf diese QGIS-Datei zugreifen können. (Der QGIS-Server sieht die Cloud DB mit einer anderen (internen)
IP-Adresse, als wir.)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">Wie geschrieben, funktioniert dies bei Standard PostGIS-Layern mittels pg_service wunderbar.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">Viele Grüße<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">Matthias<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b>Von:</b> Peter Berger <peter.berger@bluewin.ch> <br>
<b>Gesendet:</b> Mittwoch, 24. April 2024 10:25<br>
<b>An:</b> GIS | Reuther NetConsulting <gis@r-nc.de>; lizmap-de@lists.osgeo.org<br>
<b>Betreff:</b> AW: [Lizmap-de] Erfahrung mit pg_service.conf oder auch .pg_service.conf Konfiguration für Zugang zu Postgresdaten<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US">Hallo Matthias<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US">Habe eine Frage dazu. Wieso braucht es das Werkzeug? Man kann in QGIS ja einfach Alkis-Daten mit Drag und Drop aufnehmen und diese dann wiederum mit Drag und Drop in die Postgres/Postgis
DB aufnehmen.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US">Liebe Grüsse<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US">Peter<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b>Von:</b> Lizmap-de <<a href="mailto:lizmap-de-bounces@lists.osgeo.org">lizmap-de-bounces@lists.osgeo.org</a>>
<b>Im Auftrag von </b>GIS | Reuther NetConsulting via Lizmap-de<br>
<b>Gesendet:</b> Mittwoch, 24. April 2024 08:48<br>
<b>An:</b> <a href="mailto:lizmap-de@lists.osgeo.org">lizmap-de@lists.osgeo.org</a><br>
<b>Betreff:</b> Re: [Lizmap-de] Erfahrung mit pg_service.conf oder auch .pg_service.conf Konfiguration für Zugang zu Postgresdaten<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><span lang="DE-CH"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">Hallo zusammen,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">vielen Dank für eure Hinweise und Tipps!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">In Verbindung mit normalen PostGIS-Layern funktioniert pg_service bei uns.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">Wie geht ihr mit ALKIS-Daten um?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">Bei lokalen Projekten werden diese bei uns mit dem norGIS ALKIS Import mit den vollständigen Zugangsdaten zum Server / der Datenbank eingebunden.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">Beim Versuch diese nur mit Angabe des „Service“ einzubinden scheitern wir allerdings.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">Welche Konfigurationsangaben tragt ihr hier ein?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><img border="0" width="189" height="313" style="width:1.9722in;height:3.2638in" id="Grafik_x0020_2" src="cid:image001.jpg@01DA9634.59B26420"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">Vielen Dank und Grüße<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US">Matthias<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Aptos",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b>Von:</b> Lizmap-de <<a href="mailto:lizmap-de-bounces@lists.osgeo.org">lizmap-de-bounces@lists.osgeo.org</a>>
<b>Im Auftrag von </b>Günter Wagner via Lizmap-de<br>
<b>Gesendet:</b> Donnerstag, 4. April 2024 18:00<br>
<b>An:</b> 'Petert Berger' <<a href="mailto:peter.berger@bluewin.ch">peter.berger@bluewin.ch</a>>; 'Jörg Thomsen' <<a href="mailto:joerg.thomsen@wheregroup.com">joerg.thomsen@wheregroup.com</a>>;
<a href="mailto:lizmap-de@lists.osgeo.org">lizmap-de@lists.osgeo.org</a><br>
<b>Betreff:</b> Re: [Lizmap-de] Erfahrung mit pg_service.conf oder auch .pg_service.conf Konfiguration für Zugang zu Postgresdaten<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Hallo zusammen,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Danke Peter, für Deinen Erfahrungsbericht und vielen Dank an die Anderen für die Infos und Hinweise.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Ich werde das hoffentlich nächste Woche mal testen können. Bin gespannt und gebe Rückmeldung.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Viele Grüße<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Günter<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b>Von:</b> Lizmap-de <<a href="mailto:lizmap-de-bounces@lists.osgeo.org">lizmap-de-bounces@lists.osgeo.org</a>>
<b>Im Auftrag von </b>Petert Berger via Lizmap-de<br>
<b>Gesendet:</b> Donnerstag, 4. April 2024 14:07<br>
<b>An:</b> 'Jörg Thomsen' <<a href="mailto:joerg.thomsen@wheregroup.com">joerg.thomsen@wheregroup.com</a>>;
<a href="mailto:lizmap-de@lists.osgeo.org">lizmap-de@lists.osgeo.org</a><br>
<b>Betreff:</b> [Lizmap-de] Erfahrung mit pg_service.conf oder auch .pg_service.conf Konfiguration für Zugang zu Postgresdaten<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US">Hallo zusammen<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US">Ich möchte euch noch gerne meine Erfahrungen mit dem der pg_service.conf teilen. Dabei beziehe ich mich auf Linux. Es ist nämlich etwas tricky.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US">Offiziell findet man in der Postgres-Dokumentation dies:<o:p></o:p></span></p>
<h2 style="mso-margin-top-alt:12.0pt;margin-right:0cm;margin-bottom:12.0pt;margin-left:0cm">
<span lang="EN-US" style="font-size:17.5pt;font-family:"Open Sans",sans-serif">The Connection Service File <o:p></o:p></span></h2>
<p style="margin-top:0cm;box-sizing: border-box;margin-bottom:1rem;-webkit-tap-highlight-color: rgba(0, 0, 0, 0);-webkit-text-size-adjust: 100%">
<span lang="EN-US" style="font-size:9.0pt;font-family:"Open Sans",sans-serif">The connection service file allows libpq connection parameters to be associated with a single service name. That service name can then be specified in a libpq connection string, and
the associated settings will be used. This allows connection parameters to be modified without requiring a recompile of the libpq-using application. The service name can also be specified using the </span><code><span lang="EN-US" style="font-size:9.0pt">PGSERVICE</span></code><span lang="EN-US" style="font-size:9.0pt;font-family:"Open Sans",sans-serif"> environment
variable.<o:p></o:p></span></p>
<p style="margin-top:0cm"><a name="id-1.7.3.24.2"></a><a name="id-1.7.3.24.3"></a><a name="id-1.7.3.24.4"></a><span lang="EN-US" style="font-size:9.0pt;font-family:"Open Sans",sans-serif">Service names can be defined in either a per-user service file or a system-wide
file. If the same service name exists in both the user and the system file, the user file takes precedence. By default, the per-user service file is named </span><code><span lang="EN-US" style="font-size:9.0pt">~/.pg_service.conf</span></code><span lang="EN-US" style="font-size:9.0pt;font-family:"Open Sans",sans-serif">.
On Microsoft Windows, it is named </span><code><span lang="EN-US" style="font-size:9.0pt">%APPDATA%\postgresql\.pg_service.conf</span></code><span lang="EN-US" style="font-size:9.0pt;font-family:"Open Sans",sans-serif">(where </span><code><span lang="EN-US" style="font-size:9.0pt">%APPDATA%</span></code><span lang="EN-US" style="font-size:9.0pt;font-family:"Open Sans",sans-serif"> refers
to the Application Data subdirectory in the user's profile). A different file name can be specified by setting the environment variable </span><code><span lang="EN-US" style="font-size:9.0pt">PGSERVICEFILE</span></code><span lang="EN-US" style="font-size:9.0pt;font-family:"Open Sans",sans-serif">.
The system-wide file is named </span><code><span lang="EN-US" style="font-size:9.0pt">pg_service.conf</span></code><span lang="EN-US" style="font-size:9.0pt;font-family:"Open Sans",sans-serif">. By default it is sought in the </span><code><span lang="EN-US" style="font-size:9.0pt">etc</span></code><span lang="EN-US" style="font-size:9.0pt;font-family:"Open Sans",sans-serif"> directory
of the <span class="productname">PostgreSQL</span> installation (use </span><code><span lang="EN-US" style="font-size:9.0pt">pg_config --sysconfdir</span></code><span lang="EN-US" style="font-size:9.0pt;font-family:"Open Sans",sans-serif"> to identify this
directory precisely). Another directory, but not a different file name, can be specified by setting the environment variable </span><code><span lang="EN-US" style="font-size:9.0pt">PGSYSCONFDIR</span></code><span lang="EN-US" style="font-size:9.0pt;font-family:"Open Sans",sans-serif">.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US">Meine Erfahrungen:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<ul style="margin-top:0cm" type="disc">
<li class="MsoListParagraph" style="margin-left:0cm;mso-list:l1 level1 lfo3"><span lang="DE-CH" style="mso-fareast-language:EN-US">Zuerst habe ich mir in der User
<span style="background:lime;mso-highlight:lime">HOME-Verzeichnis ein </span></span><code><span lang="DE-CH" style="font-size:10.0pt;background:lime;mso-highlight:lime">~/.pg_service.conf</span></code><code><span lang="DE-CH" style="font-size:10.0pt">
</span></code><span lang="DE-CH" style="mso-fareast-language:EN-US">File angelegt. Dann hat es in QGIS funktioniert. In QGIS muss man dann eigentlich in den PostgeSQL-Settings nur den Service eintragen und es funktioniert.<o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l1 level1 lfo3"><span lang="DE-CH" style="mso-fareast-language:EN-US">Dann habe ich Lizmap geöffnet und da meckert Lizmap bei den Checks.
</span><span lang="EN-US" style="mso-fareast-language:EN-US">Nach Abschalten in den Services,
</span><span lang="EN-US">«Prevent PostgresSQL layers from using a service file» waren die Checks OK. (Komischer Check!)</span><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l1 level1 lfo3"><span lang="DE-CH">Im Web war dann der Postgres-Layer wiederum nicht zu sehen. Hmm.. Dann die Erleuchtung, dass der QGIS-Server ja nicht als gleicher User läuft und somit er das
</span><code><span lang="DE-CH" style="font-size:10.0pt">~/.pg_service.conf File </span>
</code><span lang="DE-CH">im Verzeichnis des anderen User nicht sieht. Also müsste ich das File an mehreren Ort haben. Nicht praktikabel!<o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l1 level1 lfo3"><span lang="DE-CH">Ich habe dann entschieden, dass ich das Ganze systemweit verfügbar mache indem ich
</span><code><span lang="DE-CH" style="font-size:10.0pt">pg_config –sysconfdir </span>
</code><span lang="DE-CH">aufrufe. Da kommt dies raus</span><code><span lang="DE-CH" style="font-size:10.0pt"> /etc/postgresql-common</span></code><span lang="DE-CH">. Nun habe ich das File
</span><code><span lang="DE-CH" style="font-size:10.0pt">~/.pg_service.conf </span>
</code><span lang="DE-CH">in diesen Ordner kopiert. Funktionierte nicht! Hmm… Aha, das File hat dort einen anderen Namen nicht
</span><code><span lang="DE-CH" style="font-size:10.0pt;background:red;mso-highlight:red">~/.pg_service.conf</span></code><code><span lang="DE-CH" style="font-size:10.0pt">
</span></code><span lang="DE-CH">sondern </span><code><span lang="DE-CH" style="font-size:10.0pt;background:lime;mso-highlight:lime">~/pg_service.conf</span></code><span lang="DE-CH">. Also ohne führenden Punkt. Nun hat es funktioniert!</span><span lang="DE-CH" style="font-size:10.0pt;font-family:"Courier New""><o:p></o:p></span></li><li class="MsoListParagraph" style="margin-left:0cm;mso-list:l1 level1 lfo3"><span lang="DE-CH">Man kann den Bezug auf das File auch in der Environment Variable PGSERVICEFILE definieren. Ob das funktioniert habe ich bis jetzt nicht ausprobiert. Hat jemand Erfahrung
damit?<o:p></o:p></span></li></ul>
<p class="MsoNormal"><span lang="DE-CH"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US">Etwas mühsam ist dies jedoch, wenn man ein QGIS-File auf einem System ohne Postgreszugang aufruft. Dann funktionieren die Postgres-Layer nicht.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US">Gruss, Peter<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b>Von:</b> Lizmap-de <<a href="mailto:lizmap-de-bounces@lists.osgeo.org">lizmap-de-bounces@lists.osgeo.org</a>>
<b>Im Auftrag von </b>Peter Berger via Lizmap-de<br>
<b>Gesendet:</b> Donnerstag, 28. März 2024 14:53<br>
<b>An:</b> Jörg Thomsen <<a href="mailto:joerg.thomsen@wheregroup.com">joerg.thomsen@wheregroup.com</a>><br>
<b>Cc:</b> <a href="mailto:lizmap-de@lists.osgeo.org">lizmap-de@lists.osgeo.org</a><br>
<b>Betreff:</b> Re: [Lizmap-de] Lizmap Rechte für Postgres-Layer direkt in das QGIS-File einbinden<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><span lang="DE-CH"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE-CH">Hallo Jörg<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span lang="DE-CH"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH">Vielen Dank für deinen Beitrag. Wir haben also diese Möglichkeiten: <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH">Die Credentials in ein dezidiertes File einzubinden, pg_service.conf.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH">In ein QGIS-File händisch pro Layer einzutragen.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH">Und via QGIS in einer Konfiguration einzutragen. Dies funktioniert bei mir jedoch nicht! Sollte doch? Hat QGIS, mindestens bei den 3.34.x Versionen einen Bug?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH">Wie immer, das mit dem pg_service.conf funktioniert. Ich werde in Zukunft diesen Weg gehen. <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH">Liebe Grüsse<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH">Peter<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span lang="DE-CH"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="DE-CH"><o:p> </o:p></span></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="DE-CH">Am 28.03.2024 um 08:42 schrieb Jörg Thomsen via Lizmap-de <<a href="mailto:lizmap-de@lists.osgeo.org">lizmap-de@lists.osgeo.org</a>>:<o:p></o:p></span></p>
</blockquote>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal"><span lang="DE-CH"> <o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span lang="DE-CH">Moin,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH">ein Zwischenruf von der Seite.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span lang="DE-CH"><o:p> </o:p></span></p>
</div>
<p><span lang="DE-CH">> Da ist zwar noch ein weiteres File dabei, ich hab aber nie rausgefunden, wofür das ist.
<o:p></o:p></span></p>
<p><span lang="DE-CH"><a href="https://docs.qgis.org/3.16/de/docs/user_manual/appendices/qgis_file_formats.html">https://docs.qgis.org/3.16/de/docs/user_manual/appendices/qgis_file_formats.html</a> -><o:p></o:p></span></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span lang="DE-CH" style="font-size:12.0pt;font-family:"Lato",sans-serif;color:#404040;background:#FCFCFC">Die <strong><span style="font-family:"Lato",sans-serif">QGD</span></strong>-Datei ist die zugehörige Sqlite-Datenbank des qgis-Projekts,
die Hilfsdaten für das Projekt enthält. </span><span lang="DE-CH"><o:p></o:p></span></p>
</blockquote>
<p class="MsoNormal"><span lang="DE-CH"><o:p> </o:p></span></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal"><span lang="DE-CH">Für postgis schick in in den nächsten Tagen nochmal was. Wir haben das bei uns immer mit einem service definitions file gelöst.<o:p></o:p></span></p>
</div>
</div>
</blockquote>
<p><span lang="DE-CH"><a href="https://wheregroup.com/blog/details/einfache-verbindung-von-postgresql-postgis-datenbanken-mit-qgis-mittels-mit-pg-serviceconf/">https://wheregroup.com/blog/details/einfache-verbindung-von-postgresql-postgis-datenbanken-mit-qgis-mittels-mit-pg-serviceconf/</a><o:p></o:p></span></p>
<p><span lang="DE-CH">Viele Grüße, Jörg<o:p></o:p></span></p>
<p><span lang="DE-CH">---------------------------------------------<br>
Schon gewusst?</span><span lang="DE-CH" style="font-family:"Tahoma",sans-serif">
</span><span lang="DE-CH"><br>
In unserem Blog geben wir Tipps & Tricks zu Open-Source-GIS-Software <br>
und berichten aus unserem Experten-Alltag:<br>
<a href="https://wheregroup.com/blog/">https://wheregroup.com/blog/</a><br>
---------------------------------------------<br>
<br>
<br>
Jörg Thomsen<br>
WhereGroup GmbH<br>
Bundesallee 23<br>
10717 Berlin<br>
Germany<br>
<br>
Tel: +49 (0)30 / 5130 278 74<br>
Fax: +49 (0)30 / 5130 278 11 <br>
<br>
<a href="mailto:joerg.thomsen@wheregroup.com">joerg.thomsen@wheregroup.com</a><br>
<a href="http://www.wheregroup.com">www.wheregroup.com</a><br>
<br>
Geschäftsführer:<br>
Olaf Knopp, Peter Stamm<br>
Amtsgericht Bonn, HRB 9885<br>
<br>
-------------------------------<br>
Folgen Sie der WhereGroup auf twitter: <a href="http://twitter.com/WhereGroup_com">
http://twitter.com/WhereGroup_com</a><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR-CH">-- <br>
Lizmap-de mailing list<br>
</span><span lang="DE-CH"><a href="mailto:Lizmap-de@lists.osgeo.org"><span lang="FR-CH">Lizmap-de@lists.osgeo.org</span></a></span><span lang="FR-CH"><br>
</span><span lang="DE-CH"><a href="https://lists.osgeo.org/mailman/listinfo/lizmap-de"><span lang="FR-CH">https://lists.osgeo.org/mailman/listinfo/lizmap-de</span></a></span><span lang="FR-CH"><o:p></o:p></span></p>
</div>
</blockquote>
</div>
<div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2">
<p class="MsoNormal"><span lang="DE-CH"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="1" cellspacing="3" cellpadding="0" style="border:none;border-top:solid #D3D4DE 1.0pt">
<tbody>
<tr>
<td width="55" style="width:41.25pt;border:none;padding:9.75pt .75pt .75pt .75pt">
<p class="MsoNormal"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank"><span style="border:solid windowtext 1.0pt;padding:0cm;text-decoration:none"><img border="0" width="46" height="29" style="width:.4791in;height:.3055in" id="Bild_x0020_1" src="cid:image002.jpg@01DA9634.59B26420" alt="Das Bild wurde vom Absender entfernt."></span></a><o:p></o:p></p>
</td>
<td width="470" style="width:352.5pt;border:none;padding:9.0pt .75pt .75pt .75pt">
<p class="MsoNormal" style="line-height:13.5pt"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#41424E">Virenfrei.<a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank"><span style="color:#4453EA">www.avast.com</span></a><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>