Backups
Neon does not yet provide support for configuring automated backups in the Neon Console or API. This feature is on our roadmap. You can expect it to be introduced in the coming months. In the meantime, we support the following backup options:
Built-in backups with Neon's point-in-time restore feature
Neon retains a history for all branches, allowing you to restore your data to a particular date and time or Log Sequence Number (LSN). The history retention period is configurable. The supported limits are 24 hours for Neon Free Tier users, 7 days for Launch plan users, and 30 days for Scale plan users. With this backup option, no action or automation is required. You can restore your data to a past state at any time by creating a database branch, which is a near-instant operation. This feature is referred to as Point-in-time restore.
For information about creating a point-in-time restore branch, see Branching — Point-in-time restore.
pg_dump
You can backup a database using pg_dump
, in the same way backups are created for a standalone Postgres instance.
important
Avoid using pg_dump
over a pooled Neon connection (see PgBouncer issues 452 & 976 for details). Use an unpooled connection instead.
This method dumps a single database in a single branch of your Neon project. If you need to create backups for multiple databases in multiple branches, you must perform a dump operation for each database in each branch separately.
To dump a database from your Neon project, please refer to the pg_dump
instructions in our Import from Postgres guide.
Automate Postgres Backups with a GitHub Action
This blog post from a Neon community member describes how to set up a nightly backup to an AWS S3 storage bucket using a GitHub Action: Nightly Postgres Backups via GitHub Actions.
Need help?
Join our Discord Server to ask questions or see what others are doing with Neon. Users on paid plans can open a support ticket from the console. For more detail, see Getting Support.
Last updated on