{"id":4725,"date":"2023-04-25T15:38:13","date_gmt":"2023-04-25T13:38:13","guid":{"rendered":"https:\/\/www.dbi-services.com\/courses\/postgresql-dba-les-essentiels\/"},"modified":"2026-04-02T07:59:28","modified_gmt":"2026-04-02T05:59:28","slug":"postgresql-dba-les-essentiels","status":"publish","type":"courses","link":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/","title":{"rendered":"PostgreSQL DBA – les essentiels"},"content":{"rendered":"
\n\n
\"\"<\/figure>\n\n<\/div><\/div><\/section>

Objectifs<\/h2>
\n\n

<\/h2>
  • Comprendre l\u2019architecture PostgreSQL<\/li>
  • Comment PostgreSQL organise les fichiers sur le disque<\/li>
  • Installer PostgreSQL \u00e0 partir des sources<\/li>
  • Comprendre les points communs et les diff\u00e9rences avec d\u2019autres bases de donn\u00e9es telles qu\u2019Oracle<\/li>
  • Cr\u00e9er des bases de donn\u00e9es<\/li>
  • S\u2019habituer \u00e0 l\u2019interface de ligne de commande : psql<\/li>
  • Comprendre les proc\u00e9dures de sauvegarde et de restauration dans PostgreSQL<\/li>
  • Comprendre les outils de surveillance<\/li>
  • Cr\u00e9er une base de donn\u00e9es de secours \u00e0 chaud<\/li>
  • Comprendre les options de haute disponibilit\u00e9 de PostgreSQL<\/li>
  • Comprendre l\u2019optimiseur, les statistiques et le processus de vacuuming<\/li>
  • Mises \u00e0 niveau de PostgreSQL<\/li><\/ul>\n\n<\/div><\/div><\/section>

    M\u00e9thode<\/h2>

    <\/p>

    \n\n

    <\/h2>
    • Pr\u00e9sentations, exercices pratiques, \u00e9tudes de cas et d\u00e9monstrations orient\u00e9es en fonction des questions<\/li>
    • Discussion et networking durant les pauses et le repas de midi (inclus)<\/li><\/ul>\n\n<\/div><\/div><\/section>

      Cibles<\/h2>

      <\/p>

      \n\n

      <\/h2>
      • Cette formation PostgreSQL DBA les essentiels s\u2019adresse aux administrateurs de bases de donn\u00e9es (DBA) ainsi qu\u2019aux administrateurs de r\u00e9seaux, de syst\u00e8mes et d\u2019applications.<\/li><\/ul>\n\n<\/div><\/div><\/section>

        <\/h3>

        Pr\u00e9requis<\/h2>
        \n\n

        <\/h2>
        • Savoir naviguer sur Linux shell<\/li>
        • Avoir des notions \u00e9l\u00e9mentaires en mati\u00e8re de bases de donn\u00e9es<\/li><\/ul>\n\n<\/div><\/div><\/section>

          <\/h2>

          R\u00e9duction de 5% pour les membres du SOUG, du SwissPUG et de la DOAG.<\/strong><\/p><\/div><\/section>","protected":false},"author":4,"featured_media":8251,"template":"","meta":{"_acf_changed":false},"categories":[35,39],"location":[23],"class_list":["post-4725","courses","type-courses","status-publish","has-post-thumbnail","hentry","category-database","category-open-source","location-zurich"],"acf":[],"yoast_head":"\nPostgreSQL DBA - les essentiels - dbi services<\/title>\n<meta name=\"description\" content=\"Ce cours vous apprend l\u2019architecture PostgreSQL, les bonnes pratiques de DBA sur PostgreSQL ainsi que les diff\u00e9rentes options de haute disponibilit\u00e9.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL DBA - les essentiels\" \/>\n<meta property=\"og:description\" content=\"Ce cours vous apprend l\u2019architecture PostgreSQL, les bonnes pratiques de DBA sur PostgreSQL ainsi que les diff\u00e9rentes options de haute disponibilit\u00e9.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-02T05:59:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-DBA-Essential-workshop-website.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"1200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/\",\"url\":\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/\",\"name\":\"PostgreSQL DBA - les essentiels - dbi services\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-DBA-Essential-workshop-website.png\",\"datePublished\":\"2023-04-25T13:38:13+00:00\",\"dateModified\":\"2026-04-02T05:59:28+00:00\",\"description\":\"Ce cours vous apprend l\u2019architecture PostgreSQL, les bonnes pratiques de DBA sur PostgreSQL ainsi que les diff\u00e9rentes options de haute disponibilit\u00e9.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-DBA-Essential-workshop-website.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-DBA-Essential-workshop-website.png\",\"width\":1200,\"height\":1200},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dbi-services.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formations\",\"item\":\"https:\/\/www.dbi-services.com\/fr\/formations\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PostgreSQL DBA – les essentiels\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/fr\/\",\"name\":\"dbi services\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi services\",\"url\":\"https:\/\/www.dbi-services.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png\",\"width\":3230,\"height\":1100,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/dbiservices\/\",\"https:\/\/x.com\/dbiservices\",\"https:\/\/www.linkedin.com\/company\/dbi-services\/\",\"https:\/\/www.youtube.com\/user\/dbiservices\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL DBA - les essentiels - dbi services","description":"Ce cours vous apprend l\u2019architecture PostgreSQL, les bonnes pratiques de DBA sur PostgreSQL ainsi que les diff\u00e9rentes options de haute disponibilit\u00e9.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/","og_locale":"fr_FR","og_type":"article","og_title":"PostgreSQL DBA - les essentiels","og_description":"Ce cours vous apprend l\u2019architecture PostgreSQL, les bonnes pratiques de DBA sur PostgreSQL ainsi que les diff\u00e9rentes options de haute disponibilit\u00e9.","og_url":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/","og_site_name":"dbi services","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_modified_time":"2026-04-02T05:59:28+00:00","og_image":[{"width":1200,"height":1200,"url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-DBA-Essential-workshop-website.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@dbiservices","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/","url":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/","name":"PostgreSQL DBA - les essentiels - dbi services","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-DBA-Essential-workshop-website.png","datePublished":"2023-04-25T13:38:13+00:00","dateModified":"2026-04-02T05:59:28+00:00","description":"Ce cours vous apprend l\u2019architecture PostgreSQL, les bonnes pratiques de DBA sur PostgreSQL ainsi que les diff\u00e9rentes options de haute disponibilit\u00e9.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/#primaryimage","url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-DBA-Essential-workshop-website.png","contentUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-DBA-Essential-workshop-website.png","width":1200,"height":1200},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-dba-les-essentiels\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Formations","item":"https:\/\/www.dbi-services.com\/fr\/formations\/"},{"@type":"ListItem","position":3,"name":"PostgreSQL DBA – les essentiels"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/fr\/#website","url":"https:\/\/www.dbi-services.com\/fr\/","name":"dbi services","description":"","publisher":{"@id":"https:\/\/www.dbi-services.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/fr\/#organization","name":"dbi services","alternateName":"dbi services","url":"https:\/\/www.dbi-services.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png","width":3230,"height":1100,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"]}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/courses\/4725","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/courses"}],"about":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/types\/courses"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/users\/4"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/media\/8251"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/media?parent=4725"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/categories?post=4725"},{"taxonomy":"location","embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/location?post=4725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}