Postgres migration guides and scripts
We've created migration guides and open-source scripts to help you migrate your PostgreSQL databases to PlanetScale.
New Migration Documentation
Our new Postgres migration guides provide detailed instructions for three migration approaches:
- pg_dump & Restore - Simple approach for smaller databases
- Logical replication - Near-zero downtime migrations using logical replication
- Amazon DMS - Managed service for complex migrations with monitoring and data transformation
Each guide includes setup instructions, best practices, and troubleshooting tips.
Open-Source Migration Scripts
We've also released migration scripts on GitHub to automate common migration scenarios:
- Direct Postgres to PlanetScale - Using logical replication for zero-downtime migrations
- Heroku to PlanetScale - Special handling for Heroku's limitations using Bucardo replication
- DMS-based migrations - Scripts for AWS DMS migrations with intermediate MySQL support
The scripts handle connection management, sequence handling, and provide monitoring capabilities throughout the migration process.