#pgbackrest — Public Fediverse posts

@milo @Anoxinon @Muto Das ist Doku Arbeit bei uns, die es nicht Ersichtlich gemacht hat. @Muto hatte absolut richtig, für #Postgres mit #PgBackRest ein extra Backup eingerichtet und Dokumentiert.
Ich hatte bei den Restore Arbeiten, das aber nicht im Wissen und wusste von #PBS und #Borg via #BorgMatic und habe da alles durchsucht. Den Unterpunkt in der Postgres Doku zu dem System habe ich schlicht nicht gesehen und war da im Stress blind für.

@milo @Anoxinon @Muto Das ist Doku Arbeit bei uns, die es nicht Ersichtlich gemacht hat. @Muto hatte absolut richtig, für #Postgres mit #PgBackRest ein extra Backup eingerichtet und Dokumentiert.
Ich hatte bei den Restore Arbeiten, das aber nicht im Wissen und wusste von #PBS und #Borg via #BorgMatic und habe da alles durchsucht. Den Unterpunkt in der Postgres Doku zu dem System habe ich schlicht nicht gesehen und war da im Stress blind für.

We have switched to using https://pgBackRest.org for backups of our primary database 🗄️, covering both #PostgreSQL base backups and WAL archives. This has allowed us to optimise the weekly planetfile-generation pipeline 🌍, these weekly exports will now be published earlier in the week. A big thank you to the #pgBackRest team for a great product! 🙌

We have switched to using https://pgBackRest.org for backups of our primary database 🗄️, covering both #PostgreSQL base backups and WAL archives. This has allowed us to optimise the weekly planetfile-generation pipeline 🌍, these weekly exports will now be published earlier in the week. A big thank you to the #pgBackRest team for a great product! 🙌

RELEASE : voici un nouvel outil basé sur #pgBackRest, pour sauvegarder les instances #PostgreSQL déployés avec #CloudNativePG !

Deux de ses développeurs vous en parlent => https://blog.dalibo.com/2026/06/25/plugin-pgbackrest.html

🇬🇧 => *Here is the announcement of our experimental CloudNativePG plugin to backup PostgreSQL instances with pgBackRest!*

#SGBD #CNPG #DBA
#kubernetes
#opensource

#pgBackRest : Dalibo fait désormais partie de ses sponsors => https://blog.dalibo.com/2026/06/25/pgbackrest_communautaire.html

Après le coup d'arrêt du projet annoncé par son mainteneur en avril dernier, des membres de la communauté #PostgreSQL se sont mobilisés rapidement. 🐘 🐘 🐘

Notre SCOP est très fière de les avoir rejoints, consciente de son devoir de contribution.

#sgbd #opensource #logicielsLibres

#pgBackRest : Dalibo fait désormais partie de ses sponsors => https://blog.dalibo.com/2026/06/25/pgbackrest_communautaire.html

Après le coup d'arrêt du projet annoncé par son mainteneur en avril dernier, des membres de la communauté #PostgreSQL se sont mobilisés rapidement. 🐘 🐘 🐘

Notre SCOP est très fière de les avoir rejoints, consciente de son devoir de contribution.

#sgbd #opensource #logicielsLibres

PostgreSQL Point-in-Time Recovery with pgBackRest and S3-compatible storage: WAL archiving, full/diff backups, and restoring to any moment. Works with AWS S3, MinIO, R2, B2.
https://mysticmind.dev/postgresql-point-in-time-recovery-with-pgbackrest-and-s3-compatible-storage/
#PostgreSQL #pgBackRest #Postgres

PostgreSQL Point-in-Time Recovery with pgBackRest and S3-compatible storage: WAL archiving, full/diff backups, and restoring to any moment. Works with AWS S3, MinIO, R2, B2.
https://mysticmind.dev/postgresql-point-in-time-recovery-with-pgbackrest-and-s3-compatible-storage/
#PostgreSQL #pgBackRest #Postgres

Sunny start here in Vancouver ☀️

If you’re at @pgconfdev today, join us for the #pgBackRest Community Office Hours!

