home.social

#barman — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #barman, aggregated by home.social.

fetched live
  1. For years my #Mastodon database backup strategy was nightly pg_dumps, which worked perfectly well until I started thinking about all the ways this could fail.

    Now #PostgreSQL is backed up properly with #Barman: base backups, WAL streaming, retention policies, and off-site storage over WireGuard.

    Honestly, Barman (pgbarman.org) is rather excellent. Self-hosting remains a second job, obviously, but at least now it has better paperwork.

    #mastoadmin #selfhosting

  2. For years my #Mastodon database backup strategy was nightly pg_dumps, which worked perfectly well until I started thinking about all the ways this could fail.

    Now #PostgreSQL is backed up properly with #Barman: base backups, WAL streaming, retention policies, and off-site storage over WireGuard.

    Honestly, Barman (pgbarman.org) is rather excellent. Self-hosting remains a second job, obviously, but at least now it has better paperwork.

    #mastoadmin #selfhosting

  3. For years my #Mastodon database backup strategy was nightly pg_dumps, which worked perfectly well until I started thinking about all the ways this could fail.

    Now #PostgreSQL is backed up properly with #Barman: base backups, WAL streaming, retention policies, and off-site storage over WireGuard.

    Honestly, Barman (pgbarman.org) is rather excellent. Self-hosting remains a second job, obviously, but at least now it has better paperwork.

    #mastoadmin #selfhosting

  4. For years my #Mastodon database backup strategy was nightly pg_dumps, which worked perfectly well until I started thinking about all the ways this could fail.

    Now #PostgreSQL is backed up properly with #Barman: base backups, WAL streaming, retention policies, and off-site storage over WireGuard.

    Honestly, Barman (pgbarman.org) is rather excellent. Self-hosting remains a second job, obviously, but at least now it has better paperwork.

    #mastoadmin #selfhosting

  5. For years my #Mastodon database backup strategy was nightly pg_dumps, which worked perfectly well until I started thinking about all the ways this could fail.

    Now #PostgreSQL is backed up properly with #Barman: base backups, WAL streaming, retention policies, and off-site storage over WireGuard.

    Honestly, Barman (pgbarman.org) is rather excellent. Self-hosting remains a second job, obviously, but at least now it has better paperwork.

    #mastoadmin #selfhosting

  6. In case you were looking for a step-by-step guide for setting up a #CloudNativePG replica cluster using the #Barman Cloud Plugin for backups and WAL archiving... look no further: enterprisedb.com/blog/deployme #PostgreSQL #Kubernetes #CNPG

  7. In case you were looking for a step-by-step guide for setting up a #CloudNativePG replica cluster using the #Barman Cloud Plugin for backups and WAL archiving... look no further: enterprisedb.com/blog/deployme #PostgreSQL #Kubernetes #CNPG

  8. In case you were looking for a step-by-step guide for setting up a #CloudNativePG replica cluster using the #Barman Cloud Plugin for backups and WAL archiving... look no further: enterprisedb.com/blog/deployme #PostgreSQL #Kubernetes #CNPG

  9. In case you were looking for a step-by-step guide for setting up a #CloudNativePG replica cluster using the #Barman Cloud Plugin for backups and WAL archiving... look no further: enterprisedb.com/blog/deployme #PostgreSQL #Kubernetes #CNPG

  10. Druhý ročník barmanské soutěže Artisans of Taste vyhrál toto pondělí v pražském baru Forbína barman Grandhotelu Pupp Tomáš Gec s koktejlem Values for a Bright Future. Za měsíc tak vyrazí do brazilského Ria de Janeiro reprezentovat českou barovou scénu a zabojovat o další úspěch s barmany z dalších evropských zemí.

    Tón: : mírně pozitivní
    #česko #gdelt #barman...

    novinky.cz/clanek/gastro-barma

  11. Druhý ročník barmanské soutěže Artisans of Taste vyhrál toto pondělí v pražském baru Forbína barman Grandhotelu Pupp Tomáš Gec s koktejlem Values for a Bright Future. Za měsíc tak vyrazí do brazilského Ria de Janeiro reprezentovat českou barovou scénu a zabojovat o další úspěch s barmany z dalších evropských zemí.

    Tón: : mírně pozitivní
    #česko #gdelt #barman...

    novinky.cz/clanek/gastro-barma

  12. 𝗕𝗮𝗿𝗺𝗮𝗻 𝗙𝗶𝗿𝘀𝘁 𝗗𝗮𝘁𝗲𝘀 𝘃𝗶𝗻𝗱𝘁 𝗵𝗲𝘁 '𝘀𝗻𝗲𝘂 𝗲𝗻 𝘁𝗿𝗶𝗲𝘀𝘁' 𝗱𝗮𝘁 𝗽𝗿𝗼𝗴𝗿𝗮𝗺𝗺𝗮 𝘀𝘁𝗼𝗽𝘁

    Jeremy Zijlstra, de barman van het BNNVARA-programma First Dates, vindt het "sneu en triest" dat het programma stopt. In een gesprek met het ANP zegt hij het "pittig" te vinden dat het programma stopt.

    rtl.nl/boulevard/artikel/55407

    #Barman #FirstDates #Programma

  13. 𝗕𝗮𝗿𝗺𝗮𝗻 𝗙𝗶𝗿𝘀𝘁 𝗗𝗮𝘁𝗲𝘀 𝘃𝗶𝗻𝗱𝘁 𝗵𝗲𝘁 '𝘀𝗻𝗲𝘂 𝗲𝗻 𝘁𝗿𝗶𝗲𝘀𝘁' 𝗱𝗮𝘁 𝗽𝗿𝗼𝗴𝗿𝗮𝗺𝗺𝗮 𝘀𝘁𝗼𝗽𝘁

    Jeremy Zijlstra, de barman van het BNNVARA-programma First Dates, vindt het "sneu en triest" dat het programma stopt. In een gesprek met het ANP zegt hij het "pittig" te vinden dat het programma stopt.

    rtl.nl/boulevard/artikel/55407

    #Barman #FirstDates #Programma

  14. 𝗕𝗮𝗿𝗺𝗮𝗻 𝗙𝗶𝗿𝘀𝘁 𝗗𝗮𝘁𝗲𝘀 𝘃𝗶𝗻𝗱𝘁 𝗵𝗲𝘁 '𝘀𝗻𝗲𝘂 𝗲𝗻 𝘁𝗿𝗶𝗲𝘀𝘁' 𝗱𝗮𝘁 𝗽𝗿𝗼𝗴𝗿𝗮𝗺𝗺𝗮 𝘀𝘁𝗼𝗽𝘁

    Jeremy Zijlstra, de barman van het BNNVARA-programma First Dates, vindt het "sneu en triest" dat het programma stopt. In een gesprek met het ANP zegt hij het "pittig" te vinden dat het programma stopt.

    rtl.nl/boulevard/artikel/55407

    #Barman #FirstDates #Programma

  15. 𝗕𝗮𝗿𝗺𝗮𝗻 𝗙𝗶𝗿𝘀𝘁 𝗗𝗮𝘁𝗲𝘀 𝘃𝗶𝗻𝗱𝘁 𝗵𝗲𝘁 '𝘀𝗻𝗲𝘂 𝗲𝗻 𝘁𝗿𝗶𝗲𝘀𝘁' 𝗱𝗮𝘁 𝗽𝗿𝗼𝗴𝗿𝗮𝗺𝗺𝗮 𝘀𝘁𝗼𝗽𝘁

    Jeremy Zijlstra, de barman van het BNNVARA-programma First Dates, vindt het "sneu en triest" dat het programma stopt. In een gesprek met het ANP zegt hij het "pittig" te vinden dat het programma stopt.

    rtl.nl/boulevard/artikel/55407

    #Barman #FirstDates #Programma

  16. 𝗕𝗮𝗿𝗺𝗮𝗻 𝗙𝗶𝗿𝘀𝘁 𝗗𝗮𝘁𝗲𝘀 𝘃𝗶𝗻𝗱𝘁 𝗵𝗲𝘁 '𝘀𝗻𝗲𝘂 𝗲𝗻 𝘁𝗿𝗶𝗲𝘀𝘁' 𝗱𝗮𝘁 𝗽𝗿𝗼𝗴𝗿𝗮𝗺𝗺𝗮 𝘀𝘁𝗼𝗽𝘁

    Jeremy Zijlstra, de barman van het BNNVARA-programma First Dates, vindt het "sneu en triest" dat het programma stopt. In een gesprek met het ANP zegt hij het "pittig" te vinden dat het programma stopt.

    rtl.nl/boulevard/artikel/55407

    #Barman #FirstDates #Programma

  17. Tomorrow at #PGConfEU: Martín Marqués and Giulio Calacoci walk through how the Barman project grew with the Postgres community and where backup innovation is headed next.

    They’ll also share how anyone can get involved, from contributing code to testing and documentation. Don’t miss their talk on Wednesday, Oct 22 at 14:45 (Room Alfa).
    #PostgreSQL #EDBPostgresAI #Barman #Backup #OpenSource #PostgresCommunity

  18. Tomorrow at #PGConfEU: Martín Marqués and Giulio Calacoci walk through how the Barman project grew with the Postgres community and where backup innovation is headed next.

    They’ll also share how anyone can get involved, from contributing code to testing and documentation. Don’t miss their talk on Wednesday, Oct 22 at 14:45 (Room Alfa).
    #PostgreSQL #EDBPostgresAI #Barman #Backup #OpenSource #PostgresCommunity

  19. Tomorrow at #PGConfEU: Martín Marqués and Giulio Calacoci walk through how the Barman project grew with the Postgres community and where backup innovation is headed next.

    They’ll also share how anyone can get involved, from contributing code to testing and documentation. Don’t miss their talk on Wednesday, Oct 22 at 14:45 (Room Alfa).
    #PostgreSQL #EDBPostgresAI #Barman #Backup #OpenSource #PostgresCommunity

  20. 𝗙𝗶𝗿𝘀𝘁 𝗱𝗮𝘁𝗲𝘀 𝗸𝗶𝗲𝘀𝘁 𝗼𝗽𝘃𝗼𝗹𝗴𝗲𝗿 𝗯𝗮𝗿𝗺𝗮𝗻 𝗩𝗶𝗰𝘁𝗼𝗿 𝗔𝗯𝗲𝗹𝗻 𝗶𝗻 𝗻𝗶𝗲𝘂𝘄𝗲 𝗿𝗲𝗲𝗸𝘀

    Het nieuwe seizoen van het datingprogramma First Dates gaat op 15 september van start. Dat heeft BNNVARA woensdag laten weten. De eerste week zal er aandacht zijn voor de opvolger van barman Victor Abeln. Elke aflevering neemt een andere barman of barvrouw plaats in het restaurant van First...

    rtl.nl/boulevard/artikel/55264

    #FirstDates #opvolger #barman

  21. 𝗙𝗶𝗿𝘀𝘁 𝗱𝗮𝘁𝗲𝘀 𝗸𝗶𝗲𝘀𝘁 𝗼𝗽𝘃𝗼𝗹𝗴𝗲𝗿 𝗯𝗮𝗿𝗺𝗮𝗻 𝗩𝗶𝗰𝘁𝗼𝗿 𝗔𝗯𝗲𝗹𝗻 𝗶𝗻 𝗻𝗶𝗲𝘂𝘄𝗲 𝗿𝗲𝗲𝗸𝘀

    Het nieuwe seizoen van het datingprogramma First Dates gaat op 15 september van start. Dat heeft BNNVARA woensdag laten weten. De eerste week zal er aandacht zijn voor de opvolger van barman Victor Abeln. Elke aflevering neemt een andere barman of barvrouw plaats in het restaurant van First...

    rtl.nl/boulevard/artikel/55264

    #FirstDates #opvolger #barman

  22. 𝗙𝗶𝗿𝘀𝘁 𝗱𝗮𝘁𝗲𝘀 𝗸𝗶𝗲𝘀𝘁 𝗼𝗽𝘃𝗼𝗹𝗴𝗲𝗿 𝗯𝗮𝗿𝗺𝗮𝗻 𝗩𝗶𝗰𝘁𝗼𝗿 𝗔𝗯𝗲𝗹𝗻 𝗶𝗻 𝗻𝗶𝗲𝘂𝘄𝗲 𝗿𝗲𝗲𝗸𝘀

    Het nieuwe seizoen van het datingprogramma First Dates gaat op 15 september van start. Dat heeft BNNVARA woensdag laten weten. De eerste week zal er aandacht zijn voor de opvolger van barman Victor Abeln. Elke aflevering neemt een andere barman of barvrouw plaats in het restaurant van First...

    rtl.nl/boulevard/artikel/55264

    #FirstDates #opvolger #barman

  23. 𝗙𝗶𝗿𝘀𝘁 𝗱𝗮𝘁𝗲𝘀 𝗸𝗶𝗲𝘀𝘁 𝗼𝗽𝘃𝗼𝗹𝗴𝗲𝗿 𝗯𝗮𝗿𝗺𝗮𝗻 𝗩𝗶𝗰𝘁𝗼𝗿 𝗔𝗯𝗲𝗹𝗻 𝗶𝗻 𝗻𝗶𝗲𝘂𝘄𝗲 𝗿𝗲𝗲𝗸𝘀

    Het nieuwe seizoen van het datingprogramma First Dates gaat op 15 september van start. Dat heeft BNNVARA woensdag laten weten. De eerste week zal er aandacht zijn voor de opvolger van barman Victor Abeln. Elke aflevering neemt een andere barman of barvrouw plaats in het restaurant van First...

    rtl.nl/boulevard/artikel/55264

    #FirstDates #opvolger #barman

  24. 𝗙𝗶𝗿𝘀𝘁 𝗱𝗮𝘁𝗲𝘀 𝗸𝗶𝗲𝘀𝘁 𝗼𝗽𝘃𝗼𝗹𝗴𝗲𝗿 𝗯𝗮𝗿𝗺𝗮𝗻 𝗩𝗶𝗰𝘁𝗼𝗿 𝗔𝗯𝗲𝗹𝗻 𝗶𝗻 𝗻𝗶𝗲𝘂𝘄𝗲 𝗿𝗲𝗲𝗸𝘀

    Het nieuwe seizoen van het datingprogramma First Dates gaat op 15 september van start. Dat heeft BNNVARA woensdag laten weten. De eerste week zal er aandacht zijn voor de opvolger van barman Victor Abeln. Elke aflevering neemt een andere barman of barvrouw plaats in het restaurant van First...

    rtl.nl/boulevard/artikel/55264

    #FirstDates #opvolger #barman

  25. CW: Unarmada for Gaza: Long bars, extreme content

    so tell your #barman to hold your #lager
    or better yet #BringHerWith if she’d rather
    scran your #ramen or your #carbonara
    get your #passport, your #mask and your #balaclava
    get all your #mates from your #AlmaMater
    all the #neighbours from #fête and #gala
    your #SoccerSquad and your #SparringPartners
    #tinkers, #tailors, #gig #serfs and #farmers
    #mandem, #ultras, #HRDepartments
    #joiners, #plumbers and #carny #barkers
    slip the yoke and behalve the harness
    tell #MisterTallyMan, “fuck #bananas
    before they go the whole #enchilada
    the #SocialContract ’s knackered: #embalmer
    when the king’s this bare-arse starkers
    reckon it’s time for a #reginata?
    that’s what they call an #intifada
    that’s what we call #satyagraha
    not for the sake of #virtue or #karma
    from #Omelas to disembark us
    #PointOfOrder ; the point of departure’s
    #kindness will always be smarter than harshness

    5/7

    #Bars
    #Poetry
    #Lyrics
    #Songs
    #writing
    #rhymescheme
    #geopol
    #MiddleEast
    #IsraeliWarCrimes
    #FreedomFlotilla
    #Sumud
    #ConvoyOfSteadfastness
    #FreePalestine
    #Madleen
    #AntiFascist
    #Genocide
    #UKpol
    #Labour
    #RuleOfLaw
    #Atrocity
    #Imperalism
    #Collapse
    #Ethics
    #Society
    #Praxis
    #CallToAction
    #WorldOrder
    #SocialMovements
    #Surveillance #State #SurveillanceState

  26. CW: Unarmada for Gaza: Long bars, extreme content

    so tell your #barman to hold your #lager
    or better yet #BringHerWith if she’d rather
    scran your #ramen or your #carbonara
    get your #passport, your #mask and your #balaclava
    get all your #mates from your #AlmaMater
    all the #neighbours from #fête and #gala
    your #SoccerSquad and your #SparringPartners
    #tinkers, #tailors, #gig #serfs and #farmers
    #mandem, #ultras, #HRDepartments
    #joiners, #plumbers and #carny #barkers
    slip the yoke and behalve the harness
    tell #MisterTallyMan, “fuck #bananas
    before they go the whole #enchilada
    the #SocialContract ’s knackered: #embalmer
    when the king’s this bare-arse starkers
    reckon it’s time for a #reginata?
    that’s what they call an #intifada
    that’s what we call #satyagraha
    not for the sake of #virtue or #karma
    from #Omelas to disembark us
    #PointOfOrder ; the point of departure’s
    #kindness will always be smarter than harshness

    5/7

    #Bars
    #Poetry
    #Lyrics
    #Songs
    #writing
    #rhymescheme
    #geopol
    #MiddleEast
    #IsraeliWarCrimes
    #FreedomFlotilla
    #Sumud
    #ConvoyOfSteadfastness
    #FreePalestine
    #Madleen
    #AntiFascist
    #Genocide
    #UKpol
    #Labour
    #RuleOfLaw
    #Atrocity
    #Imperalism
    #Collapse
    #Ethics
    #Society
    #Praxis
    #CallToAction
    #WorldOrder
    #SocialMovements
    #Surveillance #State #SurveillanceState

  27. CW: Unarmada for Gaza: Long bars, extreme content

    so tell your to hold your
    or better yet if she’d rather
    scran your or your
    get your , your and your
    get all your from your
    all the from and
    your and your
    , , and
    , ,
    , and
    slip the yoke and behalve the harness
    tell , “fuck
    before they go the whole
    the ’s knackered:
    when the king’s this bare-arse starkers
    reckon it’s time for a ?
    that’s what they call an
    that’s what we call
    not for the sake of or
    from to disembark us
    ; the point of departure’s
    will always be smarter than harshness

    5/7





























  28. CW: Unarmada for Gaza: Long bars, extreme content

    so tell your #barman to hold your #lager
    or better yet #BringHerWith if she’d rather
    scran your #ramen or your #carbonara
    get your #passport, your #mask and your #balaclava
    get all your #mates from your #AlmaMater
    all the #neighbours from #fête and #gala
    your #SoccerSquad and your #SparringPartners
    #tinkers, #tailors, #gig #serfs and #farmers
    #mandem, #ultras, #HRDepartments
    #joiners, #plumbers and #carny #barkers
    slip the yoke and behalve the harness
    tell #MisterTallyMan, “fuck #bananas
    before they go the whole #enchilada
    the #SocialContract ’s knackered: #embalmer
    when the king’s this bare-arse starkers
    reckon it’s time for a #reginata?
    that’s what they call an #intifada
    that’s what we call #satyagraha
    not for the sake of #virtue or #karma
    from #Omelas to disembark us
    #PointOfOrder ; the point of departure’s
    #kindness will always be smarter than harshness

    5/7

    #Bars
    #Poetry
    #Lyrics
    #Songs
    #writing
    #rhymescheme
    #geopol
    #MiddleEast
    #IsraeliWarCrimes
    #FreedomFlotilla
    #Sumud
    #ConvoyOfSteadfastness
    #FreePalestine
    #Madleen
    #AntiFascist
    #Genocide
    #UKpol
    #Labour
    #RuleOfLaw
    #Atrocity
    #Imperalism
    #Collapse
    #Ethics
    #Society
    #Praxis
    #CallToAction
    #WorldOrder
    #SocialMovements
    #Surveillance #State #SurveillanceState

  29. CW: Unarmada for Gaza: Long bars, extreme content

    so tell your #barman to hold your #lager
    or better yet #BringHerWith if she’d rather
    scran your #ramen or your #carbonara
    get your #passport, your #mask and your #balaclava
    get all your #mates from your #AlmaMater
    all the #neighbours from #fête and #gala
    your #SoccerSquad and your #SparringPartners
    #tinkers, #tailors, #gig #serfs and #farmers
    #mandem, #ultras, #HRDepartments
    #joiners, #plumbers and #carny #barkers
    slip the yoke and behalve the harness
    tell #MisterTallyMan, “fuck #bananas
    before they go the whole #enchilada
    the #SocialContract ’s knackered: #embalmer
    when the king’s this bare-arse starkers
    reckon it’s time for a #reginata?
    that’s what they call an #intifada
    that’s what we call #satyagraha
    not for the sake of #virtue or #karma
    from #Omelas to disembark us
    #PointOfOrder ; the point of departure’s
    #kindness will always be smarter than harshness

    5/7

    #Bars
    #Poetry
    #Lyrics
    #Songs
    #writing
    #rhymescheme
    #geopol
    #MiddleEast
    #IsraeliWarCrimes
    #FreedomFlotilla
    #Sumud
    #ConvoyOfSteadfastness
    #FreePalestine
    #Madleen
    #AntiFascist
    #Genocide
    #UKpol
    #Labour
    #RuleOfLaw
    #Atrocity
    #Imperalism
    #Collapse
    #Ethics
    #Society
    #Praxis
    #CallToAction
    #WorldOrder
    #SocialMovements
    #Surveillance #State #SurveillanceState

  30. Barman woes on OVH

    So, due to a cascade of Barman’s errors and corrupted backups due to running out of backup space, I had to pretty much clear out my Barman backup storage.

    After resetting everything, however, I was not able to make a full backup, because Barman was not able to receive write-ahead logs from PostgreSQL.

    2025-06-04 22:00:21,209 [523687] barman.cli ERROR: [Errno 5] Input/output error: '/backup/barman/pg/wals/00000001000000CD/00000001000000CD00000009.tmp'
    See log file for more details.
    Traceback (most recent call last):
    File "/usr/lib/python3/dist-packages/barman/cli.py", line 2390, in main
    args.func(args)
    File "/usr/lib/python3/dist-packages/barman/cli.py", line 1600, in archive_wal
    server.archive_wal()
    File "/usr/lib/python3/dist-packages/barman/server.py", line 2651, in archive_wal
    self.backup_manager.archive_wal(verbose)
    File "/usr/lib/python3/dist-packages/barman/backup.py", line 847, in archive_wal
    archiver.archive(verbose)
    File "/usr/lib/python3/dist-packages/barman/wal_archiver.py", line 213, in archive
    self.archive_wal(compressor, wal_info)
    File "/usr/lib/python3/dist-packages/barman/wal_archiver.py", line 356, in archive_wal
    shutil.copystat(src_file, tmp_file)
    File "/usr/lib/python3.12/shutil.py", line 388, in copystat
    _copyxattr(src, dst, follow_symlinks=follow)
    File "/usr/lib/python3.12/shutil.py", line 338, in _copyxattr
    os.setxattr(dst, name, value, follow_symlinks=follow_symlinks)
    OSError: [Errno 5] Input/output error: '/backup/barman/pg/wals/00000001000000CD/00000001000000CD00000009.tmp'

    Input/output error? That’s odd, but the stacktrace tells us a lot, as from the function name (os.setxattr), we can deduce that it’s trying to set xattrs on our WAL files. The underlying storage for my backups is OVH’s Backup Storage, accessible over NFS. And NFS, for most of its life, was not able to support xattrs even if the underlying filesystem does. The support has been added to NFS 4.2, while OVH (still) uses 4.1.

    So, how to fix this?

    Initially, I thought of downgrading Barman, because things had worked before. But that did not help, and so I had to go digging into the source code (which was painful as I am not a Python guy).

    # Perform the real filesystem operation with the xlogdb lock taken.            # This makes the operation atomic from the xlogdb file POV            with self.server.xlogdb("a") as fxlogdb:                # If the content has changed, it means the file was either compressed                # or encrypted or both. In this case, we need to update its metadata                if content_changed:                    shutil.copystat(src_file, current_file)                    stat = os.stat(current_file)                    wal_info.size = stat.st_size

    So, if content_changed is true, we use copystat from shutil.py, which copies xattrs from the original file.

    # If the bits of the file has changed e.g. due to compression or encryption            content_changed = False            # Compress the file if not already compressed            if compressor and not wal_info.compression:                compressor.compress(src_file, tmp_file)                files_to_remove.append(current_file)                current_file = tmp_file                content_changed = True                wal_info.compression = compressor.compression            # Encrypt the file            if encryption:                encrypted_file = encryption.encrypt(current_file, dst_dir)                files_to_remove.append(current_file)                current_file = encrypted_file                wal_info.encryption = encryption.NAME                content_changed = True

    Ah, so therein lies the rub: Barman assumes that it needs to do this if the content is either being compressed or encrypted. And it just so happens that I’ve also enabled GZIP compression so as not to run out of space again. Well, we have to deal with this the old-fashioned way (by lowering the retention policy). After disabling compression, Barman was able to make backups again.

    Hope this helps someone, because it sure as fuck would’ve helped me.

    #Barman #lighthearted #NFS #NFSv4 #OVH #pgsql #PostgreSQL #SelfHosting

  31. Barman woes on OVH

    So, due to a cascade of Barman’s errors and corrupted backups due to running out of backup space, I had to pretty much clear out my Barman backup storage.

    After resetting everything, however, I was not able to make a full backup, because Barman was not able to receive write-ahead logs from PostgreSQL.

    2025-06-04 22:00:21,209 [523687] barman.cli ERROR: [Errno 5] Input/output error: '/backup/barman/pg/wals/00000001000000CD/00000001000000CD00000009.tmp'
    See log file for more details.
    Traceback (most recent call last):
    File "/usr/lib/python3/dist-packages/barman/cli.py", line 2390, in main
    args.func(args)
    File "/usr/lib/python3/dist-packages/barman/cli.py", line 1600, in archive_wal
    server.archive_wal()
    File "/usr/lib/python3/dist-packages/barman/server.py", line 2651, in archive_wal
    self.backup_manager.archive_wal(verbose)
    File "/usr/lib/python3/dist-packages/barman/backup.py", line 847, in archive_wal
    archiver.archive(verbose)
    File "/usr/lib/python3/dist-packages/barman/wal_archiver.py", line 213, in archive
    self.archive_wal(compressor, wal_info)
    File "/usr/lib/python3/dist-packages/barman/wal_archiver.py", line 356, in archive_wal
    shutil.copystat(src_file, tmp_file)
    File "/usr/lib/python3.12/shutil.py", line 388, in copystat
    _copyxattr(src, dst, follow_symlinks=follow)
    File "/usr/lib/python3.12/shutil.py", line 338, in _copyxattr
    os.setxattr(dst, name, value, follow_symlinks=follow_symlinks)
    OSError: [Errno 5] Input/output error: '/backup/barman/pg/wals/00000001000000CD/00000001000000CD00000009.tmp'

    Input/output error? That’s odd, but the stacktrace tells us a lot, as from the function name (os.setxattr), we can deduce that it’s trying to set xattrs on our WAL files. The underlying storage for my backups is OVH’s Backup Storage, accessible over NFS. And NFS, for most of its life, was not able to support xattrs even if the underlying filesystem does. The support has been added to NFS 4.2, while OVH (still) uses 4.1.

    So, how to fix this?

    Initially, I thought of downgrading Barman, because things had worked before. But that did not help, and so I had to go digging into the source code (which was painful as I am not a Python guy).

    # Perform the real filesystem operation with the xlogdb lock taken.            # This makes the operation atomic from the xlogdb file POV            with self.server.xlogdb("a") as fxlogdb:                # If the content has changed, it means the file was either compressed                # or encrypted or both. In this case, we need to update its metadata                if content_changed:                    shutil.copystat(src_file, current_file)                    stat = os.stat(current_file)                    wal_info.size = stat.st_size

    So, if content_changed is true, we use copystat from shutil.py, which copies xattrs from the original file.

    # If the bits of the file has changed e.g. due to compression or encryption            content_changed = False            # Compress the file if not already compressed            if compressor and not wal_info.compression:                compressor.compress(src_file, tmp_file)                files_to_remove.append(current_file)                current_file = tmp_file                content_changed = True                wal_info.compression = compressor.compression            # Encrypt the file            if encryption:                encrypted_file = encryption.encrypt(current_file, dst_dir)                files_to_remove.append(current_file)                current_file = encrypted_file                wal_info.encryption = encryption.NAME                content_changed = True

    Ah, so therein lies the rub: Barman assumes that it needs to do this if the content is either being compressed or encrypted. And it just so happens that I’ve also enabled GZIP compression so as not to run out of space again. Well, we have to deal with this the old-fashioned way (by lowering the retention policy). After disabling compression, Barman was able to make backups again.

    Hope this helps someone, because it sure as fuck would’ve helped me.

    #Barman #lighthearted #NFS #NFSv4 #OVH #pgsql #PostgreSQL #SelfHosting

  32. Barman woes on OVH

    So, due to a cascade of Barman’s errors and corrupted backups due to running out of backup space, I had to pretty much clear out my Barman backup storage.

    After resetting everything, however, I was not able to make a full backup, because Barman was not able to receive write-ahead logs from PostgreSQL.

    2025-06-04 22:00:21,209 [523687] barman.cli ERROR: [Errno 5] Input/output error: '/backup/barman/pg/wals/00000001000000CD/00000001000000CD00000009.tmp'
    See log file for more details.
    Traceback (most recent call last):
    File "/usr/lib/python3/dist-packages/barman/cli.py", line 2390, in main
    args.func(args)
    File "/usr/lib/python3/dist-packages/barman/cli.py", line 1600, in archive_wal
    server.archive_wal()
    File "/usr/lib/python3/dist-packages/barman/server.py", line 2651, in archive_wal
    self.backup_manager.archive_wal(verbose)
    File "/usr/lib/python3/dist-packages/barman/backup.py", line 847, in archive_wal
    archiver.archive(verbose)
    File "/usr/lib/python3/dist-packages/barman/wal_archiver.py", line 213, in archive
    self.archive_wal(compressor, wal_info)
    File "/usr/lib/python3/dist-packages/barman/wal_archiver.py", line 356, in archive_wal
    shutil.copystat(src_file, tmp_file)
    File "/usr/lib/python3.12/shutil.py", line 388, in copystat
    _copyxattr(src, dst, follow_symlinks=follow)
    File "/usr/lib/python3.12/shutil.py", line 338, in _copyxattr
    os.setxattr(dst, name, value, follow_symlinks=follow_symlinks)
    OSError: [Errno 5] Input/output error: '/backup/barman/pg/wals/00000001000000CD/00000001000000CD00000009.tmp'

    Input/output error? That’s odd, but the stacktrace tells us a lot, as from the function name (os.setxattr), we can deduce that it’s trying to set xattrs on our WAL files. The underlying storage for my backups is OVH’s Backup Storage, accessible over NFS. And NFS, for most of its life, was not able to support xattrs even if the underlying filesystem does. The support has been added to NFS 4.2, while OVH (still) uses 4.1.

    So, how to fix this?

    Initially, I thought of downgrading Barman, because things had worked before. But that did not help, and so I had to go digging into the source code (which was painful as I am not a Python guy).

    # Perform the real filesystem operation with the xlogdb lock taken.            # This makes the operation atomic from the xlogdb file POV            with self.server.xlogdb("a") as fxlogdb:                # If the content has changed, it means the file was either compressed                # or encrypted or both. In this case, we need to update its metadata                if content_changed:                    shutil.copystat(src_file, current_file)                    stat = os.stat(current_file)                    wal_info.size = stat.st_size

    So, if content_changed is true, we use copystat from shutil.py, which copies xattrs from the original file.

    # If the bits of the file has changed e.g. due to compression or encryption            content_changed = False            # Compress the file if not already compressed            if compressor and not wal_info.compression:                compressor.compress(src_file, tmp_file)                files_to_remove.append(current_file)                current_file = tmp_file                content_changed = True                wal_info.compression = compressor.compression            # Encrypt the file            if encryption:                encrypted_file = encryption.encrypt(current_file, dst_dir)                files_to_remove.append(current_file)                current_file = encrypted_file                wal_info.encryption = encryption.NAME                content_changed = True

    Ah, so therein lies the rub: Barman assumes that it needs to do this if the content is either being compressed or encrypted. And it just so happens that I’ve also enabled GZIP compression so as not to run out of space again. Well, we have to deal with this the old-fashioned way (by lowering the retention policy). After disabling compression, Barman was able to make backups again.

    Hope this helps someone, because it sure as fuck would’ve helped me.

    #Barman #lighthearted #NFS #NFSv4 #OVH #pgsql #PostgreSQL #SelfHosting

  33. Tommy dreams, #barman à Montpellier, accueille le jeune #gay Even Canaillou. Au moment de la fermeture de ce #bar gay, ces deux beaux mecs vont vivre des moments chauds et érotiques dans cette vidéo gay très hot. A lire ici --> wp.me/pbyKZP-16op #evencanaillou #beauxmecs #beaucul #beauxgosses #gorgeprofonde #males #lieuxpublics #GrosseBite