{"id":4816,"date":"2023-04-27T22:58:29","date_gmt":"2023-04-27T22:58:29","guid":{"rendered":"https:\/\/www.webhi.com\/how-to\/?p=4816"},"modified":"2023-04-27T22:58:32","modified_gmt":"2023-04-27T22:58:32","slug":"installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04","status":"publish","type":"post","link":"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/","title":{"rendered":"Installation de PostgreSQL dans Ubuntu 18.04 \/ 20.04 \/ 22.04"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1200\" height=\"675\" src=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/04\/postgresql_ubuntu_fr.jpg\" alt=\"Guide \u00e9tape par \u00e9tape processus d'installation PostgreSQL\" class=\"wp-image-4843\" srcset=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/04\/postgresql_ubuntu_fr.jpg 1200w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/04\/postgresql_ubuntu_fr-300x169.jpg 300w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/04\/postgresql_ubuntu_fr-1024x576.jpg 1024w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/04\/postgresql_ubuntu_fr-768x432.jpg 768w, https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/04\/postgresql_ubuntu_fr-150x84.jpg 150w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/figure>\n\n\n\n<p><strong>PostgreSQL <\/strong>est un syst\u00e8me de gestion de bases de donn\u00e9es relationnelles puissant et open-source. Il est largement utilis\u00e9 pour le stockage et la r\u00e9cup\u00e9ration des donn\u00e9es dans les applications modernes.<\/p>\n\n\n\n<p>Dans ce guide, nous allons apprendre \u00e0 installer PostgreSQL sur Ubuntu, \u00e0 cr\u00e9er un nouveau r\u00f4le et une nouvelle base de donn\u00e9es.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"%C3%A9tape-1---mettre-%C3%A0-jour-lindex-des-paquets-dubuntu\">\u00c9tape 1 &#8211; Mettre \u00e0 jour l&#8217;index des paquets d&#8217;Ubuntu<\/h2>\n\n\n\n<p>Avant d&#8217;installer un paquet dans Ubuntu, il est toujours bon de mettre \u00e0 jour l&#8217;index des paquets du syst\u00e8me. Cela permet de s&#8217;assurer que vous disposez des derni\u00e8res informations sur les paquets et les d\u00e9pendances n\u00e9cessaires \u00e0 l&#8217;installation.<\/p>\n\n\n\n<p>Ouvrez un terminal et ex\u00e9cutez la commande suivante :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo apt update<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"%C3%A9tape-2---installer-postgresql\">\u00c9tape 2 &#8211; Installer PostgreSQL<\/h2>\n\n\n\n<p>Pour installer PostgreSQL sur Ubuntu, ex\u00e9cutez la commande suivante :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo apt install postgresql postgresql-contrib<\/code><\/pre>\n\n\n\n<p>Cette commande installera les paquets serveur et client PostgreSQL ainsi que les paquets contrib additionnels.<\/p>\n\n\n\n<p>Au cours du processus d&#8217;installation, vous serez invit\u00e9 \u00e0 cr\u00e9er un mot de passe pour le superutilisateur de la base de donn\u00e9es PostgreSQL (postgres).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"%C3%A9tape-3---v%C3%A9rifier-linstallation-de-postgresql\">\u00c9tape 3 &#8211; V\u00e9rifier l&#8217;installation de PostgreSQL<\/h2>\n\n\n\n<p>Pour v\u00e9rifier que PostgreSQL est install\u00e9 et fonctionne, vous pouvez ex\u00e9cuter la commande suivante :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo systemctl status postgresql<\/code><\/pre>\n\n\n\n<p>Cette commande vous montrera l&#8217;\u00e9tat du service PostgreSQL. Si le service est en cours d&#8217;ex\u00e9cution, vous devriez voir un message indiquant qu&#8217;il est actif.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"%C3%A9tape-4---acc%C3%A9der-%C3%A0-postgresql\">\u00c9tape 4 &#8211; Acc\u00e9der \u00e0 PostgreSQL<\/h2>\n\n\n\n<p>Pour acc\u00e9der \u00e0 PostgreSQL, vous pouvez utiliser l&#8217;interface de ligne de commande psql. Pour lancer l&#8217;interpr\u00e9teur de commandes psql, ex\u00e9cutez la commande suivante :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo -u postgres psql<\/code><\/pre>\n\n\n\n<p>Ceci vous connectera en tant que superutilisateur de PostgreSQL (postgres) et vous donnera acc\u00e8s \u00e0 l&#8217;interface de ligne de commande de PostgreSQL.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"etape-5---cr%C3%A9er-un-nouveau-r%C3%B4le\">Etape 5 &#8211; Cr\u00e9er un nouveau r\u00f4le<\/h2>\n\n\n\n<p>Un r\u00f4le est un compte utilisateur qui peut se connecter \u00e0 un cluster de base de donn\u00e9es PostgreSQL. Pour cr\u00e9er un nouveau r\u00f4le, suivez les \u00e9tapes suivantes :<\/p>\n\n\n\n<p>Dans l&#8217;interface de ligne de commande de PostgreSQL, tapez la commande suivante pour cr\u00e9er un nouveau r\u00f4le :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CREATE ROLE newuser WITH LOGIN PASSWORD 'password';<\/code><\/pre>\n\n\n\n<p>Remplacez newuser par le nom du nouvel utilisateur que vous souhaitez cr\u00e9er et password par un mot de passe s\u00e9curis\u00e9 pour l&#8217;utilisateur.<\/p>\n\n\n\n<p>Pour accorder au nouveau r\u00f4le l&#8217;autorisation de cr\u00e9er des bases de donn\u00e9es, tapez la commande suivante :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">ALTER ROLE newuser CREATEDB;<\/code><\/pre>\n\n\n\n<p>Cela permettra au nouvel utilisateur de cr\u00e9er des bases de donn\u00e9es.<\/p>\n\n\n\n<p>Pour quitter l&#8217;interface de ligne de commande PostgreSQL, tapez \\q et appuyez sur Entr\u00e9e.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"%C3%A9tape-6---cr%C3%A9ation-dune-nouvelle-base-de-donn%C3%A9es\">\u00c9tape 6 &#8211; Cr\u00e9ation d&#8217;une nouvelle base de donn\u00e9es<\/h2>\n\n\n\n<p>Pour cr\u00e9er une nouvelle base de donn\u00e9es dans PostgreSQL, suivez les \u00e9tapes suivantes :<\/p>\n\n\n\n<p>Connectez-vous \u00e0 l&#8217;interface de ligne de commande de PostgreSQL en tant que superutilisateur (postgres) en ex\u00e9cutant la commande suivante :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">$ sudo -u postgres psql<\/code><\/pre>\n\n\n\n<p>Tapez la commande suivante pour cr\u00e9er une nouvelle base de donn\u00e9es :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CREATE DATABASE newdatabase;<\/code><\/pre>\n\n\n\n<p>Remplacez newdatabase par le nom de la nouvelle base de donn\u00e9es que vous souhaitez cr\u00e9er.<\/p>\n\n\n\n<p>Pour autoriser le nouvel utilisateur (newuser) \u00e0 acc\u00e9der \u00e0 la nouvelle base de donn\u00e9es (newdatabase), saisissez la commande suivante :<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">GRANTALL PRIVILEGES ON DATABASE newdatabase TO newuser;<\/code><\/pre>\n\n\n\n<p>Cela donnera au nouvel utilisateur un acc\u00e8s complet \u00e0 la nouvelle base de donn\u00e9es.<\/p>\n\n\n\n<p>Pour quitter l&#8217;interface de ligne de commande PostgreSQL, tapez \\q et appuyez sur Entr\u00e9e.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"conclusion\">Conclusion<\/h2>\n\n\n\n<p>F\u00e9licitations ! Vous avez install\u00e9 avec succ\u00e8s PostgreSQL sur Ubuntu, cr\u00e9\u00e9 un nouveau r\u00f4le et une nouvelle base de donn\u00e9es. Vous pouvez maintenant commencer \u00e0 utiliser PostgreSQL pour vos besoins de stockage et de r\u00e9cup\u00e9ration de donn\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL est un syst\u00e8me de gestion de bases de donn\u00e9es relationnelles puissant et open-source. Il est largement utilis\u00e9 pour le stockage et la r\u00e9cup\u00e9ration des donn\u00e9es dans les applications modernes. Dans ce guide, nous allons apprendre \u00e0 installer PostgreSQL sur Ubuntu, \u00e0 cr\u00e9er un nouveau r\u00f4le et une nouvelle base de donn\u00e9es. \u00c9tape 1 &#8211; ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[67,59],"tags":[],"yoast_head":"\n<title>Installation de PostgreSQL dans Ubuntu 18.04 \/ 20.04 \/ 22.04 - WebHi Tutorials &amp; Documentations<\/title>\n<meta name=\"description\" content=\"Apprenez comment installer PostgreSQL dans Ubuntu 18.04, 20.04 et 22.04 gr\u00e2ce \u00e0 ce guide \u00e9tape par \u00e9tape. Notre article fournit une vue d&#039;ensemble compl\u00e8te du processus d&#039;installation, y compris les commandes cl\u00e9s et des astuces de d\u00e9pannage.\" \/>\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.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installation de PostgreSQL dans Ubuntu 18.04 \/ 20.04 \/ 22.04 - WebHi Tutorials &amp; Documentations\" \/>\n<meta property=\"og:description\" content=\"Apprenez comment installer PostgreSQL dans Ubuntu 18.04, 20.04 et 22.04 gr\u00e2ce \u00e0 ce guide \u00e9tape par \u00e9tape. Notre article fournit une vue d&#039;ensemble compl\u00e8te du processus d&#039;installation, y compris les commandes cl\u00e9s et des astuces de d\u00e9pannage.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHi Tutorials &amp; Documentations\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webhi.technology\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-27T22:58:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-27T22:58:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/04\/postgresql_ubuntu_fr.jpg\" \/>\n<meta name=\"author\" content=\"webhi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@WebHiTechnology\" \/>\n<meta name=\"twitter:site\" content=\"@WebHiTechnology\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webhi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/\"},\"author\":{\"name\":\"webhi\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54\"},\"headline\":\"Installation de PostgreSQL dans Ubuntu 18.04 \/ 20.04 \/ 22.04\",\"datePublished\":\"2023-04-27T22:58:29+00:00\",\"dateModified\":\"2023-04-27T22:58:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/\"},\"wordCount\":569,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\"},\"articleSection\":[\"Administration syst\u00e8me Linux\",\"Bases de donn\u00e9es\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/\",\"name\":\"Installation de PostgreSQL dans Ubuntu 18.04 \/ 20.04 \/ 22.04 - WebHi Tutorials &amp; Documentations\",\"isPartOf\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#website\"},\"datePublished\":\"2023-04-27T22:58:29+00:00\",\"dateModified\":\"2023-04-27T22:58:32+00:00\",\"description\":\"Apprenez comment installer PostgreSQL dans Ubuntu 18.04, 20.04 et 22.04 gr\u00e2ce \u00e0 ce guide \u00e9tape par \u00e9tape. Notre article fournit une vue d'ensemble compl\u00e8te du processus d'installation, y compris les commandes cl\u00e9s et des astuces de d\u00e9pannage.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.webhi.com\/how-to\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Installation de PostgreSQL dans Ubuntu 18.04 \/ 20.04 \/ 22.04\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#website\",\"url\":\"https:\/\/www.webhi.com\/how-to\/\",\"name\":\"WebHi Tutorials &amp; Documentations\",\"description\":\"System administration and knowledge base\",\"publisher\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.webhi.com\/how-to\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#organization\",\"name\":\"WebHi Technology\",\"url\":\"https:\/\/www.webhi.com\/how-to\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png\",\"contentUrl\":\"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png\",\"width\":288,\"height\":95,\"caption\":\"WebHi Technology\"},\"image\":{\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webhi.technology\",\"https:\/\/twitter.com\/WebHiTechnology\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54\",\"name\":\"webhi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1784239260\",\"contentUrl\":\"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1784239260\",\"caption\":\"webhi\"},\"sameAs\":[\"https:\/\/www.webhi.com\/how-to\"],\"url\":\"https:\/\/www.webhi.com\/how-to\/author\/webhi\/\"}]}<\/script>\n","yoast_head_json":{"title":"Installation de PostgreSQL dans Ubuntu 18.04 \/ 20.04 \/ 22.04 - WebHi Tutorials &amp; Documentations","description":"Apprenez comment installer PostgreSQL dans Ubuntu 18.04, 20.04 et 22.04 gr\u00e2ce \u00e0 ce guide \u00e9tape par \u00e9tape. Notre article fournit une vue d'ensemble compl\u00e8te du processus d'installation, y compris les commandes cl\u00e9s et des astuces de d\u00e9pannage.","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.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/","og_locale":"en_US","og_type":"article","og_title":"Installation de PostgreSQL dans Ubuntu 18.04 \/ 20.04 \/ 22.04 - WebHi Tutorials &amp; Documentations","og_description":"Apprenez comment installer PostgreSQL dans Ubuntu 18.04, 20.04 et 22.04 gr\u00e2ce \u00e0 ce guide \u00e9tape par \u00e9tape. Notre article fournit une vue d'ensemble compl\u00e8te du processus d'installation, y compris les commandes cl\u00e9s et des astuces de d\u00e9pannage.","og_url":"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/","og_site_name":"WebHi Tutorials &amp; Documentations","article_publisher":"https:\/\/www.facebook.com\/webhi.technology","article_published_time":"2023-04-27T22:58:29+00:00","article_modified_time":"2023-04-27T22:58:32+00:00","og_image":[{"url":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2023\/04\/postgresql_ubuntu_fr.jpg"}],"author":"webhi","twitter_card":"summary_large_image","twitter_creator":"@WebHiTechnology","twitter_site":"@WebHiTechnology","twitter_misc":{"Written by":"webhi","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/#article","isPartOf":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/"},"author":{"name":"webhi","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54"},"headline":"Installation de PostgreSQL dans Ubuntu 18.04 \/ 20.04 \/ 22.04","datePublished":"2023-04-27T22:58:29+00:00","dateModified":"2023-04-27T22:58:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/"},"wordCount":569,"commentCount":0,"publisher":{"@id":"https:\/\/www.webhi.com\/how-to\/#organization"},"articleSection":["Administration syst\u00e8me Linux","Bases de donn\u00e9es"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/","url":"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/","name":"Installation de PostgreSQL dans Ubuntu 18.04 \/ 20.04 \/ 22.04 - WebHi Tutorials &amp; Documentations","isPartOf":{"@id":"https:\/\/www.webhi.com\/how-to\/#website"},"datePublished":"2023-04-27T22:58:29+00:00","dateModified":"2023-04-27T22:58:32+00:00","description":"Apprenez comment installer PostgreSQL dans Ubuntu 18.04, 20.04 et 22.04 gr\u00e2ce \u00e0 ce guide \u00e9tape par \u00e9tape. Notre article fournit une vue d'ensemble compl\u00e8te du processus d'installation, y compris les commandes cl\u00e9s et des astuces de d\u00e9pannage.","breadcrumb":{"@id":"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhi.com\/how-to\/fr\/installation-de-postgresql-dans-ubuntu-18-04-20-04-22-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhi.com\/how-to\/"},{"@type":"ListItem","position":2,"name":"Installation de PostgreSQL dans Ubuntu 18.04 \/ 20.04 \/ 22.04"}]},{"@type":"WebSite","@id":"https:\/\/www.webhi.com\/how-to\/#website","url":"https:\/\/www.webhi.com\/how-to\/","name":"WebHi Tutorials &amp; Documentations","description":"System administration and knowledge base","publisher":{"@id":"https:\/\/www.webhi.com\/how-to\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhi.com\/how-to\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webhi.com\/how-to\/#organization","name":"WebHi Technology","url":"https:\/\/www.webhi.com\/how-to\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/","url":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png","contentUrl":"https:\/\/www.webhi.com\/how-to\/gilrogre\/2022\/07\/logo.png","width":288,"height":95,"caption":"WebHi Technology"},"image":{"@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webhi.technology","https:\/\/twitter.com\/WebHiTechnology"]},{"@type":"Person","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/b31e76e2311cdc0bb90f5e2733059a54","name":"webhi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhi.com\/how-to\/#\/schema\/person\/image\/","url":"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1784239260","contentUrl":"https:\/\/www.webhi.com\/how-to\/ahuphiph\/litespeed\/avatar\/e20da107d0f4c765ead2eef88ad019d8.jpg?ver=1784239260","caption":"webhi"},"sameAs":["https:\/\/www.webhi.com\/how-to"],"url":"https:\/\/www.webhi.com\/how-to\/author\/webhi\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/4816"}],"collection":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/comments?post=4816"}],"version-history":[{"count":9,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/4816\/revisions"}],"predecessor-version":[{"id":4856,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/posts\/4816\/revisions\/4856"}],"wp:attachment":[{"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/media?parent=4816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/categories?post=4816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhi.com\/how-to\/wp-json\/wp\/v2\/tags?post=4816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}