this post was submitted on 05 Apr 2024
19 points (100.0% liked)

PostgreSQL

677 readers
1 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 2 years ago
MODERATORS
top 1 comments
sorted by: hot top controversial new old
[–] [email protected] 1 points 8 months ago

This is the best summary I could come up with:


Merged yesterday to the Git code for the PostgreSQL database server is support for facilitating incremental backups.

Robert Haas a few months ago restarted work to implement incremental backup support for PostgreSQL, years after he originally pursued the feature to no avail at that time.

But this time around things panned out and merged to PostgreSQL is support for producing incremental backups.

Haas explained in his proposal from June: The basic design of this patch set is pretty simple, and there are three main parts.

Naturally, we don't find out about blocks that were modified without any write-ahead log record, e.g. hint bit updates, but those are of necessity not critical for correctness, so it's OK. Second, pg_basebackup has a mode where it can take an incremental backup.

The PostgreSQL 17 database server stable debut is tentatively planned for next September so it will be interesting to see what other exciting changes make it for this next version.


The original article contains 524 words, the summary contains 158 words. Saved 70%. I'm a bot and I'm open source!