Neon offers Point-In-Time Restore (PITR) for serverless Postgres, enabling developers to recover data from any previous state using Time Travel queries. This is achieved through a storage system that separates storage and compute, utilizing Write-Ahead Logging (WAL). Neon’s architecture includes Safekeepers for data persistence, Pageservers for multi-tenant storage, and AWS S3 for durable storage. This setup eliminates the need for traditional backups and standbys, making Postgres a stateless compute instance that can quickly spin up in under 500ms. Neon’s implementation simplifies PITR, making it efficient, reliable, and user-friendly through ephemeral branches and Time Travel Assist.
Table of contents
Understanding the basics of Point In-Time Recovery in PostgresUnderstanding Neon’s architecturePageservers: under the hoodEphemeral branchesConclusionSort: