pgBackRest
120 posts

pgBackRest
@pgBackRest
Reliable PostgreSQL backup and restore solution that will seamlessly scale up to the largest databases and workloads.
Katılım Mart 2018
19 Takip Edilen1K Takipçiler

UPDATE: pgBackRest is likely to receive enough funding be be revived. See github.com/pgbackrest/pgb… for details.
English

TL;DR: pgBackRest is no longer being maintained. For details see github.com/pgbackrest/pgb…
English

Thank you @dataegret for your sponsorship of pgBackRest! Please consider a sponsorship if you use pgBackRest in your enterprise. github.com/sponsors/dwste…
English

A special thank you to @pgstef for sponsoring pgBackRest! Stefan has also been a contributor for many years. Please consider a sponsorship if you use pgBackRest in your enterprise. github.com/sponsors/dwste…
English

Many thanks to @supabase for their sponsorship! Please consider a sponsorship if you use pgBackRest in your enterprise. github.com/sponsors/dwste…
English

@zemanekj @samokhvalov In our benchmarks TLS is generally about 50% faster than SSH. But I don't think that would hold here since the bottleneck is most likely elsewhere. Still, every little bit helps!
English

@samokhvalov Would be great to see TLS transfer method numbers. I guess it will perform better than SSH. But I admit that it will be more complex to set up.
English

#PostgresMarathon 2-012: Ultra-fast replica creation with pgBackRest postgres.ai/blog/20251105-…
Couldn't believe the numbers: 35 TiB/h copying PGDATA from one EC2 instance to another.
That's fast enough to clone a 10 TiB production database in ~17 minutes.
Modern hardware + pgBackRest trick = game changer for zero-downtime operations at scale
Credit: Maxim Boguk, Postgres expert I've known for years, who now helps the @postgres_ai team excel with really large systems
[Chart showing throughput progression from 3.9 TiB/hour to 35+ TiB/hour when involving more processes]

English

pgBackRest 2.57.0 released with an option to suppress repository symlinks and bug fixes: #2.57.0" target="_blank" rel="nofollow noopener">pgbackrest.org/release.html#2…. Please consider a sponsorship if you use pgBackRest in your enterprise: github.com/sponsors/dwste….
English

pgBackRest 2.56.0 released with progress info improvements and bug fixes: #2.56.0" target="_blank" rel="nofollow noopener">pgbackrest.org/release.html#2…. Please consider a sponsorship if you use pgBackRest in your enterprise: github.com/sponsors/dwste….
English

@Cesar_DBA pgBackRest will warn you about corrupted pages if you have page checksums enabled in PostgreSQL and of course we have robust checksums to detect corruption at rest in the repository.
English

@pgBackRest when will we have recovery of corrupted pages or blocks? Will this feature be added someday? 🙃
English

@Cesar_DBA If you mean automatically fixing corrupted pages then this is not something we are planning to add to pgBackRest. Recovering from corruption is a complex process that depends greatly on the individual situation.
English