{"id":32729,"date":"2026-05-11T15:15:07","date_gmt":"2026-05-11T15:15:07","guid":{"rendered":"https:\/\/dev.indyli-services.com\/?p=32729"},"modified":"2026-05-12T13:27:40","modified_gmt":"2026-05-12T13:27:40","slug":"sauvegarder-automatiquement-une-base-de-donnees-avec-loutil-pg_dump","status":"publish","type":"post","link":"https:\/\/dev.indyli-services.com\/?p=32729","title":{"rendered":"Sauvegarder automatiquement une base de donn\u00e9es avec l\u2019outil pg_dump"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"32729\" class=\"elementor elementor-32729\">\n\t\t\t\t<div class=\"elementor-element elementor-element-11ea9f3 e-flex e-con-boxed e-con e-parent\" data-id=\"11ea9f3\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-fc58499 elementor-widget elementor-widget-text-editor\" data-id=\"fc58499\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px; text-align: center;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 18pt; color: #800000;\"><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><u style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">INTRODUCTION<\/u><\/strong><\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px; text-align: start;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">PostgreSQL est un SGBD libre et gratuit, permettant de stocker vos donn\u00e9es. Il stocker les donn\u00e9es dans les tables et une table peut contenir plus de 2TO de donn\u00e9es. Ayant une grande capacit\u00e9 de stockage, PostgreSQL permet une garantie sur les donn\u00e9es par le biais de la s\u00e9curit\u00e9, la sauvegarde et la Restauration des donn\u00e9es, \u2026<\/span><\/p><ol style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; padding: 0px; vertical-align: baseline; outline: 0px; list-style-position: inside; color: #797979; font-family: Lato; font-size: 14px; text-align: start;\"><li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #800000;\"><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\"><u style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\">Script de Sauvegarde des donn\u00e9es<\/u><\/span><\/strong><\/span><\/li><\/ol><ul style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin: 0px; padding-left: 0px; vertical-align: baseline; outline: 0px; list-style-position: inside; color: #797979; font-family: Lato; font-size: 14px; text-align: start;\"><li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #800000;\"><strong style=\"background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Utilisation de l\u2019outil pg_dump<\/span><\/strong><\/span><\/li><\/ul><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px; text-align: start;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">PostgreSQL dispose de plusieurs outils pour faciliter l\u2019administration des bases de donn\u00e9es. Les outils pg_dump et pg_dumpall permettent de sauvegarder les donn\u00e9es sous un serveur PostgreSQL.<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px; text-align: start;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Dans ce projet de sauvegarde des donn\u00e9es sur un serveur PostgreSQL distant sous Windows, nous avons pu mettre sur pied \u00e0 travers des recherches un script qui permet d\u2019effectuer une sauvegarde des donn\u00e9es.<\/span><\/p><p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px; text-align: start;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Ce script peut s\u2019ex\u00e9cuter par Automatisation ou manuellement. Son contenu est le suivant :<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-762a18f e-flex e-con-boxed e-con e-parent\" data-id=\"762a18f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-09054dc elementor-widget elementor-widget-image\" data-id=\"09054dc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"640\" height=\"214\" src=\"https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/script.png\" class=\"attachment-large size-large wp-image-32764\" alt=\"\" srcset=\"https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/script.png 903w, https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/script-300x100.png 300w, https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/script-768x257.png 768w, https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/script-600x201.png 600w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-fde3886 e-flex e-con-boxed e-con e-parent\" data-id=\"fde3886\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-051a6f9 elementor-widget elementor-widget-text-editor\" data-id=\"051a6f9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<ul style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin: 0px; padding-left: 0px; vertical-align: baseline; outline: 0px; list-style-position: inside; color: #797979; font-family: Lato; font-size: 14px;\">\n \t<li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">Les variables JOUR, MOIS, ANNEE sont des variables qui permettent d\u2019avoir la DATE et les variables HEURE, MINUTE, SECOND permettent d\u2019avoir le TEMPS. Ces variables peuvent respectivement \u00eatre remplac\u00e9es par les variables DATE et TIME.<\/span><\/li>\n \t<li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">A la ligne 10 nous avons le r\u00e9pertoire o\u00f9 sera cr\u00e9\u00e9 les fichiers de sauvegarde.<\/span><\/li>\n \t<li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">A la ligne 12 nous avons le fichier de sauvegarde renommer avec la date , l\u2019heure et les minutes permettant de diff\u00e9rencier les sauvegardes et d\u2019utiliser la plus r\u00e9cente.<\/span><\/li>\n \t<li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">La ligne 14 pr\u00e9cise simplement que si le r\u00e9pertoire de sauvegarde n\u2019existe pas alors qu\u2019il soit cr\u00e9\u00e9.<\/span><\/li>\n \t<li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">La ligne 16 est la ligne la plus importante, car c\u2019est elle qui effectue la sauvegarde des donn\u00e9es de la base de donn\u00e9e.<\/span><\/li>\n<\/ul>\n<p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Elle contient :<\/span><\/p>\n\n<ul style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin: 0px; padding-left: 0px; vertical-align: baseline; outline: 0px; list-style-position: inside; color: #797979; font-family: Lato; font-size: 14px;\">\n \t<li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">pg_dump qui est l\u2019 outil de sauvegarde des donn\u00e9es de PostgreSQL<\/span><\/li>\n \t<li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">\u2013host localhost permet de sp\u00e9cifier l\u2019adresse de la machine serveur<\/span><\/li>\n \t<li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">\u2013port 5433 permet de sp\u00e9cifier le port de connexion du serveur PostgreSQL sur la machine serveur<\/span><\/li>\n \t<li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">\u2013username nom_utilisateur permet de sp\u00e9cifier le nom de l\u2019utilisateur ou du r\u00f4le se trouvant sur le serveur.<\/span><\/li>\n \t<li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">\u2013file chemin_du_fichier_de_sauvegarde permet de sauvegarder toutes les donn\u00e9es dans le fichier de sauvegarde<\/span><\/li>\n \t<li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">\u2013verbose permet juste de voir comment le processus de sauvegarde s\u2019ex\u00e9cute<\/span><\/li>\n \t<li style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-size: 14pt;\">Bd_parifoot ici c\u2019est la base de donn\u00e9e dont la sauvegarde des donn\u00e9es doit \u00eatre effectu\u00e9e.<\/span><\/li>\n<\/ul>\n<p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">NB : Il faut ins\u00e9rer le chemin du r\u00e9pertoire <span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #800000;\">C:\\Program Files (x86)\\PostgreSQL\\9.6\\bin<\/span> dans le path de windows.<\/span><\/p>\n<p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">lors de l\u2019ex\u00e9cution de ce script un mot de passe sera demand\u00e9 et il faut le saisir pourque la sauvegarde s\u2019effectue.<\/span><\/p>\n<p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Mais\u00a0 dans le cas o\u00f9 s\u2019ex\u00e9cution du script serait automatis\u00e9 il faudrait configurer le fichier .pgpass\u00a0 sous linux ou pgpass.conf sous windows qui est un fichier cach\u00e9 \u00e0fin que le script s\u2019ex\u00e9cute sans demander de mot de passe. Il se trouve dans le \/home\/utilisateur sous linux et dans <span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #800000;\">C:\\Utilisateur\\nom_de_la_machine\\AppData\\Roaming\\<\/span>postgresql sous windows.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-bc5e8fa e-flex e-con-boxed e-con e-parent\" data-id=\"bc5e8fa\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ef274bc elementor-widget elementor-widget-image\" data-id=\"ef274bc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"384\" height=\"42\" src=\"https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/config.png\" class=\"attachment-large size-large wp-image-32765\" alt=\"\" srcset=\"https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/config.png 384w, https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/config-300x33.png 300w\" sizes=\"(max-width: 384px) 100vw, 384px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e9c2296 e-flex e-con-boxed e-con e-parent\" data-id=\"e9c2296\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-678b116 elementor-widget elementor-widget-text-editor\" data-id=\"678b116\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">La 1ere ligne de ce fichier est en commentaire expliquant les diff\u00e9rents \u00e9l\u00e9ments se trouvant \u00e0 la ligne 2.<\/span><\/p>\n<p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">L\u2019\u00e9toile signifie simplement\u00a0 n\u2019importe quel base de donn\u00e9es.<\/span><\/p>\n<p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Ces informations sont celles se trouvant sur la machine serveur distante ou lacal, mais la configuration du fichier pgpass.conf ou .pgpass se fait sur la machine qui ex\u00e9cute le script dont la machine cliente.<\/span><\/p>\n<p style=\"background-image: initial; background-position: 0px 0px; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; border: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; vertical-align: baseline; outline: 0px; color: #000000; font-family: Lato; font-size: 14px;\"><span style=\"-webkit-tap-highlight-color: transparent; background: 0px 0px; border: 0px; margin: 0px; padding: 0px; vertical-align: baseline; outline: 0px; font-size: 14pt;\">Apr\u00e8s avoir fait cela la sauvegarde peux s\u2019ex\u00e9cuter soit par Automatisation du script soit Manullement.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>INTRODUCTION PostgreSQL est un SGBD libre et gratuit, permettant de stocker vos donn\u00e9es. Il stocker les donn\u00e9es dans les tables et une table peut contenir plus de 2TO de donn\u00e9es. Ayant une grande capacit\u00e9 de stockage, PostgreSQL permet une garantie &hellip; <\/p>\n","protected":false},"author":1,"featured_media":32786,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"elementor_header_footer","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[87],"tags":[],"class_list":["post-32729","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriels"],"rttpg_featured_image_url":{"full":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/sauvegarde2-2.png",718,527,false],"landscape":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/sauvegarde2-2.png",718,527,false],"portraits":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/sauvegarde2-2.png",718,527,false],"thumbnail":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/sauvegarde2-2-150x150.png",150,150,true],"medium":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/sauvegarde2-2-300x220.png",300,220,true],"large":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/sauvegarde2-2.png",640,470,false],"1536x1536":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/sauvegarde2-2.png",718,527,false],"2048x2048":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/sauvegarde2-2.png",718,527,false],"course_thumbnail":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/sauvegarde2-2-666x450.png",666,450,true],"woocommerce_thumbnail":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/sauvegarde2-2-300x300.png",300,300,true],"woocommerce_single":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/sauvegarde2-2-600x440.png",600,440,true],"woocommerce_gallery_thumbnail":["https:\/\/dev.indyli-services.com\/wp-content\/uploads\/2026\/05\/sauvegarde2-2-100x100.png",100,100,true]},"rttpg_author":{"display_name":"admin","author_link":"https:\/\/dev.indyli-services.com\/?author=1"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/dev.indyli-services.com\/?cat=87\" rel=\"category\">Tutoriels<\/a>","rttpg_excerpt":"INTRODUCTION PostgreSQL est un SGBD libre et gratuit, permettant de stocker vos donn\u00e9es. Il stocker les donn\u00e9es dans les tables et une table peut contenir plus de 2TO de donn\u00e9es. Ayant une grande capacit\u00e9 de stockage, PostgreSQL permet une garantie &hellip;","_links":{"self":[{"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=\/wp\/v2\/posts\/32729","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=32729"}],"version-history":[{"count":4,"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=\/wp\/v2\/posts\/32729\/revisions"}],"predecessor-version":[{"id":32768,"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=\/wp\/v2\/posts\/32729\/revisions\/32768"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=\/wp\/v2\/media\/32786"}],"wp:attachment":[{"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=32729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=32729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.indyli-services.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=32729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}