Une fois que vous avez install\u00e9 avec succ\u00e8s PostgreSQL sur votre machine Debian 12, vous pouvez le configurer.<\/p>\n\n\n\n
Configurer PostgreSQL<\/strong><\/p>\n\n\n\n La configuration d’un mot de passe valide et fort pour vos bases de donn\u00e9es est une pratique essentielle qui renforce la s\u00e9curit\u00e9. Pour ce faire, ex\u00e9cutez la commande en administrateur root :<\/p>\n\n\n\n Passer \u00e0 PostgreSQ<\/strong><\/p>\n\n\n\n \u00ab postgres \u00bb est un superutilisateur par d\u00e9faut de PostgreSQL. Utilisez la commande ci-dessous pour passer de \u00ab debianuser \u00bb \u00e0 \u00ab postgres \u00bb :<\/p>\n\n\n\n Acc\u00e9der \u00e0 SQL Shell<\/strong><\/p>\n\n\n\n psql ou SQL Shell est l’outil bas\u00e9 sur terminal par d\u00e9faut pour Postgres. Il peut \u00eatre utilis\u00e9 pour effectuer n’importe quelle op\u00e9ration de base de donn\u00e9es \u00e0 l’aide de requ\u00eates SQL ou de m\u00e9ta-commandes. Pour acc\u00e9der \u00e0 SQL Shell, tapez simplement \u00ab psql \u00bb et appuyez sur la touche [ENTR\u00c9E] :<\/p>\n\n\n\n Pour quitter :<\/p>\n\n\n\n V\u00e9rifier la version de PostgreSQL<\/strong><\/p>\n\n\n\n Dans SQL Shell, nous pouvons ex\u00e9cuter n’importe quelle commande ou requ\u00eate pour ex\u00e9cuter une fonctionnalit\u00e9 sp\u00e9cifique. Par exemple, la commande suivante affiche la version de Postgres actuellement install\u00e9e sur notre machine Debian 12 :<\/p>\n\n\n\n R\u00e9pertorier les bases de donn\u00e9es<\/strong><\/p>\n\n\n\n En tant que d\u00e9butant, l’une des m\u00e9ta-commandes incontournables est \u00ab \\l \u00bb qui affiche la liste des bases de donn\u00e9es disponibles :<\/p>\n\n\n\n [Q]<\/strong> pour quitter<\/p>\n\n\n\n Supprimer une base de donn\u00e9es<\/strong><\/p>\n\n\n\n Une fois que vous avez install\u00e9 avec succ\u00e8s PostgreSQL sur votre machine Debian 12, vous pouvez le configurer. Configurer PostgreSQL La configuration d’un mot de passe valide et fort pour vos bases de donn\u00e9es est une pratique essentielle qui renforce la s\u00e9curit\u00e9. Pour ce faire, ex\u00e9cutez la commande en administrateur root : passwd postgres Passer \u00e0 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-658","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/pages\/658","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/comments?post=658"}],"version-history":[{"count":2,"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/pages\/658\/revisions"}],"predecessor-version":[{"id":662,"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/pages\/658\/revisions\/662"}],"wp:attachment":[{"href":"https:\/\/artheodoc.fr\/index.php\/wp-json\/wp\/v2\/media?parent=658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}passwd postgres<\/strong><\/pre>\n\n\n\n
su -- postgres<\/strong><\/pre>\n\n\n\n
psql<\/strong><\/pre>\n\n\n\n
exit<\/strong><\/pre>\n\n\n\n
SELECT VERSION();<\/strong><\/pre>\n\n\n\n
\\l<\/strong><\/pre>\n\n\n\n
DROP DATABASE nom<\/em>;<\/strong><\/pre>\n","protected":false},"excerpt":{"rendered":"