GitHub / postgrespro / ptrack
Block-level incremental backup engine for PostgreSQL
JSON API: http://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/postgrespro%2Fptrack
PURL: pkg:github/postgrespro/ptrack
Stars: 52
Forks: 16
Open issues: 8
License: other
Language: C
Size: 192 KB
Dependencies parsed at: Pending
Created at: almost 6 years ago
Updated at: about 2 months ago
Pushed at: about 1 year ago
Last synced at: about 1 month ago
Topics: backups, c, incremental-backups, postgres, postgresql, postgresql-extension
Release 2.2.0
2.2.0
Important Since version 2.2 we use a different algorithm for tracking changed pages. Thus, data recorded in the ptrack.map using pre 2.2 versions of ptrack is incompatible with newer versions. After extension upgrade and server restart old ptrack.map will be discarded with WARNING and initialized from the scratch.
ptracknow uses two slots to record page change information. It
helps significantly reduce number of false positives with the same
ptrack.map_size. See #5 for details. Many thanks to @funny-falcon for
ideas, theory and review!ptrack_get_pagemapset()now also displays a number of changed blocks
per file.- Added
ptrack_get_change_stat(start_lsn pg_lsn)that can desplay statistic
of changes (number of files, pages and size in MB) since specifiedstart_lsn.
Download
Release 2.1.2
2.1.2
- Fix int32 overflow when doing a
ptrackcheckpoint with
ptrack.map_size> 16 GB. - Adjust
ptrackcheckpoint buffer for a ~20% better performance.
Download
Release 2.1.1
2.1.1
- PostgreSQL 11 and 13 support. Thanks to @alubennikova.
- Fixed an int32 overflow issue, when one was unable to set
ptrack.map_size to 2 GB and above. New limit is 32 GB.
Download
Release 2.1.0
2.1.0
Both ptrack engine and public SQL API are now inside extension. Only
certain required hooks have been left as a PostgreSQL core patch.
Also many things have changed since 2.0.0:
- Fixed many compatibility bugs: alignment issues with atomics usage on Win32,
with atomics simulation via spinlocks. - Added versioning into the
ptrackmap. - Added automated standalone testing with
pg_probackupvia travis-ci in
different modes, including a ‘legacy’ mode, i.e. withEXEC_BACKEND
and--disable-atomics. - Removed
pg_ptrack_get_block.
Upgrading from 2.0.0:
- Put
shared_preload_libraries = 'ptrack'intopostgresql.conf. - Rename
ptrack_map_sizetoptrack.map_size. - Do
ALTER EXTENSION 'ptrack' UPDATE;. - Restart server.
Download
Release 2.0.0
2.0.0
Ptrack is a fast block-level incremental backup engine for PostgreSQL.
Currently ptrack codebase is split approximately 50%/50% between
PostgreSQL core patch and extension. All public SQL API methods are
placed in the ptrack extension, while the main engine is still in core.
Credits to:
- Konstantin Knizhnik
- Anastasia Lubennikova
- Alexey Kondratov
Download