"back in time" branches
can i go to a specific datetime snpashot of my neon db?
for example i want to go to exactly 1 month ago to that state and lets say create a branch with that EXACT state.
is it possible?
Is a creation of such branch takes a lot of resources and time?
or should i have created a branch at 1 month ago for it to work?
also how does it work? is it some postgresql extension and if yes is it open source?
1 Reply
like-gold•7mo ago
You can create a branch to a specific point in time using our restore feature:
https://neon.tech/docs/guides/branch-restore#how-to-use-branch-restore
How far back you can restore depends on your history retention setting. It's 24 hours by default.
https://neon.tech/docs/introduction/point-in-time-restore#history-retention
Retaining history takes up storage. For example, 30 days of history uses up a lot more storage than 1 day of history.
Neon's history retention is built on retained WAL (Write-Ahead Log records).
Neon
Branch reset and restore - Neon Docs
Neon retains a history of changes for all branches. This shared history provides the basis for a variety of branch restore and reset operations resetting a branch to its parent, restoring a branch to ...
Neon
Branch Restore - Neon Docs
With Neon's branch restore capability, you can easily restore a branch to an earlier state in its own or another branch's history. You can use Time Travel Assist to connect to a specific point in your...