Migrate between Postgres databases
A CLI tool to migrate between PostgreSQL databases.
[!NOTE]
This project is in the Experimental Stage.
This project is in an experimental phase to set clear expectations for your usage. There could be known or unknown bugs, the API could evolve. While we cannot provide professional support for experimental projects, we’d be happy to hear from you if you see value in this project!
Usage
npx @neondatabase/migrate-pg --silent false --accept-all false --source="pg-string" --destination="pg-string"
Flags and Options
-
--source <source>
: The connection string for the source PostgreSQL database. This is a required option.
- Example:
--source "postgres://user:password@localhost:5432/source_db"
-
--destination <destination>
: The connection string for the destination PostgreSQL database. This is a required option.
- Example:
--destination "postgres://user:password@localhost:5432/destination_db"
-
--silent
: Suppresses console output if set to true
. The default value is false
.
-
--accept-all
: Automatically accepts all prompts if set to true
. The default value is false
.
- Example:
--accept-all true
When Migrating to Neon
- Make sure to enable autoscaling and increase your maximum Compute Unit size during the migration process so that the destination instance has enough CPU and RAM to support the migration.
- The following things can result in error during a migration process:
ALTER OWNER
commandsCREATE EVENT TRIGGER
commands- Anything that requires superuser that's not included in
neon_superuser
role
Authors
This library is created by Neon with contributions from:
Contributing
We love our contributors! Here's how you can contribute:
- Open an issue if you believe you've encountered a bug.
- Make a pull request to add new features/make quality-of-life improvements/fix bugs.
Contributors