Neon•6mo ago

Transfer production database to development database

Hello,
I need to transfer all data from all tables in my production database to my development database for testing purposes.
How should I proceed? I tried using pg_dump, but I'm not sure if it's the right tool for this task.
Thank you

static-pink•6/25/25, 8:11 AM

If your development database is a branch of the production database, you can reset the branch to the parent https://neon.com/docs/guides/reset-from-parent

Neon

Reset from parent - Neon Docs

Neon's Reset from parent feature lets you instantly reset all databases on a branch to the latest schema and data from its parent branch, helping you recover from issues, start on new feature developm...

static-pink•6/25/25, 8:13 AM

If you're not currently using branches, I would recommend it! It would likely save you money too, as you won't be duplicating storage costs. See https://neon.com/docs/introduction/branching.

static-pink•6/25/25, 8:14 AM

Lastly, if your production database is not on Neon, we have a guide for that too:
https://neon.com/docs/guides/neon-twin-intro

Neon

Create a Neon Twin - Neon Docs

Read more about our dev/test use case here." isIntro> What is a Neon Twin? A Neon Twin is a full or partial clone of your production or staging database, providing developers and teams with isolated, ...

static-pink•6/25/25, 8:15 AM

If you have any more questions, happy to help

systematic-tanOP•6/25/25, 10:46 PM

Thanks Conrad !

Transfer production database to development database

Similar Threads

Similar Threads

Similar Threads