RE: barman 1.3.3 - barman list-backup ne montre pas tous les backup disponibles - Mailing list pgsql-sql

Bonjour Anthony

Voici le résultats des commandes :

barman check pfot_instance_localhost

Server pfot_instance_localhost:

        ssh: OK

        PostgreSQL: FAILED

        directories: OK

        retention policy settings: OK

        backup maximum age: OK (no last_backup_maximum_age provided)

        compression settings: OK

        minimum redundancy requirements: OK (have 38 backups, expected at least 1)

barman status pfot_instance_localhost

Server pfot_instance_localhost:

        Description: Instance pfot_instance sur localhost

        PostgreSQL version: FAILED trying to get PostgreSQL version

        Retention policies: enforced (mode: auto, retention: RECOVERY WINDOW OF 5 WEEKS, WAL retention: MAIN)

        No. of available backups: 38

        First available backup: 20180115T010031

        Last available backup: 20180219T115741

        Minimum redundancy requirements: satisfied (38/1)

barman list-backup pfot_instance_localhost

pfot_instance_localhost 20180219T115741 - Mon Feb 19 11:57:43 2018 - Size: 27.3 MiB - WAL Size: 196 B

pfot_instance_localhost 20180219T010043 - Mon Feb 19 01:00:46 2018 - Size: 27.3 MiB - WAL Size: 7.3 KiB

pfot_instance_localhost 20180218T010039 - Sun Feb 18 01:00:41 2018 - Size: 27.3 MiB - WAL Size: 15.2 KiB

pfot_instance_localhost 20180217T010115 - Sat Feb 17 01:01:26 2018 - Size: 27.3 MiB - WAL Size: 356 B

pfot_instance_localhost 20180216T010034 - Fri Feb 16 01:00:36 2018 - Size: 27.3 MiB - WAL Size: 17.3 KiB

pfot_instance_localhost 20180215T010039 - Thu Feb 15 01:00:43 2018 - Size: 27.3 MiB - WAL Size: 354 B

pfot_instance_localhost 20180214T010041 - Wed Feb 14 01:00:43 2018 - Size: 27.3 MiB - WAL Size: 9.7 KiB

pfot_instance_localhost 20180213T010043 - Tue Feb 13 01:00:55 2018 - Size: 27.3 MiB - WAL Size: 15.7 KiB

pfot_instance_localhost 20180212T142324 - Mon Feb 12 14:23:27 2018 - Size: 27.3 MiB - WAL Size: 5.6 GiB

pfot_instance_localhost 20180212T010049 - Mon Feb 12 01:00:52 2018 - Size: 27.3 MiB - WAL Size: 1.1 MiB

pfot_instance_localhost 20180211T010041 - Sun Feb 11 01:00:44 2018 - Size: 27.3 MiB - WAL Size: 11.1 KiB

pfot_instance_localhost 20180210T010111 - Sat Feb 10 01:01:21 2018 - Size: 27.3 MiB - WAL Size: 351 B

pfot_instance_localhost 20180209T010058 - Fri Feb  9 01:01:04 2018 - Size: 27.3 MiB - WAL Size: 18.5 KiB

pfot_instance_localhost 20180208T010041 - Thu Feb  8 01:00:44 2018 - Size: 27.3 MiB - WAL Size: 19.6 KiB

pfot_instance_localhost 20180207T010040 - Wed Feb  7 01:00:43 2018 - Size: 27.3 MiB - WAL Size: 35.6 KiB

pfot_instance_localhost 20180206T010056 - Tue Feb  6 01:01:02 2018 - Size: 27.3 MiB - WAL Size: 28.9 KiB

pfot_instance_localhost 20180205T010048 - Mon Feb  5 01:00:50 2018 - Size: 27.3 MiB - WAL Size: 23.4 KiB

pfot_instance_localhost 20180204T010043 - Sun Feb  4 01:00:46 2018 - Size: 27.3 MiB - WAL Size: 351 B

pfot_instance_localhost 20180203T010138 - Sat Feb  3 01:01:53 2018 - Size: 27.3 MiB - WAL Size: 352 B

pfot_instance_localhost 20180202T010038 - Fri Feb  2 01:00:41 2018 - Size: 27.3 MiB - WAL Size: 14.5 KiB

pfot_instance_localhost 20180201T010042 - Thu Feb  1 01:00:45 2018 - Size: 27.3 MiB - WAL Size: 22.8 KiB

pfot_instance_localhost 20180131T010045 - Wed Jan 31 01:00:49 2018 - Size: 27.3 MiB - WAL Size: 6.9 KiB

pfot_instance_localhost 20180130T010111 - Tue Jan 30 01:01:18 2018 - Size: 27.3 MiB - WAL Size: 1.9 MiB

pfot_instance_localhost 20180129T010036 - Mon Jan 29 01:00:38 2018 - Size: 27.3 MiB - WAL Size: 1.1 MiB

pfot_instance_localhost 20180128T010032 - Sun Jan 28 01:00:35 2018 - Size: 27.3 MiB - WAL Size: 11.1 KiB

pfot_instance_localhost 20180127T010036 - Sat Jan 27 01:00:38 2018 - Size: 27.3 MiB - WAL Size: 355 B

pfot_instance_localhost 20180126T010035 - Fri Jan 26 01:00:39 2018 - Size: 27.3 MiB - WAL Size: 18.6 KiB

pfot_instance_localhost 20180125T010010 - Thu Jan 25 01:00:13 2018 - Size: 27.3 MiB - WAL Size: 19.7 KiB

