{"id":530,"date":"2024-02-29T19:08:35","date_gmt":"2024-02-29T18:08:35","guid":{"rendered":"http:\/\/192.168.10.110:8080\/?page_id=530"},"modified":"2024-02-29T19:08:36","modified_gmt":"2024-02-29T18:08:36","slug":"pgsql-adm1","status":"publish","type":"page","link":"http:\/\/192.168.10.110:8080\/formations\/pgsql-adm1\/","title":{"rendered":"PostgreSQL \u2013 Administration pgsql-adm1"},"content":{"rendered":"\n<blockquote class=\"wp-block-quote gutenify-section-c2a08790-d72b-11ee-a3b8-7700caf856eb\">\n<p class=\"gutenify-section-d55e0cf0-d0db-11ee-abfb-11c4823c551e\">Installer, administrer et exploiter des serveurs de bases de donn\u00e9es PostgreSQL.<\/p>\n<\/blockquote>\n\n\n\n<h1 class=\"wp-block-heading gutenify-section-daa9a2e0-d72b-11ee-a3b8-7700caf856eb\">Objectifs p\u00e9dagogiques<\/h1>\n\n\n\n<p class=\"gutenify-section-daaa6630-d72b-11ee-a3b8-7700caf856eb\">\u00c0 l\u2019issue de cette formation, le stagiaire sera en mesure de\u00a0:<\/p>\n\n\n\n<ul class=\"gutenify-section-dab11cf0-d72b-11ee-a3b8-7700caf856eb\">\n<li class=\"gutenify-section-daac13e0-d72b-11ee-a3b8-7700caf856eb\">conna\u00eetre l\u2019architecture de PostgreSQL,<\/li>\n\n\n\n<li class=\"gutenify-section-daacfe40-d72b-11ee-a3b8-7700caf856eb\">installer, configurer et mettre \u00e0 jour une instance PostgreSQL,<\/li>\n\n\n\n<li class=\"gutenify-section-daad9a80-d72b-11ee-a3b8-7700caf856eb\">cr\u00e9er des instances, des bases de donn\u00e9es\u2026,<\/li>\n\n\n\n<li class=\"gutenify-section-daae36c0-d72b-11ee-a3b8-7700caf856eb\">g\u00e9rer les droits et les acc\u00e8s aux bases de donn\u00e9es,<\/li>\n\n\n\n<li class=\"gutenify-section-daaeabf0-d72b-11ee-a3b8-7700caf856eb\">assurer la maintenance,<\/li>\n\n\n\n<li class=\"gutenify-section-2a92f130-d72c-11ee-a3b8-7700caf856eb\">r\u00e9aliser les sauvegardes d\u2019instances et\/ou de bases de donn\u00e9es.<\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading gutenify-section-2c37eea0-d72c-11ee-a3b8-7700caf856eb\">Programme<\/h1>\n\n\n\n<ol class=\"gutenify-section-079ec590-d72d-11ee-a3b8-7700caf856eb\">\n<li class=\"gutenify-section-2c38b1f0-d72c-11ee-a3b8-7700caf856eb\">Introduction\n<ul class=\"gutenify-section-2c3ca990-d72c-11ee-a3b8-7700caf856eb\">\n<li class=\"gutenify-section-2c39ea70-d72c-11ee-a3b8-7700caf856eb\">Pr\u00e9sentation, historique, versionnement, licence<\/li>\n\n\n\n<li class=\"gutenify-section-2c3aadc0-d72c-11ee-a3b8-7700caf856eb\">L\u2019\u00e9cosyst\u00e8me<\/li>\n\n\n\n<li class=\"gutenify-section-2c3b4a00-d72c-11ee-a3b8-7700caf856eb\">Les composants du serveur PostgreSQL : serveur, client, connecteurs jdbc, tcl, pl, python<\/li>\n\n\n\n<li class=\"gutenify-section-2c3be640-d72c-11ee-a3b8-7700caf856eb\">Les outils compl\u00e9mentaires<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li class=\"gutenify-section-2c3d45d0-d72c-11ee-a3b8-7700caf856eb\">Installation\n<ul class=\"gutenify-section-2c4227d0-d72c-11ee-a3b8-7700caf856eb\">\n<li class=\"gutenify-section-2c3e7e50-d72c-11ee-a3b8-7700caf856eb\">Choix du produit \u00e0 installer : les RPMs, le code compil\u00e9 ou les sources<\/li>\n\n\n\n<li class=\"gutenify-section-2c4004f0-d72c-11ee-a3b8-7700caf856eb\">Installation<\/li>\n\n\n\n<li class=\"gutenify-section-2c40a130-d72c-11ee-a3b8-7700caf856eb\">Les binaires, organisation du r\u00e9pertoire<\/li>\n\n\n\n<li class=\"gutenify-section-2c416480-d72c-11ee-a3b8-7700caf856eb\">Con\ufb01guration, postgresql.conf<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li class=\"gutenify-section-2c42c410-d72c-11ee-a3b8-7700caf856eb\">S\u00e9curit\u00e9\n<ul class=\"gutenify-section-2c461f70-d72c-11ee-a3b8-7700caf856eb\">\n<li class=\"gutenify-section-2c444ab0-d72c-11ee-a3b8-7700caf856eb\">Syst\u00e8me des privil\u00e8ges : principe de fonctionnement, authentification, contr\u00f4le des droits pour les requ\u00eates<\/li>\n\n\n\n<li class=\"gutenify-section-2c44e6f0-d72c-11ee-a3b8-7700caf856eb\">Gestion des comptes utilisateurs : cr\u00e9ation\/suppression de comptes, limitation des ressources, s\u00e9curisation des acc\u00e8s (\ufb01chier pg_hba.conf)<\/li>\n\n\n\n<li class=\"gutenify-section-2c458330-d72c-11ee-a3b8-7700caf856eb\">Mapping avec les utilisateurs syst\u00e8mes : pg_ident.conf<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li class=\"gutenify-section-2c46e2c0-d72c-11ee-a3b8-7700caf856eb\">Utilisation\n<ul class=\"gutenify-section-2c4c39f0-d72c-11ee-a3b8-7700caf856eb\">\n<li class=\"gutenify-section-2c486960-d72c-11ee-a3b8-7700caf856eb\">Commande psql<\/li>\n\n\n\n<li class=\"gutenify-section-2c492cb0-d72c-11ee-a3b8-7700caf856eb\">Cr\u00e9ation d\u2019une instance, d\u2019une base de donn\u00e9es&#8230;<\/li>\n\n\n\n<li class=\"gutenify-section-2c4ab350-d72c-11ee-a3b8-7700caf856eb\">Les m\u00e9ta-commandes en \\xxx<\/li>\n\n\n\n<li class=\"gutenify-section-2c4b4f90-d72c-11ee-a3b8-7700caf856eb\">pgadmin : installation, con\ufb01guration<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li class=\"gutenify-section-8f858850-d72c-11ee-a3b8-7700caf856eb\">Exploitation\n<ul class=\"gutenify-section-d4040470-d72c-11ee-a3b8-7700caf856eb\">\n<li class=\"gutenify-section-97d055d0-d72c-11ee-a3b8-7700caf856eb\">Sauvegardes\/restaurations, pg_dump, pg_dumpall, pg_restaure<\/li>\n\n\n\n<li class=\"gutenify-section-97d3d840-d72c-11ee-a3b8-7700caf856eb\">M\u00e9thode de sauvegarde des donn\u00e9es PostgreSQL<\/li>\n\n\n\n<li class=\"gutenify-section-97d585f0-d72c-11ee-a3b8-7700caf856eb\">Maintenance : vacuumdb, reindex<\/li>\n\n\n\n<li class=\"gutenify-section-06c0c1a0-d72d-11ee-a3b8-7700caf856eb\">Mise \u00e0 jour vs Mont\u00e9e de niveaux : copie de serveur \u00e0 serveur, r\u00e9plication<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p class=\"gutenify-section-07a184b0-d72d-11ee-a3b8-7700caf856eb\">SIGMAZ Consilium vous accompagne dans la d\u00e9finition de vos besoins (p\u00e9rim\u00e8tre, granularit\u00e9, format, donn\u00e9es attributaires, etc) afin de vous proposer une solution personnalis\u00e9e.<\/p>\n\n\n\n<ol class=\"gutenify-section-2c394e30-d72c-11ee-a3b8-7700caf856eb\"><\/ol>\n\n\n\n<div data-wp-interactive=\"\" class=\"wp-block-file gutenify-section-dc59ec40-d0db-11ee-abfb-11c4823c551e\"><object data-wp-bind--hidden=\"!selectors.core.file.hasPdfPreview\" hidden class=\"wp-block-file__embed\" data=\"http:\/\/192.168.10.110:8080\/wp-content\/uploads\/2024\/02\/pgsql-adm1_PostgreSQL_Administration.pdf\" type=\"application\/pdf\" style=\"width:100%;height:600px\" aria-label=\"Contenu embarqu\u00e9 pgsql-adm1_2024-02.\"><\/object><a id=\"wp-block-file--media-69213ce3-f749-4d7c-a25b-f635fc7bd03c\" href=\"http:\/\/192.168.10.110:8080\/wp-content\/uploads\/2024\/02\/pgsql-adm1_PostgreSQL_Administration.pdf\">pgsql-adm1_2024-02<\/a><a href=\"http:\/\/192.168.10.110:8080\/wp-content\/uploads\/2024\/02\/pgsql-adm1_PostgreSQL_Administration.pdf\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-69213ce3-f749-4d7c-a25b-f635fc7bd03c\">T\u00e9l\u00e9charger<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Installer, administrer et exploiter des serveurs de bases de donn\u00e9es PostgreSQL. Objectifs p\u00e9dagogiques \u00c0 l\u2019issue [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":274,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","gutenify_custom_css":"","gutenify_custom_css_data":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL \u2013 Administration pgsql-adm1 - SIGMAZ Consilium<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/192.168.10.110:8080\/formations\/pgsql-adm1\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL \u2013 Administration pgsql-adm1 - SIGMAZ Consilium\" \/>\n<meta property=\"og:description\" content=\"Installer, administrer et exploiter des serveurs de bases de donn\u00e9es PostgreSQL. Objectifs p\u00e9dagogiques \u00c0 l\u2019issue [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"http:\/\/192.168.10.110:8080\/formations\/pgsql-adm1\/\" \/>\n<meta property=\"og:site_name\" content=\"SIGMAZ Consilium\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-29T18:08:36+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@SigmazConsilium\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/192.168.10.110:8080\/formations\/pgsql-adm1\/\",\"url\":\"http:\/\/192.168.10.110:8080\/formations\/pgsql-adm1\/\",\"name\":\"PostgreSQL \u2013 Administration pgsql-adm1 - SIGMAZ Consilium\",\"isPartOf\":{\"@id\":\"http:\/\/192.168.10.110:8080\/#website\"},\"datePublished\":\"2024-02-29T18:08:35+00:00\",\"dateModified\":\"2024-02-29T18:08:36+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/192.168.10.110:8080\/formations\/pgsql-adm1\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/192.168.10.110:8080\/formations\/pgsql-adm1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/192.168.10.110:8080\/formations\/pgsql-adm1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"http:\/\/192.168.10.110:8080\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formations\",\"item\":\"http:\/\/192.168.10.110:8080\/formations\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PostgreSQL \u2013 Administration pgsql-adm1\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/192.168.10.110:8080\/#website\",\"url\":\"http:\/\/192.168.10.110:8080\/\",\"name\":\"SIGMAZ Consilium\",\"description\":\"Cogit\u00e4re optimum\",\"publisher\":{\"@id\":\"http:\/\/192.168.10.110:8080\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/192.168.10.110:8080\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/192.168.10.110:8080\/#organization\",\"name\":\"SIGMAZ Consilium\",\"url\":\"http:\/\/192.168.10.110:8080\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"http:\/\/192.168.10.110:8080\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/192.168.10.110:8080\/wp-content\/uploads\/2022\/10\/Logo-complet-Sigmaz-Consilium-367x150-1.png\",\"contentUrl\":\"http:\/\/192.168.10.110:8080\/wp-content\/uploads\/2022\/10\/Logo-complet-Sigmaz-Consilium-367x150-1.png\",\"width\":367,\"height\":150,\"caption\":\"SIGMAZ Consilium\"},\"image\":{\"@id\":\"http:\/\/192.168.10.110:8080\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/twitter.com\/SigmazConsilium\",\"https:\/\/www.linkedin.com\/company\/sigmaz-consilium\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL \u2013 Administration pgsql-adm1 - SIGMAZ Consilium","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":"http:\/\/192.168.10.110:8080\/formations\/pgsql-adm1\/","og_locale":"fr_FR","og_type":"article","og_title":"PostgreSQL \u2013 Administration pgsql-adm1 - SIGMAZ Consilium","og_description":"Installer, administrer et exploiter des serveurs de bases de donn\u00e9es PostgreSQL. Objectifs p\u00e9dagogiques \u00c0 l\u2019issue [&hellip;]","og_url":"http:\/\/192.168.10.110:8080\/formations\/pgsql-adm1\/","og_site_name":"SIGMAZ Consilium","article_modified_time":"2024-02-29T18:08:36+00:00","twitter_card":"summary_large_image","twitter_site":"@SigmazConsilium","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/192.168.10.110:8080\/formations\/pgsql-adm1\/","url":"http:\/\/192.168.10.110:8080\/formations\/pgsql-adm1\/","name":"PostgreSQL \u2013 Administration pgsql-adm1 - SIGMAZ Consilium","isPartOf":{"@id":"http:\/\/192.168.10.110:8080\/#website"},"datePublished":"2024-02-29T18:08:35+00:00","dateModified":"2024-02-29T18:08:36+00:00","breadcrumb":{"@id":"http:\/\/192.168.10.110:8080\/formations\/pgsql-adm1\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["http:\/\/192.168.10.110:8080\/formations\/pgsql-adm1\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/192.168.10.110:8080\/formations\/pgsql-adm1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"http:\/\/192.168.10.110:8080\/"},{"@type":"ListItem","position":2,"name":"Formations","item":"http:\/\/192.168.10.110:8080\/formations\/"},{"@type":"ListItem","position":3,"name":"PostgreSQL \u2013 Administration pgsql-adm1"}]},{"@type":"WebSite","@id":"http:\/\/192.168.10.110:8080\/#website","url":"http:\/\/192.168.10.110:8080\/","name":"SIGMAZ Consilium","description":"Cogit\u00e4re optimum","publisher":{"@id":"http:\/\/192.168.10.110:8080\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/192.168.10.110:8080\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"http:\/\/192.168.10.110:8080\/#organization","name":"SIGMAZ Consilium","url":"http:\/\/192.168.10.110:8080\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"http:\/\/192.168.10.110:8080\/#\/schema\/logo\/image\/","url":"http:\/\/192.168.10.110:8080\/wp-content\/uploads\/2022\/10\/Logo-complet-Sigmaz-Consilium-367x150-1.png","contentUrl":"http:\/\/192.168.10.110:8080\/wp-content\/uploads\/2022\/10\/Logo-complet-Sigmaz-Consilium-367x150-1.png","width":367,"height":150,"caption":"SIGMAZ Consilium"},"image":{"@id":"http:\/\/192.168.10.110:8080\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/twitter.com\/SigmazConsilium","https:\/\/www.linkedin.com\/company\/sigmaz-consilium\/"]}]}},"_links":{"self":[{"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/pages\/530"}],"collection":[{"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/comments?post=530"}],"version-history":[{"count":5,"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/pages\/530\/revisions"}],"predecessor-version":[{"id":541,"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/pages\/530\/revisions\/541"}],"up":[{"embeddable":true,"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/pages\/274"}],"wp:attachment":[{"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/media?parent=530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}