🕐 Today (Wed), 1:00–2:30 PM

Come by the Community Booth to ask questions, exchange ideas, and discuss the future of the project.

Happy to be joined by Feike Steenbergen ( @feike ), a long-time pgBackRest power user, to share operational experiences from his work at @tigerdatabase, one of the new sponsors of the project!

#PGConfdev #PostgreSQL #pgBackRest

Sunny start here in Vancouver ☀️

If you’re at @pgconfdev today, join us for the #pgBackRest Community Office Hours!

🕐 Today (Wed), 1:00–2:30 PM

Come by the Community Booth to ask questions, exchange ideas, and discuss the future of the project.

Happy to be joined by Feike Steenbergen ( @feike ), a long-time pgBackRest power user, to share operational experiences from his work at @tigerdatabase, one of the new sponsors of the project!

#PGConfdev #PostgreSQL #pgBackRest

#PostgreSQL et #pgBackRest : la bonne nouvelle du jour : https://lwn.net/Articles/1073470/

#PostgreSQL et #pgBackRest : la bonne nouvelle du jour : https://lwn.net/Articles/1073470/

Geld für KI statt #OpenSource: #pgBackRest-Projekt gibt auf | Developer https://www.heise.de/news/Geld-fuer-KI-statt-Open-Source-pgBackRest-Projekt-gibt-auf-11277730.html

Geld für KI statt #OpenSource: #pgBackRest-Projekt gibt auf | Developer https://www.heise.de/news/Geld-fuer-KI-statt-Open-Source-pgBackRest-Projekt-gibt-auf-11277730.html

🔥 pgBackRest chiude: Snowflake acquisisce Crunchy Data, taglia i fondi e il creatore David Steele non trova sponsor. Addio al miglior tool di backup per PostgreSQL.
https://gomoot.com/pgbackrest-lo-strumento-di-backup-piu-completo-per-postgresql-non-sara-piu-mantenuto/

#news #pgBackRest #PostgreSQL

🔥 pgBackRest chiude: Snowflake acquisisce Crunchy Data, taglia i fondi e il creatore David Steele non trova sponsor. Addio al miglior tool di backup per PostgreSQL.
https://gomoot.com/pgbackrest-lo-strumento-di-backup-piu-completo-per-postgresql-non-sara-piu-mantenuto/

#news #pgBackRest #PostgreSQL

David Steele announced that he stopped working on #pgBackRest, citing a challenge many maintainers struggle with: making a living, and investing time in a project that is used by many. Gabriele Bartolini shared his perspective on his blog:

"When corporate sponsorship disappears and community sponsorship cannot fill the gap, maintainers face an impossible choice: do it poorly, or stop. David chose the latter. He is not the first, and he will not be the last."

https://www.gabrielebartolini.it/articles/2026/04/why-the-cycle-of-open-source-sustainability-needs-to-be-virtuous/ #PostgreSQL

David Steele announced that he stopped working on #pgBackRest, citing a challenge many maintainers struggle with: making a living, and investing time in a project that is used by many. Gabriele Bartolini shared his perspective on his blog:

"When corporate sponsorship disappears and community sponsorship cannot fill the gap, maintainers face an impossible choice: do it poorly, or stop. David chose the latter. He is not the first, and he will not be the last."

https://www.gabrielebartolini.it/articles/2026/04/why-the-cycle-of-open-source-sustainability-needs-to-be-virtuous/ #PostgreSQL

Notice of Obsolescence #pgbackrest #postgres https://thebuild.com/blog/2026/04/27/notice-of-obsolescence/

Notice of Obsolescence #pgbackrest #postgres https://thebuild.com/blog/2026/04/27/notice-of-obsolescence/

Pgbackrest is no longer being maintained

https://github.com/pgbackrest/pgbackrest

#HackerNews #Pgbackrest #Maintenance #Ended #OpenSource #Community #PostgreSQL #Backup #Tools

Pgbackrest is no longer being maintained

https://github.com/pgbackrest/pgbackrest