pfot_instance_localhost 20180124T010029 - Wed Jan 24 01:00:32 2018 - Size: 27.3 MiB - WAL Size: 36.0 KiB

pfot_instance_localhost 20180123T010030 - Tue Jan 23 01:00:33 2018 - Size: 27.3 MiB - WAL Size: 27.1 KiB

pfot_instance_localhost 20180122T010037 - Mon Jan 22 01:00:40 2018 - Size: 27.3 MiB - WAL Size: 23.4 KiB

pfot_instance_localhost 20180121T010028 - Sun Jan 21 01:00:30 2018 - Size: 27.3 MiB - WAL Size: 346 B

pfot_instance_localhost 20180120T010041 - Sat Jan 20 01:00:45 2018 - Size: 27.3 MiB - WAL Size: 354 B

pfot_instance_localhost 20180119T010012 - Fri Jan 19 01:00:17 2018 - Size: 27.3 MiB - WAL Size: 12.8 KiB

pfot_instance_localhost 20180118T010027 - Thu Jan 18 01:00:30 2018 - Size: 27.3 MiB - WAL Size: 22.8 KiB

pfot_instance_localhost 20180117T010029 - Wed Jan 17 01:00:33 2018 - Size: 27.3 MiB - WAL Size: 7.5 KiB

pfot_instance_localhost 20180116T010027 - Tue Jan 16 01:00:29 2018 - Size: 27.3 MiB - WAL Size: 1.9 MiB

pfot_instance_localhost 20180115T010031 - Mon Jan 15 01:00:34 2018 - Size: 27.3 MiB - WAL Size: 7.7 KiB

pfot_instance_localhost 20171214T010026 - FAILED

pfot_instance_localhost 20171213T010029 - FAILED

pfot_instance_localhost 20171212T010027 - FAILED

pfot_instance_localhost 20170531T115437 - STARTED

pfot_instance_localhost 20170531T115349 - STARTED

pfot_instance_localhost 20170531T115258 - STARTED

pfot_instance_localhost 20170531T114628 - STARTED

pfot_instance_localhost 20170531T112812 - STARTED

pfot_instance_localhost 20170525T010003 - STARTED

pfot_instance_localhost 20170522T174712 - STARTED

pfot_instance_localhost 20170520T010048 - FAILED

pfot_instance_localhost 20170415T010039 - FAILED

pfot_instance_localhost 20170414T010038 - FAILED

pfot_instance_localhost 20170413T010043 - FAILED

pfot_instance_localhost 20170412T010030 - FAILED

pfot_instance_localhost 20170411T010040 – FAILED

J’ai restauré des backup de 2017, et ils n’apparaissent pas .

Cordialement

De : anowocien@gmail.com [mailto:anowocien@gmail.com]
Envoyé : lundi 19 février 2018 17:17
À : ROS Didier <didier.ros@edf.fr>
Cc : pgsql-fr-generale@postgresql.org; pgsql-sql@postgresql.org
Objet : Re: barman 1.3.3 - barman list-backup ne montre pas tous les backup disponibles

Bonjour Didier,

Les commandes barman check all et barman status all te renvoient des résultats cohérents quant à la configuration de ton instance pfot? Si barman list-backup ne renvoie rien, c'est qu'il n'y a normalement pas de backup.
Comment ont été lancés les précédents backups? Ne vois-tu rien dans le syslog?

@+,

Anthony

On Monday, February 19, 2018, ROS Didier <didier.ros@edf.fr> wrote:
> Bonjour
>
>  
>
>               J’ai restauré d’anciennes sauvegardes barman sur un serveur linux mais quand je fais
>
>               barman list-backup pfot_instance_localhost
>
>               , elles n’apparaissent pas.
>
>                De plus, quand je restaure , j’ai un message disant que le backup n’existe pas .
>
>                Comment faire pour que barman prenne en compte les nouveaux backups ?
>
>  
>
>                Merci d’avance
>
>  
>
> Cordialement
>
>  
>
> </mail/u/0/s/?view=att&th=161aeb5ad1c40167&attid=0.1&disp=emb&zw&atsh=1>
>
> Didier ROS
> Expertise SGBD
> DS IT/IT DMA/Solutions Groupe EDF/Expertise Applicative - SGBD
> Nanterre Picasso - E2 565D (aile nord-est)
> 32 Avenue Pablo Picasso
> 92000 Nanterre
>
>  
>
>  
>
> Ce message et toutes les pièces jointes (ci-après le 'Message') sont établis à l'intention exclusive des destinataires et les informations qui y figurent sont strictement confidentielles. Toute utilisation de ce Message non conforme à sa destination, toute diffusion ou toute publication totale ou partielle, est interdite sauf autorisation expresse.
>
> Si vous n'êtes pas le destinataire de ce Message, il vous est interdit de le copier, de le faire suivre, de le divulguer ou d'en utiliser tout ou partie. Si vous avez reçu ce Message par erreur, merci de le supprimer de votre système, ainsi que toutes ses copies, et de n'en garder aucune trace sur quelque support que ce soit. Nous vous remercions également d'en avertir immédiatement l'expéditeur par retour du message.
>
> Il est impossible de garantir que les communications par messagerie électronique arrivent en temps utile, sont sécurisées ou dénuées de toute erreur ou virus.
> ____________________________________________________
>
> This message and any attachments (the 'Message') are intended solely for the addressees. The information contained in this Message is confidential. Any use of information contained in this Message not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval.
>
> If you are not the addressee, you may not copy, forward, disclose or use any part of it. If you have received this message in error, please delete it and all copies from your system and notify the sender immediately by return message.
>
> E-mail communication cannot be guaranteed to be timely secure, error or virus-free.