{"id":14903,"date":"2022-03-06T18:27:00","date_gmt":"2022-03-06T17:27:00","guid":{"rendered":"https:\/\/www.opengis.ch\/2022\/03\/06\/postgresql-postgis-administrator-course\/"},"modified":"2022-03-06T18:27:00","modified_gmt":"2022-03-06T17:27:00","slug":"postgresql-postgis-administrator-course","status":"publish","type":"post","link":"https:\/\/www.opengis.ch\/fr\/2022\/03\/06\/postgresql-postgis-administrator-course\/","title":{"rendered":"PostgreSQL\/PostGIS Administrator"},"content":{"rendered":"<p>Der Kurs richtet sich an PostgreSQL Benutzer, die ihre Administratoren-Kenntisse erweitern wollen. Es werden verschiedene Ans\u00e4tze erl\u00e4utert, um den Einsatz ihrer Datenbanken zu optimieren, und anhand von verschiedenen Beispielen ge\u00fcbt.<br \/>\nAm Ende des Kurses sind die Teilnehmer in der Lage, eigene Datenbank-Server, Datenbanken sowie deren User zu erstellen, verwalten und zu tunen. Zudem sind sie f\u00e4hig, sich die daf\u00fcr ben\u00f6tigten Informationen selbst zu beschaffen und kennen die wichtigsten Plattformen und Dokumentationen.<br \/>\nDie folgenden Themen werden behandelt:<\/p>\n<ul>\n<li>Einf\u00fchrung in PostgreSQL<\/li>\n<li>Serverkonfiguration (unter linux)<\/li>\n<li>Administration Datenbank<\/li>\n<li>Administration Dabenbanknutzer<\/li>\n<li>Rechte und Sicherheit<\/li>\n<li>Maintenance<\/li>\n<li>Monitoring<\/li>\n<li>Analyse Performance (Tipps and Tricks)<\/li>\n<li>Indexen<\/li>\n<\/ul>\n<p class=\"huge text-muted\">Der zweit\u00e4gige Kurs kostet xxx CHF pro Person. Die Kurskosten beinhalten die professionelle Unterst\u00fctzung w\u00e4hrend des Kurses, sowie die zwei Mittagessen.<\/p>\n<p>Ein Kursleiter f\u00fcr 4 bis 5 Teilnehmer, 2 Kursleiter f\u00fcr 6 bis 10 Teilnehmer.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Der Kurs richtet sich an PostgreSQL Benutzer, die ihre Administratoren-Kenntisse erweitern wollen. Es werden verschiedene Ans\u00e4tze erl\u00e4utert, um den Einsatz ihrer Datenbanken zu optimieren, und anhand von verschiedenen Beispielen ge\u00fcbt.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-14903","post","type-post","status-publish","format-standard","hentry","category-courses"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":14415,"url":"https:\/\/www.opengis.ch\/fr\/2024\/05\/28\/the-postgresql-connection-service-file-and-why-we-love-it\/","url_meta":{"origin":14903,"position":0},"title":"The PostgreSQL Connection Service File and Why We Love It","author":"Dave Signer","date":"28 mai 2024","format":false,"excerpt":"The PostgreSQL Connection Service File pg_service.conf has existed for quite some time and maybe you have already used it sometimes. We love it, and that is why we built the new QGIS plugin PG service parser hashtag#QGIS plugin. Read more about pg_service usages and the new plugin on our latest\u2026","rel":"","context":"Dans &quot;Interlis&quot;","block_context":{"text":"Interlis","link":"https:\/\/www.opengis.ch\/fr\/category\/gis\/interlis\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2024\/05\/pgserviceparser-1.png?fit=1200%2C750&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2024\/05\/pgserviceparser-1.png?fit=1200%2C750&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2024\/05\/pgserviceparser-1.png?fit=1200%2C750&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2024\/05\/pgserviceparser-1.png?fit=1200%2C750&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2024\/05\/pgserviceparser-1.png?fit=1200%2C750&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":12888,"url":"https:\/\/www.opengis.ch\/fr\/2022\/07\/26\/high-efficiency-with-buffered-transactional-editing-in-qgis\/","url_meta":{"origin":14903,"position":1},"title":"High Efficiency with Buffered Transactional Editing in QGIS","author":"Damiano","date":"26 juillet 2022","format":false,"excerpt":"Tired of start\/stop editing for every single layer in your project with mixed data sources?Starting from version 3.26, QGIS has a new transaction mode called \"Buffered Transaction Groups\". Within this mode, all layers which are not read-only are put in one \"transaction group\" and handled together when the actions \"Toggle\u2026","rel":"","context":"Dans &quot;Uncategorised&quot;","block_context":{"text":"Uncategorised","link":"https:\/\/www.opengis.ch\/fr\/category\/uncategorised\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2022\/06\/150740898-3f5c70e8-d441-441a-bc42-c458605f3bc8.png?fit=556%2C374&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2022\/06\/150740898-3f5c70e8-d441-441a-bc42-c458605f3bc8.png?fit=556%2C374&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2022\/06\/150740898-3f5c70e8-d441-441a-bc42-c458605f3bc8.png?fit=556%2C374&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":15450,"url":"https:\/\/www.opengis.ch\/fr\/2023\/02\/14\/postgis-with-qgis\/","url_meta":{"origin":14903,"position":2},"title":"PostGIS with QGIS (on request)","author":"Marco Bernasocchi","date":"14 f\u00e9vrier 2023","format":false,"excerpt":"The course is aimed at PostgreSQL users who want to expand their knowledge. Various approaches will be explained to optimize the use of their databases and practiced through different examples.","rel":"","context":"Dans &quot;Courses&quot;","block_context":{"text":"Courses","link":"https:\/\/www.opengis.ch\/fr\/category\/courses\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2024\/08\/DALL%C2%B7E-2024-08-12-15.09.25-A-professional-and-educational-themed-image-for-a-PostgreSQL-administration-course.-The-image-should-feature-a-laptop-displaying-a-PostgreSQL-interfac.webp?fit=1024%2C1024&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2024\/08\/DALL%C2%B7E-2024-08-12-15.09.25-A-professional-and-educational-themed-image-for-a-PostgreSQL-administration-course.-The-image-should-feature-a-laptop-displaying-a-PostgreSQL-interfac.webp?fit=1024%2C1024&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2024\/08\/DALL%C2%B7E-2024-08-12-15.09.25-A-professional-and-educational-themed-image-for-a-PostgreSQL-administration-course.-The-image-should-feature-a-laptop-displaying-a-PostgreSQL-interfac.webp?fit=1024%2C1024&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2024\/08\/DALL%C2%B7E-2024-08-12-15.09.25-A-professional-and-educational-themed-image-for-a-PostgreSQL-administration-course.-The-image-should-feature-a-laptop-displaying-a-PostgreSQL-interfac.webp?fit=1024%2C1024&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":15596,"url":"https:\/\/www.opengis.ch\/fr\/2025\/05\/28\/qgis-industry-solutions-developer\/","url_meta":{"origin":14903,"position":3},"title":"QGIS &amp; Industry Solutions Developer\u00a0| 80 \u2013 100% (Remote)","author":"Marco Bernasocchi","date":"28 mai 2025","format":false,"excerpt":"\ud83d\udda5\ufe0f\ud83d\ude80 Join OPENGIS.ch as a QGIS & Industry Solutions Developer! We\u2019re seeking a skilled C++ and Python developer to contribute to QGIS core, build plugins, and deliver custom geospatial solutions. Work remotely with a dynamic, open-source-focused team. Apply now to help shape the future of geospatial technology!","rel":"","context":"Dans &quot;Job Postings Archive&quot;","block_context":{"text":"Job Postings Archive","link":"https:\/\/www.opengis.ch\/fr\/category\/jobs\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/03\/image.png?fit=1200%2C1167&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/03\/image.png?fit=1200%2C1167&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/03\/image.png?fit=1200%2C1167&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/03\/image.png?fit=1200%2C1167&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2025\/03\/image.png?fit=1200%2C1167&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":14450,"url":"https:\/\/www.opengis.ch\/fr\/2025\/03\/21\/django-full-stack-engineer-with-devops-affinity-80-100-remote\/","url_meta":{"origin":14903,"position":4},"title":"Senior Django Full-Stack Engineer with DevOps Affinity | 80 &#8211; 100% (Remote)","author":"Marco Bernasocchi","date":"21 mars 2025","format":false,"excerpt":"\ud83c\udf0d\ud83d\ude80 Ready to shape the future of geospatial tech? Join us as a #Django #Full-Stack Engineer with a #DevOps edge! Work remotely, innovate with QFieldCloud, and be part of a dynamic, multicultural team of GeoNinjas. Apply today and lead the way!","rel":"","context":"Dans &quot;Job Postings Archive&quot;","block_context":{"text":"Job Postings Archive","link":"https:\/\/www.opengis.ch\/fr\/category\/jobs\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2024\/06\/django.jpg?fit=1200%2C686&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2024\/06\/django.jpg?fit=1200%2C686&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2024\/06\/django.jpg?fit=1200%2C686&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2024\/06\/django.jpg?fit=1200%2C686&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2024\/06\/django.jpg?fit=1200%2C686&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":3442,"url":"https:\/\/www.opengis.ch\/fr\/2018\/01\/08\/postgresql-back-end-solution-for-quality-assurance-and-data-archive\/","url_meta":{"origin":14903,"position":5},"title":"PostgreSQL back end solution for quality assurance and data archive","author":"Dave Signer","date":"8 janvier 2018","format":false,"excerpt":"Did you know that the possibilities to make a full QGIS back end solution for quality assurance and archiving in PostgreSQL are immense? SQL has it's well known limitations, but with a little bit creativity you can make quite nice solutions just using triggers and rules. In this post I'll\u2026","rel":"","context":"Dans &quot;QField&quot;","block_context":{"text":"QField","link":"https:\/\/www.opengis.ch\/fr\/category\/gis\/qfield\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2017\/12\/wald-1024x646.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2017\/12\/wald-1024x646.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.opengis.ch\/wp-content\/uploads\/2017\/12\/wald-1024x646.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]}],"jetpack_shortlink":"https:\/\/wp.me\/pbdBtI-3Sn","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.opengis.ch\/fr\/wp-json\/wp\/v2\/posts\/14903","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.opengis.ch\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.opengis.ch\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.opengis.ch\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.opengis.ch\/fr\/wp-json\/wp\/v2\/comments?post=14903"}],"version-history":[{"count":0,"href":"https:\/\/www.opengis.ch\/fr\/wp-json\/wp\/v2\/posts\/14903\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.opengis.ch\/fr\/wp-json\/wp\/v2\/media?parent=14903"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.opengis.ch\/fr\/wp-json\/wp\/v2\/categories?post=14903"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.opengis.ch\/fr\/wp-json\/wp\/v2\/tags?post=14903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}