#HackerNews #Pgbackrest #Maintenance #Ended #OpenSource #Community #PostgreSQL #Backup #Tools

Certbot doesn't define CN by default which is required by pgBackRest and OpenVPN as of today. I tried to use a CSR but Certbot doesn't automatically renew those certificates making certbot pointless. I'm now using acme.sh and it just works https://github.com/acmesh-official/acme.sh

#acme #acmesh #certbot #tls #ssl #openvpn #pgbackrest

Certbot doesn't define CN by default which is required by pgBackRest and OpenVPN as of today. I tried to use a CSR but Certbot doesn't automatically renew those certificates making certbot pointless. I'm now using acme.sh and it just works https://github.com/acmesh-official/acme.sh

#acme #acmesh #certbot #tls #ssl #openvpn #pgbackrest

I'm trying to learn how to parse SANs in C thanks to the source code of curl https://github.com/curl/curl/blob/935e1f9963a12ac1a880df538b23b824d2fea7bb/lib/vtls/openssl.c#L2073

Why? I would like pgBackRest to parse SANs before CN because CNs are deprecated for years and they are optional.

The problem is that no matter how hard I try to learn and write C, I fail.

I tried to implement Proxy Protocol for PGbouncer and PostgreSQL, failed.

I could open an issue, wait for a fix and cross my fingers or pray the gods, but I don't want to overload the project. My issue is not that important. What's important to me is the personal reward of contributing to open source. I want to learn. I want to contribute. I want to be a little part of the movement.

You should ask Claude they say. It will be fun they say. I'm not ready for that. I don't want to bypass everything for one of my side projects. But in the meantime, I'm frustated of failing. This is very tempting I must admit.

#opensource #curl #pgbackrest #pgbouncer #postgresql #ai

I'm trying to learn how to parse SANs in C thanks to the source code of curl https://github.com/curl/curl/blob/935e1f9963a12ac1a880df538b23b824d2fea7bb/lib/vtls/openssl.c#L2073

Why? I would like pgBackRest to parse SANs before CN because CNs are deprecated for years and they are optional.

The problem is that no matter how hard I try to learn and write C, I fail.

I tried to implement Proxy Protocol for PGbouncer and PostgreSQL, failed.

I could open an issue, wait for a fix and cross my fingers or pray the gods, but I don't want to overload the project. My issue is not that important. What's important to me is the personal reward of contributing to open source. I want to learn. I want to contribute. I want to be a little part of the movement.

You should ask Claude they say. It will be fun they say. I'm not ready for that. I don't want to bypass everything for one of my side projects. But in the meantime, I'm frustated of failing. This is very tempting I must admit.

#opensource #curl #pgbackrest #pgbouncer #postgresql #ai

Как построить отказоустойчивый PostgreSQL-кластер и не промахнуться

В исходниках PostgreSQL встречаются ироничные комментарии, а самый веселый, на мой взгляд, находится в строке прямо перед запуском сервера. Судя по логам Git, это комментарий Тома Лейна, который сообщает: "We are ready to rock and roll", а следующей строкой идёт запуск сервера СУБД. Действительно, когда пытаешься запустить кластер PostgreSQL, порой не покидает ощущение "rock and roll", а потом вдруг кластер не стартует или внезапно переключается на другой узел из-за отступов в YAML-конфиге :). В этой статье разберём ключевые элементы отказоустойчивого кластера и типовые места, где чаще всего допускают ошибки.

https://habr.com/ru/companies/postgrespro/articles/1004040/

#postgresql #dba #кластер #датацентр #pgBackRest #wal #PgBouncer #мониторинг #Patroni #Stolon

[Перевод] Как ускорить создание реплики PostgreSQL: pgBackRest вместо pg_basebackup

Создать реплику PostgreSQL на базе в 1 TiB — задача, где быстро выясняется, что NVMe и сеть в 75 Гбит/с сами по себе ничего не гарантируют: упираешься в инструмент, который копирует данные в один поток. В статье разбираемся, как обойти этот потолок с помощью pgBackRest и параллельной передачи, какие настройки реально влияют на скорость, где легко потерять порядок величины на «мелочи» вроде хранилища под spool, и почему в PostgreSQL 18 внезапно стало лучше — но недостаточно. Открыть статью

