{"id":46859,"date":"2026-03-10T17:56:13","date_gmt":"2026-03-10T17:56:13","guid":{"rendered":"\/fr\/tutoriels\/?p=46859"},"modified":"2026-03-10T18:11:18","modified_gmt":"2026-03-10T18:11:18","slug":"installer-postgresql-ubuntu","status":"publish","type":"post","link":"\/fr\/tutoriels\/installer-postgresql-ubuntu\/","title":{"rendered":"Comment installer PostgreSQL sur Ubuntu et g\u00e9rer efficacement vos bases de donn\u00e9es"},"content":{"rendered":"<p class=\"wp-block-paragraph\">PostgreSQL est un syst&egrave;me de gestion de base de donn&eacute;es relationnelle (SGBDR) open source tr&egrave;s populaire, connu pour son &eacute;volutivit&eacute; et son efficacit&eacute; dans le traitement de grandes quantit&eacute;s de donn&eacute;es.<\/p><p class=\"wp-block-paragraph\">Gr&acirc;ce &agrave; ses performances &eacute;lev&eacute;es, PostgreSQL est id&eacute;al pour les sites web ou les applications des grandes entreprises. Il prend &eacute;galement en charge divers types de donn&eacute;es et langages de programmation, notamment PHP et Python.<\/p><p class=\"wp-block-paragraph\">Dans ce tutoriel, nous vous expliquerons comment installer PostgreSQL sur <strong>Ubuntu 22.04 <\/strong>et versions ult&eacute;rieures. Nous aborderons &eacute;galement le processus d&rsquo;installation de pgAdmin et les solutions aux probl&egrave;mes courants li&eacute;s &agrave; PostgreSQL.<\/p><p>\n\n\n\n\n\n<div class=\"protip\"><div class=\"protip__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path d=\"M1.49234 23.5024C1.23229 23.5024 0.972242 23.4024 0.782206 23.2123C0.562165 22.9923 0.452144 22.6822 0.502153 22.3722C0.562165 21.9221 1.14227 17.9113 3.00262 16.351C3.63274 15.8209 4.43289 15.5509 5.26305 15.5609C6.09321 15.5909 6.87335 15.9109 7.47347 16.4911C8.6937 17.6913 8.76371 19.6717 7.6435 20.9919C6.0832 22.8523 2.08245 23.4324 1.63237 23.4924C1.59236 23.4924 1.54235 23.4924 1.50234 23.4924L1.49234 23.5024ZM5.16303 17.5613C4.84297 17.5613 4.53291 17.6713 4.29287 17.8813C3.60274 18.4614 3.07264 19.9317 2.75258 21.242C4.06282 20.9219 5.5331 20.3918 6.11321 19.7017C6.55329 19.1716 6.54329 18.3814 6.0832 17.9213C5.85316 17.7013 5.5431 17.5713 5.20304 17.5613C5.19304 17.5613 5.17303 17.5613 5.16303 17.5613ZM11.7243 21.8821C11.4942 21.8821 11.2642 21.8021 11.0841 21.652C10.8541 21.462 10.7241 21.1819 10.7241 20.8819V15.9109L8.08358 13.2705H3.11264C2.81259 13.2705 2.53254 13.1404 2.3425 12.9104C2.15246 12.6803 2.07245 12.3803 2.12246 12.0902C2.19247 11.7102 2.84259 8.36953 4.70294 7.12929C6.33325 6.04909 8.96375 6.49918 10.244 6.80923C11.5442 4.96889 13.2546 3.4286 15.2349 2.33839C17.4553 1.11816 19.9858 0.518051 22.4963 0.498047C23.0464 0.498047 23.4865 0.948132 23.4865 1.49824C23.4865 5.0389 22.3763 9.97983 17.1753 13.7605C17.4853 15.0408 17.9354 17.6613 16.8552 19.2816C15.615 21.1419 12.2744 21.7921 11.8943 21.8621C11.8343 21.8721 11.7743 21.8821 11.7143 21.8821H11.7243ZM12.7245 16.181V19.6016C13.7146 19.2916 14.7948 18.7915 15.2049 18.1814C15.675 17.4812 15.605 16.091 15.385 14.9008C14.5248 15.3808 13.6346 15.8109 12.7245 16.181ZM9.66388 12.0302L11.9643 14.3307C13.1845 13.8306 14.3648 13.2204 15.485 12.5103C19.9358 9.51974 21.2361 5.60901 21.4561 2.53843C19.6157 2.67846 17.8254 3.20856 16.2051 4.09872C14.2847 5.14892 12.6544 6.68921 11.4942 8.54956C10.7841 9.65977 10.174 10.82 9.66388 12.0302ZM4.39289 11.2701H7.81353C8.1936 10.3599 8.63368 9.46974 9.11377 8.60957C7.92355 8.38953 6.51329 8.31952 5.81315 8.78961C5.19304 9.19968 4.70294 10.3099 4.39289 11.2701Z\" fill=\"#673DE6\"\/>\n                <\/svg>\n                <p class=\"protip__title\">\n                   Qu'est-ce que PostgreSQL ?\n                <\/p>\n            <\/div>\n            <p class=\"protip__content\">PostgreSQL est un syst&egrave;me de gestion de base de donn&eacute;es relationnelle (SGBDR) appr&eacute;ci&eacute; pour ses performances. Contrairement &agrave; un SGBD standard, il organise les donn&eacute;es dans une structure logique pour un acc&egrave;s plus efficace.<br>\nTr&egrave;s efficace et capable de traiter de nombreuses requ&ecirc;tes, cette solution de base de donn&eacute;es est excellente pour les grandes entreprises. De plus, elle est gratuite, open source et compatible avec divers types de donn&eacute;es.<\/p><\/div>\n\n\n\n<\/p><h2 class=\"wp-block-heading\" id=\"h-comment-installer-postgresql-sur-ubuntu\"><strong>Comment installer PostgreSQL sur Ubuntu<\/strong><\/h2><p class=\"wp-block-paragraph\">Avant de continuer, assurez-vous que votre serveur priv&eacute; virtuel <a href=\"https:\/\/www.hostinger.com\/fr\/vps\/hebergement-ubuntu\" data-type=\"link\" data-id=\"https:\/\/www.hostinger.com\/fr\/vps\/hebergement-ubuntu\">(VPS) fonctionne sous <strong>Ubuntu 22.04<\/strong><\/a> ou une version ult&eacute;rieure. Sinon, suivez notre guide pour <a href=\"https:\/\/www.hostinger.com\/fr\/support\/4965922-comment-changer-le-systeme-d-exploitation-de-votre-vps-chez-hostinger\/\" data-type=\"link\" data-id=\"https:\/\/www.hostinger.com\/fr\/support\/4965922-comment-changer-le-systeme-d-exploitation-de-votre-vps-chez-hostinger\/\">changer le syst&egrave;me d&rsquo;exploitation dans le VPS de Hostinger<\/a>.<\/p><h3 class=\"wp-block-heading\"><strong>1. Installer PostgreSQL<\/strong><\/h3><p class=\"wp-block-paragraph\">L&rsquo;installation de PostgreSQL implique l&rsquo;ex&eacute;cution de <a href=\"https:\/\/www.hostinger.com\/fr\/tutoriels\/commandes-linux\/\" data-type=\"link\" data-id=\"https:\/\/www.hostinger.com\/fr\/tutoriels\/commandes-linux\">commandes Linux<\/a> sur votre machine. Pour un syst&egrave;me local, ex&eacute;cutez-les directement via Terminal, l&rsquo;invite de commande Linux.<\/p><p class=\"wp-block-paragraph\">Pour une machine distante comme un VPS, connectez-vous <a href=\"https:\/\/www.hostinger.com\/fr\/tutoriels\/connexion-ssh-windows-putty\/\" data-type=\"link\" data-id=\"https:\/\/www.hostinger.com\/fr\/tutoriels\/connexion-ssh-windows-putty\">&agrave; l&rsquo;aide d&rsquo;une application SSH<\/a> ou du Terminal. Les utilisateurs Hostinger peuvent trouver leurs identifiants de connexion &agrave; la machine distante en acc&eacute;dant au menu <strong>Aper&ccedil;u VPS <\/strong>dans hPanel.<\/p><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a6ce58f48619\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a6ce58f48619\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"635\" height=\"402\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/Apercu-general-Hostinger-03-10-2026_05_53_PM.png\/public\" alt=\"Les identifiants d'acc&egrave;s SSH dans le menu g&eacute;n&eacute;ral du VPS\" class=\"wp-image-46889\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/Apercu-general-Hostinger-03-10-2026_05_53_PM.png\/w=635,fit=scale-down 635w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/Apercu-general-Hostinger-03-10-2026_05_53_PM.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/Apercu-general-Hostinger-03-10-2026_05_53_PM.png\/w=150,fit=scale-down 150w\" sizes=\"(max-width: 635px) 100vw, 635px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><p class=\"wp-block-paragraph\">Vous pouvez installer les paquets Ubuntu PostgreSQL &agrave; partir du r&eacute;f&eacute;rentiel local ou &agrave; l&rsquo;aide du gestionnaire de paquets APT. Nous vous recommandons cette derni&egrave;re option pour vous assurer d&rsquo;obtenir la derni&egrave;re version.<\/p><p class=\"wp-block-paragraph\">Notre VPS prend &eacute;galement en charge d&rsquo;autres bases de donn&eacute;es. Par exemple, vous pouvez installer MongoDB si vous pr&eacute;f&eacute;rez un SGBD NoSQL.<\/p><figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.hostinger.com\/fr\/vps\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" width=\"1024\" height=\"300\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2022\/12\/FR-VPS-hosting_in-text-banner-1024x300-1.png\/public\" alt=\"\" class=\"wp-image-41471\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2022\/12\/FR-VPS-hosting_in-text-banner-1024x300-1.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2022\/12\/FR-VPS-hosting_in-text-banner-1024x300-1.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2022\/12\/FR-VPS-hosting_in-text-banner-1024x300-1.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2022\/12\/FR-VPS-hosting_in-text-banner-1024x300-1.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><p class=\"wp-block-paragraph\"><strong>Option 1 &ndash; Installation &agrave; partir du r&eacute;f&eacute;rentiel APT<\/strong><\/p><p class=\"wp-block-paragraph\">La m&eacute;thode la plus courante pour installer PostgreSQL sur Ubuntu consiste &agrave; utiliser le r&eacute;f&eacute;rentiel officiel via le <strong>gestionnaire de paquets APT<\/strong>. Voici les &eacute;tapes &agrave; suivre :<\/p><ol start=\"1\" class=\"wp-block-list\">\n<li>Ex&eacute;cutez ces commandes pour importer la cl&eacute; du r&eacute;f&eacute;rentiel officiel de PostgreSQL vers le gestionnaire de paquets APT :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo sh -c 'echo \"deb http:\/\/apt.postgresql.org\/pub\/repos\/apt $(lsb_release -cs)-pgdg main\" &gt; \/etc\/apt\/sources.list.d\/pgdg.list'<br><br>wget --quiet -O - https:\/\/www.postgresql.org\/media\/keys\/ACCC4CF8.asc | sudo gpg -<\/pre><ol start=\"2\" class=\"wp-block-list\">\n<li>Actualisez APT pour synchroniser tous les r&eacute;f&eacute;rentiels &agrave; l&rsquo;aide de cette commande :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo apt update<\/pre><ol start=\"3\" class=\"wp-block-list\">\n<li>Installez la derni&egrave;re version de PostgreSQL avec APT et les privil&egrave;ges sudo :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo apt-get -y install postgresql<\/pre><ol start=\"4\" class=\"wp-block-list\">\n<li>Pour confirmer l&rsquo;installation, ex&eacute;cutez cette commande :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo -u postgres psql<\/pre><ol start=\"5\" class=\"wp-block-list\">\n<li>Entrez l&rsquo;instruction de requ&ecirc;te de version PostgreSQL :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">SELECT version();<\/pre><p>\n\n\n        <div class=\"protip\">\n            <div class=\"protip__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path d=\"M1.49234 23.5024C1.23229 23.5024 0.972242 23.4024 0.782206 23.2123C0.562165 22.9923 0.452144 22.6822 0.502153 22.3722C0.562165 21.9221 1.14227 17.9113 3.00262 16.351C3.63274 15.8209 4.43289 15.5509 5.26305 15.5609C6.09321 15.5909 6.87335 15.9109 7.47347 16.4911C8.6937 17.6913 8.76371 19.6717 7.6435 20.9919C6.0832 22.8523 2.08245 23.4324 1.63237 23.4924C1.59236 23.4924 1.54235 23.4924 1.50234 23.4924L1.49234 23.5024ZM5.16303 17.5613C4.84297 17.5613 4.53291 17.6713 4.29287 17.8813C3.60274 18.4614 3.07264 19.9317 2.75258 21.242C4.06282 20.9219 5.5331 20.3918 6.11321 19.7017C6.55329 19.1716 6.54329 18.3814 6.0832 17.9213C5.85316 17.7013 5.5431 17.5713 5.20304 17.5613C5.19304 17.5613 5.17303 17.5613 5.16303 17.5613ZM11.7243 21.8821C11.4942 21.8821 11.2642 21.8021 11.0841 21.652C10.8541 21.462 10.7241 21.1819 10.7241 20.8819V15.9109L8.08358 13.2705H3.11264C2.81259 13.2705 2.53254 13.1404 2.3425 12.9104C2.15246 12.6803 2.07245 12.3803 2.12246 12.0902C2.19247 11.7102 2.84259 8.36953 4.70294 7.12929C6.33325 6.04909 8.96375 6.49918 10.244 6.80923C11.5442 4.96889 13.2546 3.4286 15.2349 2.33839C17.4553 1.11816 19.9858 0.518051 22.4963 0.498047C23.0464 0.498047 23.4865 0.948132 23.4865 1.49824C23.4865 5.0389 22.3763 9.97983 17.1753 13.7605C17.4853 15.0408 17.9354 17.6613 16.8552 19.2816C15.615 21.1419 12.2744 21.7921 11.8943 21.8621C11.8343 21.8721 11.7743 21.8821 11.7143 21.8821H11.7243ZM12.7245 16.181V19.6016C13.7146 19.2916 14.7948 18.7915 15.2049 18.1814C15.675 17.4812 15.605 16.091 15.385 14.9008C14.5248 15.3808 13.6346 15.8109 12.7245 16.181ZM9.66388 12.0302L11.9643 14.3307C13.1845 13.8306 14.3648 13.2204 15.485 12.5103C19.9358 9.51974 21.2361 5.60901 21.4561 2.53843C19.6157 2.67846 17.8254 3.20856 16.2051 4.09872C14.2847 5.14892 12.6544 6.68921 11.4942 8.54956C10.7841 9.65977 10.174 10.82 9.66388 12.0302ZM4.39289 11.2701H7.81353C8.1936 10.3599 8.63368 9.46974 9.11377 8.60957C7.92355 8.38953 6.51329 8.31952 5.81315 8.78961C5.19304 9.19968 4.70294 10.3099 4.39289 11.2701Z\" fill=\"#673DE6\"\/>\n                <\/svg>\n                <p class=\"protip__title\">\n                     Conseil de pro                 <\/p>\n            <\/div>\n            <p class=\"protip__content\"> Pour installer une version sp&eacute;cifique, ajoutez le num&eacute;ro dans votre commande, par exemple <strong>sudo apt-get -y install postgresql-12<\/strong>. Dans cet exemple, la commande installera la version 12 de PostgreSQL. <\/p>\n                    <\/div>\n        \n\n\n\n<\/p><p class=\"wp-block-paragraph\"><strong>Option 2 &ndash; Installation &agrave; l&rsquo;aide du r&eacute;f&eacute;rentiel Ubuntu local<\/strong><\/p><p class=\"wp-block-paragraph\">La m&eacute;thode alternative d&rsquo;installation de PostgreSQL utilise le r&eacute;f&eacute;rentiel <a href=\"https:\/\/www.hostinger.com\/fr\/tutoriels\/ubuntu-cest-quoi\/\" data-type=\"link\" data-id=\"https:\/\/www.hostinger.com\/fr\/tutoriels\/ubuntu-cest-quoi\">Ubuntu<\/a> local. Voici les &eacute;tapes &agrave; suivre :<\/p><ol class=\"wp-block-list\">\n<li>Ex&eacute;cutez cette commande pour actualiser le r&eacute;f&eacute;rentiel Ubuntu :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo apt-get update<\/pre><ol start=\"2\" class=\"wp-block-list\">\n<li>V&eacute;rifiez le <strong>r&eacute;f&eacute;rentiel apt PostgreSQL<\/strong> disponible &agrave; l&rsquo;aide de cette commande :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo apt show postgresql<\/pre><ol start=\"3\" class=\"wp-block-list\">\n<li>Ex&eacute;cutez cette commande pour installer la derni&egrave;re version disponible.<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo apt install postgresql postgresql-contrib<\/pre><ol start=\"4\" class=\"wp-block-list\">\n<li>Pour v&eacute;rifier si l&rsquo;installation de PostgreSQL a r&eacute;ussi, ex&eacute;cutez la commande suivante :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo -u postgres psql<\/pre><ol start=\"5\" class=\"wp-block-list\">\n<li>Ensuite, ex&eacute;cutez cette commande pour v&eacute;rifier la version actuelle de PostgreSQL :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">SELECT version();<\/pre><p class=\"wp-block-paragraph\">La ligne de commande devrait indiquer que la <strong>version<\/strong> 14.11 <strong>du serveur PostgreSQL <\/strong>est correctement install&eacute;e, comme ceci :<\/p><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a6ce58f50173\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a6ce58f50173\" class=\"aligncenter size-large wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"127\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-44.png\/w=1024,h=1024,fit=scale-down\" alt=\"PostgreSQL version 14.11 dans le code\" class=\"wp-image-46861\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-44.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-44.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-44.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-44.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><h3 class=\"wp-block-heading\"><strong>2. V&eacute;rifier l&rsquo;&eacute;tat de PostgreSQL<\/strong><\/h3><p class=\"wp-block-paragraph\">Apr&egrave;s avoir install&eacute; PostgreSQL, v&eacute;rifiez qu&rsquo;il est bien activ&eacute; et op&eacute;rationnel. Utilisez l&rsquo;utilitaire de commande <strong>systemctl <\/strong>ou <strong>service <\/strong>pour v&eacute;rifier l&rsquo;&eacute;tat du service :<\/p><pre class=\"wp-block-preformatted\">sudo service postgresql status<br><br>sudo systemctl status postgresql<\/pre><p class=\"wp-block-paragraph\">Si PostgreSQL est activ&eacute;, votre ligne de commande affichera &laquo; <strong>active &raquo; <\/strong>et &laquo; <strong>loaded <\/strong>&raquo;.<\/p><p class=\"wp-block-paragraph\">Pour les utilisateurs d&rsquo;Hostinger, vous pouvez &eacute;galement v&eacute;rifier si PostgreSQL fonctionne en demandant &agrave; l&rsquo;assistant IA Kodee. Il suffit de saisir &laquo; V&eacute;rifiez l&rsquo;&eacute;tat du service postgresql dans mon VPS &raquo; et Kodee affichera l&rsquo;&eacute;tat du service.<\/p><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a6ce58f53197\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a6ce58f53197\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"431\" height=\"442\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/Apercu-general-Hostinger-03-10-2026_05_55_PM.png\/public\" alt=\"Kodee affiche l'&eacute;tat du service postgresql\" class=\"wp-image-46890\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/Apercu-general-Hostinger-03-10-2026_05_55_PM.png\/w=431,fit=scale-down 431w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/Apercu-general-Hostinger-03-10-2026_05_55_PM.png\/w=293,fit=scale-down 293w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/Apercu-general-Hostinger-03-10-2026_05_55_PM.png\/w=146,fit=scale-down 146w\" sizes=\"(max-width: 431px) 100vw, 431px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><p>\n\n        <div class=\"protip\">\n            <div class=\"protip__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path d=\"M1.49234 23.5024C1.23229 23.5024 0.972242 23.4024 0.782206 23.2123C0.562165 22.9923 0.452144 22.6822 0.502153 22.3722C0.562165 21.9221 1.14227 17.9113 3.00262 16.351C3.63274 15.8209 4.43289 15.5509 5.26305 15.5609C6.09321 15.5909 6.87335 15.9109 7.47347 16.4911C8.6937 17.6913 8.76371 19.6717 7.6435 20.9919C6.0832 22.8523 2.08245 23.4324 1.63237 23.4924C1.59236 23.4924 1.54235 23.4924 1.50234 23.4924L1.49234 23.5024ZM5.16303 17.5613C4.84297 17.5613 4.53291 17.6713 4.29287 17.8813C3.60274 18.4614 3.07264 19.9317 2.75258 21.242C4.06282 20.9219 5.5331 20.3918 6.11321 19.7017C6.55329 19.1716 6.54329 18.3814 6.0832 17.9213C5.85316 17.7013 5.5431 17.5713 5.20304 17.5613C5.19304 17.5613 5.17303 17.5613 5.16303 17.5613ZM11.7243 21.8821C11.4942 21.8821 11.2642 21.8021 11.0841 21.652C10.8541 21.462 10.7241 21.1819 10.7241 20.8819V15.9109L8.08358 13.2705H3.11264C2.81259 13.2705 2.53254 13.1404 2.3425 12.9104C2.15246 12.6803 2.07245 12.3803 2.12246 12.0902C2.19247 11.7102 2.84259 8.36953 4.70294 7.12929C6.33325 6.04909 8.96375 6.49918 10.244 6.80923C11.5442 4.96889 13.2546 3.4286 15.2349 2.33839C17.4553 1.11816 19.9858 0.518051 22.4963 0.498047C23.0464 0.498047 23.4865 0.948132 23.4865 1.49824C23.4865 5.0389 22.3763 9.97983 17.1753 13.7605C17.4853 15.0408 17.9354 17.6613 16.8552 19.2816C15.615 21.1419 12.2744 21.7921 11.8943 21.8621C11.8343 21.8721 11.7743 21.8821 11.7143 21.8821H11.7243ZM12.7245 16.181V19.6016C13.7146 19.2916 14.7948 18.7915 15.2049 18.1814C15.675 17.4812 15.605 16.091 15.385 14.9008C14.5248 15.3808 13.6346 15.8109 12.7245 16.181ZM9.66388 12.0302L11.9643 14.3307C13.1845 13.8306 14.3648 13.2204 15.485 12.5103C19.9358 9.51974 21.2361 5.60901 21.4561 2.53843C19.6157 2.67846 17.8254 3.20856 16.2051 4.09872C14.2847 5.14892 12.6544 6.68921 11.4942 8.54956C10.7841 9.65977 10.174 10.82 9.66388 12.0302ZM4.39289 11.2701H7.81353C8.1936 10.3599 8.63368 9.46974 9.11377 8.60957C7.92355 8.38953 6.51329 8.31952 5.81315 8.78961C5.19304 9.19968 4.70294 10.3099 4.39289 11.2701Z\" fill=\"#673DE6\"\/>\n                <\/svg>\n                <p class=\"protip__title\">\n                     Demandez &agrave; Kodee de g&eacute;rer les services                 <\/p>\n            <\/div>\n            <p class=\"protip__content\"> Outre la v&eacute;rification de l'&eacute;tat des services sur votre VPS, vous pouvez demander &agrave; <strong>Kodee<\/strong> de r&eacute;initialiser les services &agrave; leurs param&egrave;tres et &eacute;tats par d&eacute;faut. <\/p>\n                    <\/div>\n        \n\n\n\n<\/p><p class=\"wp-block-paragraph\">En plus de l&rsquo;&eacute;tat du service, v&eacute;rifiez si PostgreSQL est pr&ecirc;t &agrave; accepter une connexion &agrave; l&rsquo;aide de cette commande :<\/p><pre class=\"wp-block-preformatted\">sudo pg_isready<\/pre><h3 class=\"wp-block-heading\"><strong>3. Se connecter &agrave; PostgreSQL<\/strong><\/h3><p class=\"wp-block-paragraph\">Lors de l&rsquo;installation, PostgreSQL cr&eacute;e automatiquement le r&ocirc;le<strong> postgres<\/strong> par d&eacute;faut pour se connecter &agrave; la base de donn&eacute;es. Pour passer &agrave; cet utilisateur, ex&eacute;cutez la commande suivante :<\/p><pre class=\"wp-block-preformatted\">sudo su - postgres<\/pre><p class=\"wp-block-paragraph\">Votre ligne de commande devrait maintenant commencer par <strong>postgres<\/strong>. Pour vous connecter &agrave; la base de donn&eacute;es PostgreSQL, utilisez le shell PostgreSQL &agrave; l&rsquo;aide de la commande suivante :<\/p><pre class=\"wp-block-preformatted\">sudo psql<\/pre><p class=\"wp-block-paragraph\">La commande <strong>psql <\/strong>cr&eacute;era une session dans la base de donn&eacute;es par d&eacute;faut. Si la commande est introuvable, installez manuellement le client PostgreSQL &agrave; l&rsquo;aide de cette commande :<\/p><pre class=\"wp-block-preformatted\">sudo apt-get install postgresql-client<\/pre><p class=\"wp-block-paragraph\">Pour v&eacute;rifier l&rsquo;&eacute;tat de la connexion, ex&eacute;cutez cette commande &agrave; l&rsquo;aide de l&rsquo;invite PostgreSQL :<\/p><pre class=\"wp-block-preformatted\">\\conninfo<\/pre><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a6ce58f55e70\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a6ce58f55e70\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"958\" height=\"72\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-42.png\/public\" alt=\"La commande conninfo affiche un message de confirmation sur le terminal.\" class=\"wp-image-46863\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-42.png\/w=958,fit=scale-down 958w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-42.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-42.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-42.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 958px) 100vw, 958px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><p class=\"wp-block-paragraph\">Pour quitter l&rsquo;invite PostgreSQL et revenir &agrave; l&rsquo;utilisateur syst&egrave;me normal, utilisez la commande<strong> exit<\/strong>. Utilisez quant &agrave; vous <strong>\\q <\/strong>pour vous d&eacute;connecter de la session interactive de la base de donn&eacute;es.<\/p><h3 class=\"wp-block-heading\"><strong>4. Modifier le mot de passe utilisateur<\/strong><\/h3><p class=\"wp-block-paragraph\">Il est essentiel de modifier le mot de passe par d&eacute;faut du r&ocirc;le <strong>postgres <\/strong>pour am&eacute;liorer la s&eacute;curit&eacute; de la base de donn&eacute;es. Voici comment proc&eacute;der :<\/p><ol class=\"wp-block-list\">\n<li>Activez l&rsquo;invite PostgreSQL &agrave; l&rsquo;aide de cette commande :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo -u postgres psql<\/pre><ol start=\"2\" class=\"wp-block-list\">\n<li>Ex&eacute;cutez cette instruction pour modifier le mot de passe du compte <strong>postgres<\/strong>. N&rsquo;oubliez pas de remplacer <strong>NewPassword <\/strong>par votre mot de passe r&eacute;el :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">ALTER USER postgres PASSWORD 'NewPassword';<\/pre><ol start=\"3\" class=\"wp-block-list\">\n<li>V&eacute;rifiez si la modification a &eacute;t&eacute; appliqu&eacute;e avec succ&egrave;s &agrave; l&rsquo;aide de la commande suivante :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">\\p<\/pre><ol start=\"4\" class=\"wp-block-list\">\n<li>Red&eacute;marrez le service PostgreSQL &agrave; l&rsquo;aide de cette commande :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo service postgresql restart<\/pre><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a6ce58f594ff\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a6ce58f594ff\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"155\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/www.hostinger.com\/fr\/tutoriels\/wp-content\/uploads\/sites\/46\/2026\/03\/w1024fitscale-down-18.avif\" alt=\"Postgres renvoie une confirmation concernant la modification du mot de passe du compte.\" class=\"wp-image-46888\"><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><h3 class=\"wp-block-heading\"><strong>5. Cr&eacute;er un utilisateur sur PostgreSQL<\/strong><\/h3><p class=\"wp-block-paragraph\">Pour g&eacute;rer l&rsquo;acc&egrave;s &agrave; la base de donn&eacute;es et garantir une organisation correcte des donn&eacute;es, vous aurez besoin de plusieurs utilisateurs PostgreSQL. Le moyen le plus simple d&rsquo;en cr&eacute;er un est d&rsquo;utiliser le <strong>mode interactif<\/strong>. Voici les &eacute;tapes &agrave; suivre :<\/p><ol class=\"wp-block-list\">\n<li>Passez &agrave; l&rsquo;utilisateur <strong>postgres <\/strong>:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo su - postgres<\/pre><ol start=\"2\" class=\"wp-block-list\">\n<li>Ex&eacute;cutez cette commande pour cr&eacute;er un nouvel utilisateur :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">createuser --interactive<\/pre><ol start=\"3\" class=\"wp-block-list\">\n<li>Entrez le nom du nouveau compte PostgresQL. Pour ce tutoriel, il s&rsquo;agit de <strong>TheNewUser<\/strong>.<\/li>\n\n\n\n<li>Pour valider le nouveau r&ocirc;le, connectez-vous &agrave; PostgreSQL avec le compte <strong>postgres <\/strong>:<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo -u postgres psql<\/pre><ol start=\"5\" class=\"wp-block-list\">\n<li>V&eacute;rifiez tous les utilisateurs &agrave; l&rsquo;aide de la commande suivante :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">\\du<\/pre><p>\n\n\n<div class=\"announcement-block announcement-block--important\">\n            <span class=\"announcement-block__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path fill-rule=\"evenodd\" clip-rule=\"evenodd\"\n                          d=\"M12 22.5C17.799 22.5 22.5 17.799 22.5 12C22.5 6.20101 17.799 1.5 12 1.5C6.20101 1.5 1.5 6.20101 1.5 12C1.5 17.799 6.20101 22.5 12 22.5ZM13.637 7.65198C13.637 6.74791 12.9041 6.01501 12 6.01501C11.0959 6.01501 10.363 6.74791 10.363 7.65198C10.5335 9.53749 10.875 13.383 10.875 13.383C10.875 14.0043 11.3787 14.508 12 14.508C12.6213 14.508 13.125 14.0043 13.125 13.383V13.38L13.637 7.65198ZM11.9927 15.714C11.3714 15.714 10.8677 16.2177 10.8677 16.839C10.8677 17.4603 11.3714 17.964 11.9927 17.964H12.0073C12.6286 17.964 13.1323 17.4603 13.1323 16.839C13.1323 16.2177 12.6286 15.714 12.0073 15.714H11.9927Z\"\n                          fill=\"#FEA419\"\/>\n                <\/svg>\n                Important\n            <\/span>\n            <p class=\"announcement-block__content\">\n                <strong>Important !<\/strong> Dans le cadre des meilleures pratiques de s&eacute;curit&eacute; pour PostgreSQL, &eacute;vitez d&rsquo;accorder au nouveau r&ocirc;le un privil&egrave;ge de superutilisateur, sauf si cela est n&eacute;cessaire.\n            <\/p><\/div>\n\n\n\n<\/p><p class=\"wp-block-paragraph\">Comme indiqu&eacute; dans la sortie, la base de donn&eacute;es cr&eacute;e correctement <strong>TheNewUser<\/strong>.<\/p><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a6ce58f5c4f1\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a6ce58f5c4f1\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"189\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-49.png\/public\" alt=\"Le terminal affiche le nouvel utilisateur PostgreSQL.\" class=\"wp-image-46866\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-49.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-49.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-49.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-49.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><h3 class=\"wp-block-heading\"><strong>6. Cr&eacute;er une base de donn&eacute;es sur PostgreSQL<\/strong><\/h3><p class=\"wp-block-paragraph\">PostgreSQL suppose que le <a href=\"https:\/\/www.postgresql.org\/docs\/current\/user-manag.html\" target=\"_blank\" rel=\"noopener\">r&ocirc;le<\/a> et la base de donn&eacute;es auront le m&ecirc;me nom. Par cons&eacute;quent, si vous cr&eacute;ez un r&ocirc;le <strong>TheNewUser<\/strong>, PostgreSQL acc&eacute;dera &agrave; une base de donn&eacute;es portant le m&ecirc;me nom.<\/p><p>\n\n\n<div class=\"announcement-block announcement-block--important\">\n            <span class=\"announcement-block__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path fill-rule=\"evenodd\" clip-rule=\"evenodd\"\n                          d=\"M12 22.5C17.799 22.5 22.5 17.799 22.5 12C22.5 6.20101 17.799 1.5 12 1.5C6.20101 1.5 1.5 6.20101 1.5 12C1.5 17.799 6.20101 22.5 12 22.5ZM13.637 7.65198C13.637 6.74791 12.9041 6.01501 12 6.01501C11.0959 6.01501 10.363 6.74791 10.363 7.65198C10.5335 9.53749 10.875 13.383 10.875 13.383C10.875 14.0043 11.3787 14.508 12 14.508C12.6213 14.508 13.125 14.0043 13.125 13.383V13.38L13.637 7.65198ZM11.9927 15.714C11.3714 15.714 10.8677 16.2177 10.8677 16.839C10.8677 17.4603 11.3714 17.964 11.9927 17.964H12.0073C12.6286 17.964 13.1323 17.4603 13.1323 16.839C13.1323 16.2177 12.6286 15.714 12.0073 15.714H11.9927Z\"\n                          fill=\"#FEA419\"\/>\n                <\/svg>\n                Important\n            <\/span>\n            <p class=\"announcement-block__content\">\n                <strong>Important !<\/strong> PostgreSQL utilise les informations Linux pour l&rsquo;authentification. Dans l&rsquo;exemple pr&eacute;c&eacute;dent, vous avez besoin d&rsquo;un utilisateur appel&eacute; <strong>TheNewUser<\/strong>.\n            <\/p><\/div>\n\n\n\n<\/p><p class=\"wp-block-paragraph\">Voici les &eacute;tapes de configuration de la base de donn&eacute;es PostgreSQL :<\/p><ol class=\"wp-block-list\">\n<li>Ex&eacute;cutez la commande suivante pour passer &agrave; l&rsquo;utilisateur<strong> postgres <\/strong>et cr&eacute;er une nouvelle base de donn&eacute;es :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo -u postgres createdb TheNewUser<\/pre><ol start=\"2\" class=\"wp-block-list\">\n<li>Pour vous connecter &agrave; la nouvelle base de donn&eacute;es, cr&eacute;ez un compte utilisateur Linux portant le m&ecirc;me nom. Comme le nom d&rsquo;utilisateur contient des majuscules, ajoutez l&rsquo;option <strong>&ndash;force-badname<\/strong>.<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo adduser TheNewUser --force-badname<\/pre><ol start=\"3\" class=\"wp-block-list\">\n<li>Acc&eacute;dez &agrave; l&rsquo;invite interactive PostgreSQL &agrave; l&rsquo;aide du nouveau compte utilisateur :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo -u TheNewUser psql<\/pre><ol start=\"4\" class=\"wp-block-list\">\n<li>Confirmez la connexion &agrave; l&rsquo;aide de cette commande :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">\\conninfo<\/pre><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a6ce58f5f48a\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a6ce58f5f48a\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"102\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-45.png\/public\" alt=\"La sortie du terminal confirme que le nouvel utilisateur PostgreSQL est connect&eacute; &agrave; la nouvelle base de donn&eacute;es.\" class=\"wp-image-46862\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-45.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-45.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-45.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-45.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><p class=\"wp-block-paragraph\">L&rsquo;utilisateur devrait d&eacute;sormais &ecirc;tre connect&eacute; &agrave; la nouvelle base de donn&eacute;es et pouvoir cr&eacute;er une nouvelle table. Par exemple, entrez la commande suivante pour cr&eacute;er une table de donn&eacute;es acheteurs :<\/p><pre class=\"wp-block-preformatted\">CREATE TABLE buyers(usr_id INT PRIMARY KEY, usr_name VARCHAR(240) NOT NULL, usr_location VARCHAR(240) NOT NULL);<\/pre><p class=\"wp-block-paragraph\">Lors de la cr&eacute;ation d&rsquo;une table de base de donn&eacute;es, tenez compte des six contraintes PostgreSQL :<\/p><ul class=\"wp-block-list\">\n<li><strong>PRIMARY KEY <\/strong>&ndash; indique qu&rsquo;une colonne peut &ecirc;tre l&rsquo;identifiant unique d&rsquo;une ligne.<\/li>\n\n\n\n<li><strong>FOREIGN KEY <\/strong>&ndash; sp&eacute;cifie que les valeurs d&rsquo;une colonne doivent &ecirc;tre identiques &agrave; celles des lignes d&rsquo;une autre table.<\/li>\n\n\n\n<li><strong>NOT NULL <\/strong>&ndash; garantit que la valeur d&rsquo;une colonne n&rsquo;est pas vide.<\/li>\n\n\n\n<li><strong>CHECK <\/strong>&ndash; d&eacute;finit la valeur d&rsquo;une colonne de mani&egrave;re &agrave; ce qu&rsquo;elle satisfasse une expression bool&eacute;enne, qui est soit &laquo; vraie &raquo;, soit &laquo; fausse &raquo;.<\/li>\n\n\n\n<li><strong>UNIQUE <\/strong>&ndash; garantit que les valeurs d&rsquo;une colonne sont uniques parmi toutes les lignes.<\/li>\n\n\n\n<li><strong>EXCLUSION <\/strong>&ndash; emp&ecirc;che les valeurs de deux lignes de se chevaucher lorsqu&rsquo;elles sont compar&eacute;es.<\/li>\n<\/ul><p class=\"wp-block-paragraph\">Pour ajouter des valeurs &agrave; votre table, utilisez l&rsquo;instruction suivante. N&rsquo;oubliez pas de remplacer les espaces r&eacute;serv&eacute;s par la valeur appropri&eacute;e et d&rsquo;ajuster le nombre de lignes en cons&eacute;quence :<\/p><pre class=\"wp-block-preformatted\">INSERT INTO nomtableau (column1, column2, column3) VALUES (row1, row2, row3);<\/pre><p class=\"wp-block-paragraph\">Pour afficher le tableau, entrez l&rsquo;instruction suivante :<\/p><pre class=\"wp-block-preformatted\">SELECT * FROM nomtableau<\/pre><h3 class=\"wp-block-heading\"><strong>7. Configurer le serveur PostgreSQL<\/strong><\/h3><p class=\"wp-block-paragraph\">Configurez votre serveur PostgreSQL pour permettre &agrave; d&rsquo;autres syst&egrave;mes d&rsquo;acc&eacute;der &agrave; la base de donn&eacute;es &agrave; distance. Pour ce faire, configurez le serveur pour qu&rsquo;il &eacute;coute toutes les adresses IP en modifiant le fichier de configuration.<\/p><p class=\"wp-block-paragraph\">Avant de continuer, utilisez la commande<strong> exit <\/strong>pour quitter le shell PostgreSQL et revenir en tant qu&rsquo;utilisateur syst&egrave;me normal. Ensuite, proc&eacute;dez comme suit :<\/p><ol class=\"wp-block-list\">\n<li>Ouvrez le fichier de configuration &agrave; l&rsquo;aide d&rsquo;un &eacute;diteur de texte. Remplacez <strong>vim <\/strong>si vous utilisez un autre &eacute;diteur et modifiez le r&eacute;pertoire en cons&eacute;quence :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">vim \/etc\/postgresql\/14\/main\/postgresql.conf<\/pre><ol start=\"2\" class=\"wp-block-list\">\n<li>Recherchez la ligne <strong>listen_addresses<\/strong>.<\/li>\n\n\n\n<li>Supprimez le symbole<strong> # <\/strong>et remplacez la valeur par un ast&eacute;risque. Voici &agrave; quoi cela devrait ressembler :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">listen_addresses = '*'<\/pre><ol start=\"4\" class=\"wp-block-list\">\n<li>Utilisez la commande <strong>:wq <\/strong>pour enregistrer les modifications et quitter <strong>vim<\/strong>.<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a6ce58f62926\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a6ce58f62926\" class=\"aligncenter size-large wp-lightbox-container\"><img decoding=\"async\" width=\"1062\" height=\"58\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-43.png\/w=1024,h=1024,fit=scale-down\" alt=\"La ligne d'adresse listen dans le fichier de configuration PostgreSQL\" class=\"wp-image-46860\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-43.png\/w=1062,fit=scale-down 1062w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-43.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-43.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-43.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-43.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1062px) 100vw, 1062px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><ol start=\"5\" class=\"wp-block-list\">\n<li>D&eacute;finissez la politique d&rsquo;acc&egrave;s pour authentifier la connexion client &agrave; votre serveur PostgreSQL. Pour ce faire, ouvrez le fichier <strong>pg_hba.conf <\/strong>dans le m&ecirc;me r&eacute;pertoire &agrave; l&rsquo;aide de <strong>vim<\/strong>. La commande doit ressembler &agrave; ceci :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">vim \/etc\/postgresql\/14\/main\/pg_hba.conf<\/pre><ol start=\"6\" class=\"wp-block-list\">\n<li>Ajoutez une nouvelle politique au bas du fichier en utilisant cette syntaxe :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">connection database user ip_address encryption<\/pre><ol start=\"7\" class=\"wp-block-list\">\n<li>Par exemple, nous allons activer toutes les connexions TCP\/IP de tous les utilisateurs &agrave; toutes les bases de donn&eacute;es PostgreSQL. Ces utilisateurs peuvent utiliser n&rsquo;importe quelle adresse IP avec un mot de passe crypt&eacute; MD5. La r&egrave;gle se pr&eacute;sente comme suit :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">host all all 0.0.0.0\/0 md5<\/pre><ol start=\"8\" class=\"wp-block-list\">\n<li>Red&eacute;marrez le service PostgreSQL pour appliquer les modifications.<\/li>\n<\/ol><h3 class=\"wp-block-heading\"><strong>8. Configurer une connexion &agrave; une base de donn&eacute;es distante<\/strong><\/h3><p class=\"wp-block-paragraph\">Apr&egrave;s avoir configur&eacute; la base de donn&eacute;es, configurez l&rsquo;acc&egrave;s &agrave; distance &agrave; PostgreSQL &agrave; l&rsquo;aide de la commande <strong>psql<\/strong>. Pour ce faire, utilisez cette syntaxe de commande sur la machine cliente :<\/p><pre class=\"wp-block-preformatted\">psql -h ip_address -p port -d database -U username<\/pre><p class=\"wp-block-paragraph\">Par exemple, ex&eacute;cutez cette commande pour vous connecter &agrave; la base de donn&eacute;es TheNewUser h&eacute;berg&eacute;e dans un VPS avec l&rsquo;adresse IP<strong> 185.185.185.185 <\/strong>&agrave; l&rsquo;aide du compte <strong>TheNewUser <\/strong>:<\/p><pre class=\"wp-block-preformatted\">psql -h 185.185.185.185 -p 5432 -d TheNewUser -U TheNewUser<\/pre><p class=\"wp-block-paragraph\">N&rsquo;oubliez pas que le port PostgreSQL par d&eacute;faut est<strong> 5423<\/strong>. Pour v&eacute;rifier si la connexion est &eacute;tablie, ex&eacute;cutez cette commande :<\/p><pre class=\"wp-block-preformatted\">\\conninfo<\/pre><p class=\"wp-block-paragraph\">Une fois connect&eacute;, vous pouvez envoyer des requ&ecirc;tes &agrave; la base de donn&eacute;es pour r&eacute;cup&eacute;rer des donn&eacute;es. Pour activer l&rsquo;acc&egrave;s &agrave; distance &agrave; PostgreSQL dans votre application, installez un pilote de base de donn&eacute;es et importez le module dans votre code.<\/p><p class=\"wp-block-paragraph\">Dans ce tutoriel, nous vous montrerons comment proc&eacute;der dans une application Python h&eacute;berg&eacute;e sur un VPS <strong>Ubuntu 22.04<\/strong>. Apr&egrave;s vous &ecirc;tre connect&eacute; via SSH, proc&eacute;dez comme suit :<\/p><ol class=\"wp-block-list\">\n<li>Installez le <strong>gestionnaire de paquets pip <\/strong>&agrave; l&rsquo;aide de cette commande. Si vous l&rsquo;avez d&eacute;j&agrave;, ignorez cette &eacute;tape :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo apt-get install python-pip<\/pre><ol start=\"2\" class=\"wp-block-list\">\n<li>T&eacute;l&eacute;chargez et installez le pilote de base de donn&eacute;es <strong>psycopg2 <\/strong>&agrave; l&rsquo;aide de pip :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">pip install psycopg2-binary<\/pre><ol start=\"3\" class=\"wp-block-list\">\n<li>Ajoutez la ligne suivante &agrave; votre code d&rsquo;application pour importer le module et &eacute;tablir une connexion avec la base de donn&eacute;es PostgreSQL. N&rsquo;oubliez pas de modifier la valeur en cons&eacute;quence :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">import psycopg2<br># Connectez votre application &agrave; la base de donn&eacute;es distante<br>conn = psycopg2.connect(host=\"182.182.182.182\", port=\"5432\", dbname=\"TestNewUser\", user=\"TestNewUser\", password=\"UserPassword\")<br># Ouvrez un curseur pour les op&eacute;rations de base de donn&eacute;es<br>cur = conn.cursor()<br># Ex&eacute;cutez une requ&ecirc;te. Remplacez table par votre propre table <br>cur.execute(\"SELECT * FROM table\")<br># R&eacute;cup&eacute;rez les donn&eacute;es<br>records = cur.fetchall()<\/pre><h3 class=\"wp-block-heading\"><strong>9. Installer pgAdmin<\/strong><\/h3><p class=\"wp-block-paragraph\">Installez l&rsquo;interface graphique web <strong>pgAdmin <\/strong>pour simplifier vos t&acirc;ches de gestion de base de donn&eacute;es PostgreSQL. Nous utiliserons le gestionnaire de paquets APT pour l&rsquo;installer :<\/p><ol class=\"wp-block-list\">\n<li>Ex&eacute;cutez ces commandes individuellement pour ajouter le r&eacute;f&eacute;rentiel officiel pgAdmin :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">curl -fsSL https:\/\/www.pgadmin.org\/static\/packages_pgadmin_org.pub | sudo gpg --dearmor -o \/etc\/apt\/trusted.gpg.d\/pgadmin.gpg<br><br>sudo sh -c 'echo \"deb https:\/\/ftp.postgresql.org\/pub\/pgadmin\/pgadmin4\/apt\/$(lsb_release -cs) pgadmin4 main\" &gt; \/etc\/apt\/sources.list.d\/pgadmin4.list'<\/pre><ol start=\"2\" class=\"wp-block-list\">\n<li>Mettez &agrave; jour les listes de paquets pour synchroniser le r&eacute;f&eacute;rentiel.<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo apt update<\/pre><ol start=\"3\" class=\"wp-block-list\">\n<li>Ex&eacute;cutez la commande suivante pour installer pgAdmin :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo apt install pgadmin4<\/pre><ol start=\"4\" class=\"wp-block-list\">\n<li>Une fois la configuration de l&rsquo;interface graphique termin&eacute;e, lancez la configuration principale de pgAdmin &agrave; l&rsquo;aide de cette commande :<\/li>\n<\/ol><pre class=\"wp-block-preformatted\">sudo \/usr\/pgadmin4\/bin\/setup-web.sh<\/pre><ol start=\"5\" class=\"wp-block-list\">\n<li>Entrez votre adresse e-mail et votre mot de passe. Cela devrait ressembler &agrave; ceci :<\/li>\n<\/ol><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a6ce58f6642c\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a6ce58f6642c\" class=\"aligncenter size-large wp-lightbox-container\"><img decoding=\"async\" width=\"1024\" height=\"333\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-52.png\/w=1024,h=1024,fit=scale-down\" alt=\"Le script bash pour lancer la configuration de pgAdmin\" class=\"wp-image-46871\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-52.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-52.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-52.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-52.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><p class=\"wp-block-paragraph\">Pour acc&eacute;der &agrave; l&rsquo;interface Web pgAdmin, saisissez l&rsquo;adresse suivante dans la barre d&rsquo;adresse de votre navigateur Web :<\/p><pre class=\"wp-block-preformatted\">185.185.185.185\/pgadmin4<\/pre><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a6ce58f68c09\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a6ce58f68c09\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"851\" height=\"543\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-46.png\/public\" alt=\"&Eacute;cran de connexion pour l'interface graphique pgAdmin avec le bouton de connexion mis en &eacute;vidence\" class=\"wp-image-46868\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-46.png\/w=851,fit=scale-down 851w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-46.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-46.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-46.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 851px) 100vw, 851px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><p class=\"wp-block-paragraph\">Remplacez l&rsquo;adresse IP par celle de votre VPS. Entrez ensuite votre adresse e-mail et votre mot de passe. Cliquez sur <strong>Connexion <\/strong>pour acc&eacute;der au tableau de bord principal de pgAdmin.<\/p><p class=\"wp-block-paragraph\">Pour connecter PostgreSQL, s&eacute;lectionnez <strong>Ajouter un nouveau serveur <\/strong>et poursuivez le processus de configuration.<\/p><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6a6ce58f6ba50\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6a6ce58f6ba50\" class=\"aligncenter size-full wp-lightbox-container\"><img decoding=\"async\" width=\"954\" height=\"768\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-3.jpeg\/public\" alt=\"Fen&ecirc;tre principale de gestion de pgAdmin avec le bouton Ajouter un nouveau serveur mis en &eacute;vidence\" class=\"wp-image-46865\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-3.jpeg\/w=954,fit=scale-down 954w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-3.jpeg\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-3.jpeg\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/46\/2026\/03\/image-3.jpeg\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 954px) 100vw, 954px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewbox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><h2 class=\"wp-block-heading\" id=\"h-depannage-de-linstallation-de-postgresql\"><strong>D&eacute;pannage de l&rsquo;installation de PostgreSQL<\/strong><\/h2><p class=\"wp-block-paragraph\">Dans cette section, nous allons examiner les probl&egrave;mes courants li&eacute;s &agrave; l&rsquo;installation de PostgreSQL et leurs solutions.<\/p><h3 class=\"wp-block-heading\"><strong>1. Impossible de se connecter au serveur PostgreSQL<\/strong><\/h3><p class=\"wp-block-paragraph\">Tout d&rsquo;abord, vous devez v&eacute;rifier si le syst&egrave;me client est correctement connect&eacute; &agrave; Internet. Si la connexion Internet n&rsquo;est pas en cause, les autres causes courantes de cette erreur sont une base de donn&eacute;es inactive ou des permissions de fichiers mal configur&eacute;es.<\/p><p class=\"wp-block-paragraph\">V&eacute;rifiez l&rsquo;&eacute;tat de PostgreSQL et assurez-vous qu&rsquo;il est <strong>charg&eacute; <\/strong>et <strong>actif<\/strong>. Sinon, red&eacute;marrez-le &agrave; l&rsquo;aide de la commande suivante :<\/p><pre class=\"wp-block-preformatted\">sudo systemctl restart postgresql<\/pre><p class=\"wp-block-paragraph\">Si cela ne fonctionne pas, v&eacute;rifiez si les permissions du r&eacute;pertoire et des fichiers PostgreSQL sont d&eacute;finies sur<strong> 0700 <\/strong>et<strong> 0600<\/strong>. Pour ce faire, utilisez la commande suivante :<\/p><pre class=\"wp-block-preformatted\">ls \/var\/lib\/postgresql\/main<\/pre><p class=\"wp-block-paragraph\">Ensuite, utilisez la <a href=\"https:\/\/www.hostinger.com\/fr\/tutoriels\/changer-permissions-fichier-linux\/\" data-type=\"link\" data-id=\"https:\/\/www.hostinger.com\/fr\/tutoriels\/changer-permissions-fichier-linux\">commande<strong> chmod <\/strong>pour modifier leurs permissions<\/a>.<\/p><h3 class=\"wp-block-heading\"><strong>2. Probl&egrave;mes de connexion PostgreSQL &agrave; partir d&rsquo;un h&ocirc;te distant<\/strong><\/h3><p class=\"wp-block-paragraph\">Une politique de connexion mal configur&eacute;e peut entra&icirc;ner des probl&egrave;mes d&rsquo;h&ocirc;te distant qui vous emp&ecirc;chent d&rsquo;acc&eacute;der au serveur PostgreSQL. Pour r&eacute;soudre ce probl&egrave;me, ouvrez votre fichier <strong>pg_hba.conf <\/strong>et ajoutez la politique d&rsquo;acc&egrave;s &agrave; partir de l&rsquo;adresse IP de chaque client :<\/p><pre class=\"wp-block-preformatted\">host all all 0.0.0.0\/0 md5<\/pre><p class=\"wp-block-paragraph\">V&eacute;rifiez ensuite la valeur<strong> listen_address <\/strong>dans votre fichier de configuration<strong> postgres.conf<\/strong>. Assurez-vous qu&rsquo;elle comporte un <strong>ast&eacute;risque <\/strong>afin que PostgreSQL puisse &eacute;couter toutes les adresses IP.<\/p><p class=\"wp-block-paragraph\">Si cela ne fonctionne pas, v&eacute;rifiez si votre pare-feu ferme le port d&rsquo;&eacute;coute PostgreSQL. Pour le serveur Ubuntu, ex&eacute;cutez la commande<strong> ufw <\/strong>:<\/p><pre class=\"wp-block-preformatted\">sudo ufw status verbose<\/pre><p class=\"wp-block-paragraph\">Si la connexion depuis et vers le port<strong> 5432 <\/strong>est d&eacute;sactiv&eacute;e, ouvrez-la &agrave; l&rsquo;aide de la commande suivante :<\/p><pre class=\"wp-block-preformatted\">sudo ufw allow 5432\/tcp<\/pre><p>\n\n\n        <div class=\"protip\">\n            <div class=\"protip__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path d=\"M1.49234 23.5024C1.23229 23.5024 0.972242 23.4024 0.782206 23.2123C0.562165 22.9923 0.452144 22.6822 0.502153 22.3722C0.562165 21.9221 1.14227 17.9113 3.00262 16.351C3.63274 15.8209 4.43289 15.5509 5.26305 15.5609C6.09321 15.5909 6.87335 15.9109 7.47347 16.4911C8.6937 17.6913 8.76371 19.6717 7.6435 20.9919C6.0832 22.8523 2.08245 23.4324 1.63237 23.4924C1.59236 23.4924 1.54235 23.4924 1.50234 23.4924L1.49234 23.5024ZM5.16303 17.5613C4.84297 17.5613 4.53291 17.6713 4.29287 17.8813C3.60274 18.4614 3.07264 19.9317 2.75258 21.242C4.06282 20.9219 5.5331 20.3918 6.11321 19.7017C6.55329 19.1716 6.54329 18.3814 6.0832 17.9213C5.85316 17.7013 5.5431 17.5713 5.20304 17.5613C5.19304 17.5613 5.17303 17.5613 5.16303 17.5613ZM11.7243 21.8821C11.4942 21.8821 11.2642 21.8021 11.0841 21.652C10.8541 21.462 10.7241 21.1819 10.7241 20.8819V15.9109L8.08358 13.2705H3.11264C2.81259 13.2705 2.53254 13.1404 2.3425 12.9104C2.15246 12.6803 2.07245 12.3803 2.12246 12.0902C2.19247 11.7102 2.84259 8.36953 4.70294 7.12929C6.33325 6.04909 8.96375 6.49918 10.244 6.80923C11.5442 4.96889 13.2546 3.4286 15.2349 2.33839C17.4553 1.11816 19.9858 0.518051 22.4963 0.498047C23.0464 0.498047 23.4865 0.948132 23.4865 1.49824C23.4865 5.0389 22.3763 9.97983 17.1753 13.7605C17.4853 15.0408 17.9354 17.6613 16.8552 19.2816C15.615 21.1419 12.2744 21.7921 11.8943 21.8621C11.8343 21.8721 11.7743 21.8821 11.7143 21.8821H11.7243ZM12.7245 16.181V19.6016C13.7146 19.2916 14.7948 18.7915 15.2049 18.1814C15.675 17.4812 15.605 16.091 15.385 14.9008C14.5248 15.3808 13.6346 15.8109 12.7245 16.181ZM9.66388 12.0302L11.9643 14.3307C13.1845 13.8306 14.3648 13.2204 15.485 12.5103C19.9358 9.51974 21.2361 5.60901 21.4561 2.53843C19.6157 2.67846 17.8254 3.20856 16.2051 4.09872C14.2847 5.14892 12.6544 6.68921 11.4942 8.54956C10.7841 9.65977 10.174 10.82 9.66388 12.0302ZM4.39289 11.2701H7.81353C8.1936 10.3599 8.63368 9.46974 9.11377 8.60957C7.92355 8.38953 6.51329 8.31952 5.81315 8.78961C5.19304 9.19968 4.70294 10.3099 4.39289 11.2701Z\" fill=\"#673DE6\"\/>\n                <\/svg>\n                <p class=\"protip__title\">\n                     En savoir plus sur le pare-feu Ubuntu                 <\/p>\n            <\/div>\n            <p class=\"protip__content\"> Consultez notre autre article pour savoir <a href=\"https:\/\/www.hostinger.com\/fr\/tutoriels\/comment-configurer-pare-feu-ufw\/\">comment configurer le pare-feu Ubuntu &agrave; l'aide d'Uncomplicated Firewall (UFW)<\/a>. <\/p>\n                    <\/div>\n        \n\n\n\n<\/p><h3 class=\"wp-block-heading\"><strong>3. Probl&egrave;mes de connexion &agrave; pgAdmin<\/strong><\/h3><p class=\"wp-block-paragraph\">Des probl&egrave;mes de connexion &agrave; pgAdmin peuvent survenir en raison d&rsquo;une erreur de connexion &agrave; la base de donn&eacute;es. S&rsquo;il s&rsquo;agit d&rsquo;un probl&egrave;me li&eacute; au r&eacute;seau, essayez les solutions pr&eacute;c&eacute;dentes et r&eacute;installez pgAdmin.<\/p><p class=\"wp-block-paragraph\">Si le probl&egrave;me est li&eacute; aux identifiants de connexion du compte utilisateur, entrez dans la session<strong> psql <\/strong>et r&eacute;initialisez le mot de passe &agrave; l&rsquo;aide de cette instruction :<\/p><pre class=\"wp-block-preformatted\">ALTER USER username WITH PASSWORD 'new_password';<\/pre><p class=\"wp-block-paragraph\">Vous pouvez &eacute;galement rencontrer des probl&egrave;mes de connexion si l&rsquo;utilisateur ne dispose pas du privil&egrave;ge <strong>LOGIN<\/strong>. Pour l&rsquo;accorder, utilisez l&rsquo;instruction suivante :<\/p><pre class=\"wp-block-preformatted\">ALTER USER username WITH LOGIN;<\/pre><h3 class=\"wp-block-heading\"><strong>4. Conflit de versions PostgreSQL<\/strong><\/h3><p class=\"wp-block-paragraph\">Les conflits de version se produisent lorsque PostgreSQL est incompatible avec la base de donn&eacute;es ou d&rsquo;autres applications. La cause la plus courante est la non-mise &agrave; jour de PostgreSQL, ce qui entra&icirc;ne une incompatibilit&eacute; de version.<\/p><p class=\"wp-block-paragraph\">Pour r&eacute;soudre ce probl&egrave;me, r&eacute;installez ou mettez &agrave; jour PostgreSQL &agrave; partir du r&eacute;f&eacute;rentiel officiel APT. Mettez &eacute;galement &agrave; jour toutes les applications tierces, car elles peuvent &ecirc;tre obsol&egrave;tes.<\/p><p class=\"wp-block-paragraph\">Nous vous recommandons de tester la derni&egrave;re version dans un environnement de d&eacute;veloppement afin d&rsquo;&eacute;viter d&rsquo;autres probl&egrave;mes sur le serveur en production.<\/p><h3 class=\"wp-block-heading\"><strong>5. Impossible de cr&eacute;er un utilisateur ou une base de donn&eacute;es PostgreSQL<\/strong><\/h3><p class=\"wp-block-paragraph\">Une syntaxe de commande incorrecte provoque souvent des erreurs lors de la cr&eacute;ation d&rsquo;utilisateurs et de bases de donn&eacute;es PostgreSQL. Pour y rem&eacute;dier, assurez-vous que votre commande se termine par un point-virgule (<strong>;<\/strong>).<\/p><p class=\"wp-block-paragraph\">Vous devez &eacute;galement ex&eacute;cuter la commande en utilisant l&rsquo;utilisateur <strong>postgres <\/strong>et la ligne de commande<strong> psql<\/strong>. Pour ce faire, ex&eacute;cutez cette commande :<\/p><pre class=\"wp-block-preformatted\">sudo -u postgres psql<\/pre><p class=\"wp-block-paragraph\">Si votre terminal affiche ce qui suit, vous devriez pouvoir cr&eacute;er un utilisateur et une base de donn&eacute;es.<\/p><pre class=\"wp-block-preformatted\">postgres=#<\/pre><h2 class=\"wp-block-heading\" id=\"h-conclusion\"><strong>Conclusion<\/strong><\/h2><p class=\"wp-block-paragraph\">PostgreSQL est un syst&egrave;me de gestion de base de donn&eacute;es open source d&eacute;velopp&eacute; par la communaut&eacute;. Il utilise une structure logique pour stocker efficacement de grandes quantit&eacute;s de donn&eacute;es et simplifier leur acc&egrave;s.<\/p><p class=\"wp-block-paragraph\">Dans ce tutoriel sur les syst&egrave;mes de gestion de bases de donn&eacute;es relationnelles, nous avons expliqu&eacute; les &eacute;tapes &agrave; suivre pour installer PostgreSQL sur Ubuntu 22.04 via l&rsquo;invite de commande Linux. Voici un r&eacute;capitulatif :<\/p><ol class=\"wp-block-list\">\n<li>Installez PostgreSQL &agrave; partir du r&eacute;f&eacute;rentiel officiel &agrave; l&rsquo;aide d&rsquo;<strong>APT<\/strong>.<\/li>\n\n\n\n<li>Ex&eacute;cutez <strong>systemctl status <\/strong>pour v&eacute;rifier si Postgresql est actif.<\/li>\n\n\n\n<li>Connectez-vous au compte PostgreSQL &agrave; l&rsquo;aide de <strong>sudo su &ndash; postgres<\/strong>.<\/li>\n\n\n\n<li>Modifiez le mot de passe du compte administrateur par d&eacute;faut pour am&eacute;liorer la s&eacute;curit&eacute;.<\/li>\n\n\n\n<li>Cr&eacute;ez un nouvel utilisateur PostgreSQL pour g&eacute;rer vos bases de donn&eacute;es.<\/li>\n\n\n\n<li>Cr&eacute;ez une nouvelle base de donn&eacute;es &agrave; l&rsquo;aide de la commande<strong> createdb<\/strong>.<\/li>\n\n\n\n<li>Configurez le serveur PostgreSQL en d&eacute;finissant sa politique de connexion.<\/li>\n\n\n\n<li>Configurez une connexion &agrave; votre base de donn&eacute;es PostgreSQL distante.<\/li>\n\n\n\n<li>Installez pgAdmin pour fournir une interface utilisateur graphique.<\/li>\n<\/ol><p class=\"wp-block-paragraph\">Pour &eacute;viter tout probl&egrave;me, assurez-vous que les politiques de connexion et les identifiants de connexion pgAdmin sont correctement configur&eacute;s. De plus, installez la derni&egrave;re version du SGBDR via APT pour &eacute;viter tout probl&egrave;me d&rsquo;incompatibilit&eacute;.<\/p><h2 class=\"wp-block-heading\" id=\"h-comment-installer-postgresql-sur-ubuntu-faq\"><strong>Comment installer PostgreSQL sur Ubuntu &ndash; FAQ<\/strong><\/h2><div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<div id=\"faq-question-1773159257817\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>O&ugrave; Postgres est-il install&eacute; sur Ubuntu ?&nbsp;<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>Sur Ubuntu, les principaux fichiers du serveur PostgreSQL se trouvent dans le r&eacute;pertoire<strong> \/usr\/lib\/postgresql\/&lt;version\/bin\/postgres<\/strong>. Tous les clusters de bases de donn&eacute;es sont stock&eacute;s dans le r&eacute;pertoire <strong>\/var\/lib\/postgresql\/main<\/strong>. Quant aux param&egrave;tres PostgreSQL, ils se trouvent dans le fichier<strong> \/etc\/postgresql\/main\/postgresql.conf<\/strong>.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1773159269809\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>Comment savoir si PostgreSQL est install&eacute; sur Ubuntu ?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>La fa&ccedil;on la plus simple de v&eacute;rifier si PostgreSQL est install&eacute; sur un serveur Ubuntu est d&rsquo;ex&eacute;cuter <strong>sudo -u postgres psql <\/strong>ou <strong>which psql<\/strong>. Le terminal devrait afficher le chemin d&rsquo;installation si le logiciel est install&eacute;.<\/p>\n\n<\/div>\n<\/div>\n<div id=\"faq-question-1773159276617\" class=\"rank-math-list-item\">\n<h3 class=\"rank-math-question \"><strong>Dois-je utiliser PostgreSQL 13 ou 14 ?<\/strong><\/h3>\n<div class=\"rank-math-answer \">\n\n<p>PostgreSQL 14 offre une meilleure &eacute;volutivit&eacute; des connexions. Cela rend PostgreSQL 14 plus adapt&eacute; aux grandes entreprises qui ont de nombreuses connexions &agrave; la base de donn&eacute;es. Nous vous recommandons de rester &agrave; la version la plus r&eacute;cente pour b&eacute;n&eacute;ficier des derni&egrave;res fonctionnalit&eacute;s, am&eacute;liorations et correctifs.<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL est un syst&egrave;me de gestion de base de donn&eacute;es relationnelle (SGBDR) open source tr&egrave;s populaire, connu pour son &eacute;volutivit&eacute; et son efficacit&eacute; dans le traitement de grandes quantit&eacute;s de donn&eacute;es. Gr&acirc;ce &agrave; ses performances &eacute;lev&eacute;es, PostgreSQL est id&eacute;al pour les sites web ou les applications des grandes entreprises. Il prend &eacute;galement en charge divers [&#8230;]<\/p>\n<p><a class=\"btn btn-secondary understrap-read-more-link\" href=\"\/fr\/tutoriels\/installer-postgresql-ubuntu\/\">Read More&#8230;<\/a><\/p>\n","protected":false},"author":355,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_title":"Comment installer PostgreSQL sur Ubuntu + configurer pgAdmin","rank_math_description":"Apprenez \u00e0 installer PostgreSQL sur Ubuntu 22.04 avec APT et le d\u00e9p\u00f4t local. Guide d\u2019installation et d\u2019utilisation de pgAdmin inclus.","rank_math_focus_keyword":"installer postgresql ubuntu","footnotes":""},"categories":[4760],"tags":[],"class_list":["post-46859","post","type-post","status-publish","format-standard","hentry","category-vps"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/tutorials\/how-to-install-postgresql-on-ubuntu\/","default":1},{"locale":"pt-BR","link":"https:\/\/www.hostinger.com\/br\/tutoriais\/instalar-postgresql-ubuntu\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/tutoriels\/installer-postgresql-ubuntu\/","default":0},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/tutoriales\/instalar-postgresql-ubuntu\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/tutorial\/install-postgresql-ubuntu\/","default":0},{"locale":"en-PH","link":"https:\/\/www.hostinger.com\/ph\/tutorials\/how-to-install-postgresql-on-ubuntu\/","default":0},{"locale":"en-MY","link":"https:\/\/www.hostinger.com\/my\/tutorials\/how-to-install-postgresql-on-ubuntu\/","default":0},{"locale":"en-GB","link":"https:\/\/www.hostinger.com\/uk\/tutorials\/how-to-install-postgresql-on-ubuntu\/","default":0},{"locale":"en-IN","link":"https:\/\/www.hostinger.com\/in\/tutorials\/how-to-install-postgresql-on-ubuntu\/","default":0},{"locale":"en-CA","link":"https:\/\/www.hostinger.com\/ca\/tutorials\/how-to-install-postgresql-on-ubuntu\/","default":0},{"locale":"en-AU","link":"https:\/\/www.hostinger.com\/au\/tutorials\/how-to-install-postgresql-on-ubuntu\/","default":0},{"locale":"en-NG","link":"https:\/\/www.hostinger.com\/ng\/tutorials\/how-to-install-postgresql-on-ubuntu\/","default":0},{"locale":"es-AR","link":"https:\/\/www.hostinger.com\/ar\/tutoriales\/instalar-postgresql-ubuntu\/","default":0},{"locale":"es-MX","link":"https:\/\/www.hostinger.com\/mx\/tutoriales\/instalar-postgresql-ubuntu\/","default":0},{"locale":"es-CO","link":"https:\/\/www.hostinger.com\/co\/tutoriales\/instalar-postgresql-ubuntu\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/pt\/tutoriais\/instalar-postgresql-ubuntu\/","default":0}],"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/fr\/tutoriels\/wp-json\/wp\/v2\/posts\/46859","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/fr\/tutoriels\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/fr\/tutoriels\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/tutoriels\/wp-json\/wp\/v2\/users\/355"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/tutoriels\/wp-json\/wp\/v2\/comments?post=46859"}],"version-history":[{"count":5,"href":"https:\/\/www.hostinger.com\/fr\/tutoriels\/wp-json\/wp\/v2\/posts\/46859\/revisions"}],"predecessor-version":[{"id":46904,"href":"https:\/\/www.hostinger.com\/fr\/tutoriels\/wp-json\/wp\/v2\/posts\/46859\/revisions\/46904"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/fr\/tutoriels\/wp-json\/wp\/v2\/media?parent=46859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/tutoriels\/wp-json\/wp\/v2\/categories?post=46859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/tutoriels\/wp-json\/wp\/v2\/tags?post=46859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}