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
5 Replies
statutory-emerald•3mo ago
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...
statutory-emerald•3mo ago
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.
statutory-emerald•3mo ago
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, ...
statutory-emerald•3mo ago
If you have any more questions, happy to help
dependent-tanOP•3mo ago
Thanks Conrad !