# Neon Twin: Automate Partial Data Dumps with Postgres and GitHub Actions

DevFeed: [Neon Twin: Automate Partial Data Dumps with Postgres and GitHub Actions](<https://devfeed.tech/articles/neon-twin-automate-partial-data-dumps-with-postgres-and-github-actions-5001.md>)

Original publisher: [Read original article](<https://neon.com/blog/automate-partial-data-dumps-with-postgresql-and-github-actions>)

Author: Paul Scanlon

Published: 2025-02-10T16:31:46Z

Content type: tutorial

Language: en

Sources: [Blog -- Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [GitHub Actions](<https://devfeed.tech/topics/github-actions.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Serverless](<https://devfeed.tech/topics/serverless.md>), [Ubuntu](<https://devfeed.tech/topics/ubuntu.md>), [apt](<https://devfeed.tech/topics/apt.md>), [.env](<https://devfeed.tech/topics/dotenv.md>)

Tags: [apt](<https://devfeed.tech/tags/apt.md>), [databases](<https://devfeed.tech/tags/databases.md>), [environment-variables](<https://devfeed.tech/tags/environment-variables.md>), [github-actions](<https://devfeed.tech/tags/github-actions.md>), [pipeline](<https://devfeed.tech/tags/pipeline.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [product](<https://devfeed.tech/tags/product.md>), [testing](<https://devfeed.tech/tags/testing.md>), [ubuntu](<https://devfeed.tech/tags/ubuntu.md>), [workflow](<https://devfeed.tech/tags/workflow.md>)

## AI overview

This tutorial explains how to create a Neon Twin by scheduling a GitHub Actions workflow that performs a partial data dump of a production or staging PostgreSQL database and restores it to a Neon Serverless Postgres instance. It covers the workflow schedule, manual triggering, environment variables, repository secrets, and installing PostgreSQL on an Ubuntu runner with Apt.

## Source excerpt

Your production database is tried and tested and likely bulletproof. Merely mentioning migrating to a new provider would likely set off multiple alarms, so don't, use a Neon Twin instead. In this post, I'll show you how to create a partial copy of your production database so you...