Migrate from Heroku to Supabase
Migrate your Heroku Postgres database to Supabase.
Supabase is one of the best free alternatives to Heroku Postgres. This guide shows how to migrate your Heroku Postgres database to Supabase. This migration requires the pg_dump and psql CLI tools, which are installed automatically as part of the complete PostgreSQL installation package.
Alternatively, use the Heroku to Supabase migration tool to migrate in just a few clicks.
Quick demo
Retrieve your Heroku database credentials
- Log in to your Heroku account and select the project you want to migrate.
- Click Resources in the menu and select your Heroku Postgres database.
- Click Settings in the menu.
- Click View Credentials and save the following information:
- Host (
$HEROKU_HOST
) - Database (
$HEROKU_DATABASE
) - User (
$HEROKU_USER
) - Password (
$HEROKU_PASSWORD
)
- Host (
Retrieve your Supabase connection string
- If you're new to Supabase, create a project.
- Go to the Database settings for your project in the Supabase Dashboard.
- Under Connection string, make sure
Use connection pooling
is enabled. Copy the URI and replace the password placeholder with your database password.
Export your Heroku database to a file
Use pg_dump
with your Heroku credentials to export your Heroku database to a file (e.g., heroku_dump.sql
).
_10pg_dump --clean --if-exists --quote-all-identifiers \_10 -h $HEROKU_HOST -U $HEROKU_USER -d $HEROKU_DATABASE \_10 --no-owner --no-privileges > heroku_dump.sql
Import the database to your Supabase project
Use psql
to import the Heroku database file to your Supabase project.
_10psql -d "$YOUR_CONNECTION_STRING" -f heroku_dump.sql
Additional options
- To only migrate a single database schema, add the
--schema=PATTERN
parameter to yourpg_dump
command. - To exclude a schema:
--exclude-schema=PATTERN
. - To only migrate a single table:
--table=PATTERN
. - To exclude a table:
--exclude-table=PATTERN
.
Run pg_dump --help
for a full list of options.
-
If you're planning to migrate a database larger than 6 GB, we recommend upgrading to at least a Large compute add-on. This will ensure you have the necessary resources to handle the migration efficiently.
-
For databases smaller than 150 GB, you can increase the size of the disk on paid projects by navigating to Database Settings.
-
If you're dealing with a database larger than 150 GB, we strongly advise you to contact our support team for assistance in provisioning the required resources and ensuring a smooth migration process.
Enterprise
Contact us if you need more help migrating your project.