https://habr.com/ru/companies/otus/articles/1006120/

#postgresql #создание_реплики #pgBackRest #резервное_копирование #производительность_копирования #SSH #пропускная_способность_сети #NVMe

Let's Encrypt has stopped to provide certificates that can be used for authentication https://letsencrypt.org/2025/05/14/ending-tls-client-authentication

I used them for pgBackRest which suddenly stopped working very recently.

Let's use a private CA then.

#letsencrypt #pgbackrest #tls

Let's Encrypt has stopped to provide certificates that can be used for authentication https://letsencrypt.org/2025/05/14/ending-tls-client-authentication

I used them for pgBackRest which suddenly stopped working very recently.

Let's use a private CA then.

#letsencrypt #pgbackrest #tls

Don't miss the #PostgreSQL #Backups & #Replication course by @dataegret :postgresql:

Five live online sessions designed to take your PostgreSQL backup and replication knowledge to the next level.

You will spend some quality time with me. Do not worry, I am friendly and only slightly emotional about backups 🔥🧯🤣

Big secret (#sarcasm): the first part of the training will, of course, focus on #pgBackRest 🫢

👉 https://dataegret.com/courses-postgresql-backups-replication-dba3

#Postgres #DBA #HighAvailability #OpenSource

Don't miss the #PostgreSQL #Backups & #Replication course by @dataegret :postgresql:

Five live online sessions designed to take your PostgreSQL backup and replication knowledge to the next level.

You will spend some quality time with me. Do not worry, I am friendly and only slightly emotional about backups 🔥🧯🤣

Big secret (#sarcasm): the first part of the training will, of course, focus on #pgBackRest 🫢

👉 https://dataegret.com/courses-postgresql-backups-replication-dba3

#Postgres #DBA #HighAvailability #OpenSource

If you did attend my talk about improving #PostgreSQL backup and restore capabilities with #pgBackRest at #FOSDEMPGDay, first of all: thank you for being there 🙏

The slides are available already 😎 https://pgstef.github.io/talks/en/20260130_FOSDEM-PGDay_pgBackRest-magic.pdf

If you did attend my talk about improving #PostgreSQL backup and restore capabilities with #pgBackRest at #FOSDEMPGDay, first of all: thank you for being there 🙏

The slides are available already 😎 https://pgstef.github.io/talks/en/20260130_FOSDEM-PGDay_pgBackRest-magic.pdf

RE: https://mastodon.social/@fosdempgday/115933923088950301

#pgBackRest is one of those tools that keeps surprising me, even after years of working with #PostgreSQL 🐘 Solid, flexible, and once you really get it, it completely changes how confident you feel about backups 🔒

If you’re around next week, come join us in #Brussels for #FOSDEMPGDay 🇧🇪

And if you can’t make it, pgBackRest is part of our next training level at @dataegret, where we share the patterns, gotchas, and real-world lessons we’ve learned along the way 👀
https://dataegret.com/courses-postgresql-backups-replication-dba3/

RE: https://mastodon.social/@fosdempgday/115933923088950301

#pgBackRest is one of those tools that keeps surprising me, even after years of working with #PostgreSQL 🐘 Solid, flexible, and once you really get it, it completely changes how confident you feel about backups 🔒

If you’re around next week, come join us in #Brussels for #FOSDEMPGDay 🇧🇪

And if you can’t make it, pgBackRest is part of our next training level at @dataegret, where we share the patterns, gotchas, and real-world lessons we’ve learned along the way 👀
https://dataegret.com/courses-postgresql-backups-replication-dba3/

📣 Le programme de la prochaine #PGSession est disponible !
Une journée entière dédiée à #PostgreSQL et sa communauté :postgresql:

De mon côté, challenge : vous parler de #Patroni et #pgBackRest en 30 minutes 😅 Il y aurait matière à en discuter des heures, mais on va à l’essentiel, promis !

📍 Organisé par @dalibo à Paris, le 14 janvier

👉 Programme : https://blog.dalibo.com/2025/12/17/pgsession18_programme.html

Bonus : en vous inscrivant, vous soutenez une asso qui promeut du logiciel libre (#PostgreSQLFr, #April, #Framasoft)

📣 Le programme de la prochaine #PGSession est disponible !
Une journée entière dédiée à #PostgreSQL et sa communauté :postgresql:

De mon côté, challenge : vous parler de #Patroni et #pgBackRest en 30 minutes 😅 Il y aurait matière à en discuter des heures, mais on va à l’essentiel, promis !

📍 Organisé par @dalibo à Paris, le 14 janvier

👉 Programme : https://blog.dalibo.com/2025/12/17/pgsession18_programme.html

Bonus : en vous inscrivant, vous soutenez une asso qui promeut du logiciel libre (#PostgreSQLFr, #April, #Framasoft)

🔔 New blog post on a #pgBackRest feature preview: simplifying manual expiration of oldest backups.

🔎 The new expire --oldest option makes it much easier to expire the oldest eligible full backup without adjusting retention settings. This addresses a long-standing usability gap when disk space is tight and removes the need for temporary retention changes or scripting.

👉 Full example and details: https://pgstef.github.io/2025/12/17/pgbackrest_preview_expire_oldest.html

#PostgreSQL #Backups #LowDiskSpace

🔔 New blog post on a #pgBackRest feature preview: simplifying manual expiration of oldest backups.

🔎 The new expire --oldest option makes it much easier to expire the oldest eligible full backup without adjusting retention settings. This addresses a long-standing usability gap when disk space is tight and removes the need for temporary retention changes or scripting.

👉 Full example and details: https://pgstef.github.io/2025/12/17/pgbackrest_preview_expire_oldest.html

#PostgreSQL #Backups #LowDiskSpace

🎉 Our @dataegret DBA1 PostgreSQL course kicked off today.
A warm welcome and good luck to all participants.

Want to strengthen your #PostgreSQL and #DBA skills? Have a look at our training catalog, especially if you want to learn how to use #pgBackRest efficiently! 🐘💪

If you are ready to deepen your expertise,
👉 DBA2 (Advanced) and DBA3 (High Availability and Replication) are now open for registration.

🔗 https://dataegret.com/postgresql-courses/

🎉 Our @dataegret DBA1 PostgreSQL course kicked off today.
A warm welcome and good luck to all participants.

Want to strengthen your #PostgreSQL and #DBA skills? Have a look at our training catalog, especially if you want to learn how to use #pgBackRest efficiently! 🐘💪

If you are ready to deepen your expertise,
👉 DBA2 (Advanced) and DBA3 (High Availability and Replication) are now open for registration.

🔗 https://dataegret.com/postgresql-courses/

📢 New blog post alert!
pgBackRest TLS server mode for a primary-standby setup with a repository host 🚀
I refreshed an older write-up after a chat with @devrimgunduz ✨

🔐 TLS server mode (no SSH)
:postgresql: Primary-standby #PostgreSQL
🐧 Step-by-step on AlmaLinux 10

👉 https://pgstef.github.io/2025/11/17/pgbackrest_tls_server_mode_primary_standby_repository.html

Thanks Devrim for the nudge 🍻
And @dataegret for supporting my #pgBackRest work 🙏

🤔 Now I'm wondering if I should submit a talk proposal about it for #FOSDEM databases developer room 🤣

📢 New blog post alert!
pgBackRest TLS server mode for a primary-standby setup with a repository host 🚀
I refreshed an older write-up after a chat with @devrimgunduz ✨

🔐 TLS server mode (no SSH)
:postgresql: Primary-standby #PostgreSQL
🐧 Step-by-step on AlmaLinux 10

👉 https://pgstef.github.io/2025/11/17/pgbackrest_tls_server_mode_primary_standby_repository.html

Thanks Devrim for the nudge 🍻
And @dataegret for supporting my #pgBackRest work 🙏

🤔 Now I'm wondering if I should submit a talk proposal about it for #FOSDEM databases developer room 🤣

Резервирование кластера Greengage DB. Часть 2

Подход к резервированию кластера Greengage , рассмотренный в предыдущей статье , был нацелен ознакомить читателей с некоторой базой знаний, необходимой для понимания того, как можно формировать резервные копии и в дальнейшем восстанавливаться из них. Также был рассмотрен вариант утилиты, которая реализует данный подход на практике. Однако все предыдущие рассуждения предполагали "идеальные условия", то есть не учитывали возможные сбои или влияние сторонних процессов. Теперь же мы готовы перейти к следующему этапу, а именно рассмотреть ряд сценариев, которые встречаются на практике и которые надо учитывать при резервировании кластера Greengage.

https://habr.com/ru/companies/greengage/articles/965490/

#greengage #резервное_копирование #postgres #pgbackrest #распределенные_системы

:postgresql: After premiering "Patroni and pgBackRest: better together" at the PostgreSQL Belgium meetup, I'm excited to bring it next week to @pgconfeu in Riga! 🇱🇻

Learn how to integrate pgBackRest into a Patroni-managed cluster, rebuild standby nodes from backups, and perform PITR under Patroni's control — with real-world examples and YAML snippets.

🔗 https://www.postgresql.eu/events/pgconfeu2025/schedule/session/6961-patroni-and-pgbackrest-better-together/

See you in Riga for an amazing week of #PostgreSQL talks and community! 💙

#PGConfEU #Patroni #pgBackRest #OpenSource

:postgresql: After premiering "Patroni and pgBackRest: better together" at the PostgreSQL Belgium meetup, I'm excited to bring it next week to @pgconfeu in Riga! 🇱🇻

Learn how to integrate pgBackRest into a Patroni-managed cluster, rebuild standby nodes from backups, and perform PITR under Patroni's control — with real-world examples and YAML snippets.

🔗 https://www.postgresql.eu/events/pgconfeu2025/schedule/session/6961-patroni-and-pgbackrest-better-together/

See you in Riga for an amazing week of #PostgreSQL talks and community! 💙

#PGConfEU #Patroni #pgBackRest #OpenSource

📢 The next #PostgreSQL #Belgium #Meetup is on Tue, Oct 14, 2025 at Google's Brussels offices 🚀

Come and discover how PostgreSQL is used on Google Cloud, with insights into scalability, data sovereignty, and innovation. I'll also be sharing how to efficiently combine #Patroni and #pgBackRest for high availability and disaster recovery.

Community, food, drinks... and a chance to win a Lego elephant in Belgian colors 🖤💛❤️

🔗 Details & RSVP: https://www.meetup.com/postgresbe/events/310950580

Zfsbackrest: Pgbackrest style encrypted backups for ZFS filesystems

https://github.com/gargakshit/zfsbackrest

#HackerNews #Zfsbackrest #Pgbackrest #Encrypted #Backups #ZFS #Filesystems #Data #Security

💙 Everyone knows I'm a huge fan of #pgBackRest, and I really enjoy speaking about it.

Next week I'm hosting a live session on one of its most underrated features: using multiple repositories for extra reliability. We'll also explore how async archiving makes it even more powerful.

📅 Join me next Wednesday, April 23, at 13:00 CEST for a deep dive into what makes pgBackRest such a flexible and robust tool.

Register now 👉 https://events.zoom.us/ev/AizlI-fSlus9GeUW42ajspY1T5fZTDtiaaEcX2RgCv5gNGK6_yLZ~Aqqb-f88OwUylo4kXLh5gILRJPJb3IWF2PZ4OaUXyy5Dm8fLjhy418FiCw

:postgresql: #PostgreSQL

pgBackRest seems to check the exact version between servers:

```
WARN: unable to check pg1: [ProtocolError] expected value '2.54.2' for greeting key 'version' but got '2.54.1'
```

I thought the minor version would have been enough.

It's time to upgrade a package on Arch Linux 😭

#pgbackrest