Content Deep Dive
Using Neon branching for instant Point in time recovery
Blog post from Neon
Post Details
Company
Date Published
Author
Mahmoud Abdelwahab
Word Count
842
Language
English
Hacker News Points
-
Source URL
Summary
Neon is a fully managed serverless Postgres service that allows users to create isolated copies of their database, referred to as "branches", using a process called "branching". This feature enables users to programmatically restore their data to a previous state by creating a branch from a specific point in time. Neon retains a data history in the form of Write-Ahead-Log (WAL) records, allowing for restoration to a previous point in time within a configurable seven-day window. Users can create branches using the Neon CLI or console, and restore them to a previous state while keeping the same compute endpoint by assigning it to the newly created branch and setting it as the primary branch.