<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:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Lato;
panose-1:2 15 5 2 2 2 4 3 2 3;}
@font-face
{font-family:"Open Sans";}
/* 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:"Calibri",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:1509753032;
mso-list-template-ids:1052818694;}
@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-CH link=blue vlink=purple style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Hallo Matthias<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'>Das kann ich so bestätigen. Danke für dein Feedback.<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 habe zum Testen in pg_service.conf dies angelegt.<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'>[testlocal]<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>host=localhost<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>port=5432<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>user=postgres<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>password=@@@@@<o:p></o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>dbname=test<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'>Dann mit «norGIS ALKIS Import» in Windows 11 ein Alkis XML-File erfolgreich in die DB importiert.<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><img width=844 height=418 style='width:8.7916in;height:4.3541in' id="Grafik_x0020_3" src="cid:image001.jpg@01DA9CC4.9E02D600"><o:p></o:p></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Danach in QGIS 3.34 mit dem ALKIS Plugin die DB in QGIS importiert. Hat alles geklappt!<o:p></o:p></span></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><img width=575 height=505 style='width:5.993in;height:5.2638in' id="Grafik_x0020_4" src="cid:image003.jpg@01DA9CC4.9E02D600"><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><img width=816 height=591 style='width:8.5in;height:6.1527in' id="Grafik_x0020_5" src="cid:image004.jpg@01DA9CC4.9E02D600"><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><img width=657 height=598 style='width:6.8402in;height:6.2291in' id="Grafik_x0020_6" src="cid:image005.jpg@01DA9CC4.9E02D600"><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Einzig mit Lizmap habe ich dann Probleme gehabt, die ich bis jetzt nicht gelöst habe.<o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Gruss, Peter<o:p></o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=DE>Von:</span></b><span lang=DE> Lizmap-de <lizmap-de-bounces@lists.osgeo.org> <b>Im Auftrag von </b>GIS | Reuther NetConsulting via Lizmap-de<br><b>Gesendet:</b> Donnerstag, 2. Mai 2024 13:04<br><b>An:</b> lizmap-de@lists.osgeo.org<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></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'>Hallo zusammen,<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'>noch ein Update zum Verwenden der pg_service Konfiguration.<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'>Wir haben die Datenbank neu angelegt, die ALKIS-Daten wieder eingespielt, sowie den Eintrag in pg_service erneuert und eine neue QGIS-Datei aufgebaut. <o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'>Jetzt funktioniert alles nachvollzierbar mit der pg_service Konfiguration im Zusammenspiel mit unserer Postgres DB, auch mit den ALKIS-Daten und der Einbindung über norGIS ALKIS-Import.<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'>Grüße<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'>Matthias<o:p></o:p></span></p><p class=MsoNormal><span lang=DE 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><span lang=DE>Von:</span></b><span lang=DE> GIS | Reuther NetConsulting <br><b>Gesendet:</b> Mittwoch, 24. April 2024 11:03<br><b>An:</b> Peter Berger <<a href="mailto:peter.berger@bluewin.ch">peter.berger@bluewin.ch</a>>; <a href="mailto:lizmap-de@lists.osgeo.org">lizmap-de@lists.osgeo.org</a><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></span></p></div></div><p class=MsoNormal><span lang=DE><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'>Hallo Peter,<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE 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 lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE 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 lang=DE 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 lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE 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 lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE 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 lang=DE 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 lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE 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 lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE 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 lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'>Viele Grüße<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'>Matthias<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE 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><span lang=DE>Von:</span></b><span lang=DE> Peter Berger <<a href="mailto:peter.berger@bluewin.ch">peter.berger@bluewin.ch</a>> <br><b>Gesendet:</b> Mittwoch, 24. April 2024 10:25<br><b>An:</b> GIS | Reuther NetConsulting <<a href="mailto:gis@r-nc.de">gis@r-nc.de</a>>; <a href="mailto:lizmap-de@lists.osgeo.org">lizmap-de@lists.osgeo.org</a><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></span></p></div></div><p class=MsoNormal><span lang=DE><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Hallo Matthias<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'>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 style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Liebe Grüsse<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'>Peter<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><span lang=DE>Von:</span></b><span lang=DE> 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></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'>Hallo zusammen,<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE 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 lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE 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 lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE 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 lang=DE 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 lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE 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 lang=DE 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 lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE><img border=0 width=189 height=313 style='width:1.9652in;height:3.2638in' id="Grafik_x0020_2" src="cid:image011.jpg@01DA9CC4.9E02D600"></span><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE 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 lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'>Matthias<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='font-family:"Aptos",sans-serif;mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE 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><span lang=DE>Von:</span></b><span lang=DE> 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></span></p></div></div><p class=MsoNormal><span lang=DE><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='mso-fareast-language:EN-US'>Hallo zusammen,<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE 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 lang=DE style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE 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 lang=DE style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='mso-fareast-language:EN-US'>Viele Grüße<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE style='mso-fareast-language:EN-US'>Günter<o:p></o:p></span></p><p class=MsoNormal><span lang=DE style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span lang=DE 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><span lang=DE>Von:</span></b><span lang=DE> 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></span></p></div></div><p class=MsoNormal><span lang=DE><o:p> </o:p></span></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'>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 style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span 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 style='mso-fareast-language:EN-US'>Meine Erfahrungen:<o:p></o:p></span></p><p class=MsoNormal><span 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 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 style='font-size:10.0pt;background:lime;mso-highlight:lime'>~/.pg_service.conf</span></code><code><span style='font-size:10.0pt'> </span></code><span 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 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'>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 <code><span style='font-size:10.0pt'>~/.pg_service.conf File </span></code>im Verzeichnis des anderen User nicht sieht. Also müsste ich das File an mehreren Ort haben. Nicht praktikabel!<o:p></o:p></li><li class=MsoListParagraph style='margin-left:0cm;mso-list:l1 level1 lfo3'>Ich habe dann entschieden, dass ich das Ganze systemweit verfügbar mache indem ich <code><span style='font-size:10.0pt'>pg_config –sysconfdir </span></code>aufrufe. Da kommt dies raus<code><span style='font-size:10.0pt'> /etc/postgresql-common</span></code>. Nun habe ich das File <code><span style='font-size:10.0pt'>~/.pg_service.conf </span></code>in diesen Ordner kopiert. Funktionierte nicht! Hmm… Aha, das File hat dort einen anderen Namen nicht <code><span style='font-size:10.0pt;background:red;mso-highlight:red'>~/.pg_service.conf</span></code><code><span style='font-size:10.0pt'> </span></code>sondern <code><span style='font-size:10.0pt;background:lime;mso-highlight:lime'>~/pg_service.conf</span></code>. Also ohne führenden Punkt. Nun hat es funktioniert!<span 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'>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></li></ul><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span 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 style='mso-fareast-language:EN-US'><o:p> </o:p></span></p><p class=MsoNormal><span style='mso-fareast-language:EN-US'>Gruss, Peter<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><span lang=DE>Von:</span></b><span lang=DE> 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></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hallo Jörg<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Vielen Dank für deinen Beitrag. Wir haben also diese Möglichkeiten: <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Die Credentials in ein dezidiertes File einzubinden, pg_service.conf.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>In ein QGIS-File händisch pro Layer einzutragen.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>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></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Wie immer, das mit dem pg_service.conf funktioniert. Ich werde in Zukunft diesen Weg gehen. <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Liebe Grüsse<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Peter<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal style='margin-bottom:12.0pt'>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></p></blockquote></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal> <o:p></o:p></p><div><p class=MsoNormal>Moin,<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>ein Zwischenruf von der Seite.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><p>> Da ist zwar noch ein weiteres File dabei, ich hab aber nie rausgefunden, wofür das ist. <o:p></o:p></p><p><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></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><span 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><o:p></o:p></p></blockquote><p class=MsoNormal><o:p> </o:p></p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><p class=MsoNormal>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></p></div></div></blockquote><p><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></p><p>Viele Grüße, Jörg<o:p></o:p></p><p>---------------------------------------------<br>Schon gewusst?<span style='font-family:"Tahoma",sans-serif'>
</span><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></p><p class=MsoNormal><span lang=FR-CH>-- <br>Lizmap-de mailing list<br></span><a href="mailto:Lizmap-de@lists.osgeo.org"><span lang=FR-CH>Lizmap-de@lists.osgeo.org</span></a><span lang=FR-CH><br></span><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 lang=FR-CH><o:p></o:p></span></p></div></blockquote></div><div id=DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2><p class=MsoNormal><o:p> </o:p></p><table class=MsoNormalTable border=1 cellspacing=3 cellpadding=0 style='border:none;border-top:solid #D3D4DE 1.0pt'><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:image012.jpg@01DA9CC4.9E02D600" 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></table><p class=MsoNormal><span lang=DE><o:p> </o:p></span></p></div></div></body></html>