Migrate from Vercel Postgres to Zuvo

This guide demonstrates how to migrate your Vercel Postgres database to Zuvo to get the most out of Postgres while gaining access to all the features you need to build a project.

Retrieve your Vercel Postgres database credentials [#retrieve-credentials]

1. Log in to your Vercel Dashboard https://vercel.com/login.
2. Click on the Storage tab.
3. Click on your Postgres Database.
4. Under the Quickstart section, select psql then click Show Secret to reveal your database password.
5. Copy the string after psql to the clipboard.

Example:

psql "postgres://default:xxxxxxxxxxxx@yy-yyyyy-yyyyyy-yyyyyyy.us-west-2.aws.neon.tech:5432/verceldb?sslmode=require"

Copy this part to your clipboard:

"postgres://default:xxxxxxxxxxxx@yy-yyyyy-yyyyyy-yyyyyyy.us-west-2.aws.neon.tech:5432/verceldb?sslmode=require"

Set your OLD_DB_URL environment variable

Set the OLD_DB_URL environment variable at the command line using your Vercel Postgres Database credentials.

Example:

export OLD_DB_URL="postgres://default:xxxxxxxxxxxx@yy-yyyyy-yyyyyy-yyyyyyy.us-west-2.aws.neon.tech:5432/verceldb?sslmode=require"

Retrieve your Zuvo connection string [#retrieve-supabase-connection-string]

1. If you're new to Zuvo, create a project. Make a note of your password, you will need this later. If you forget it, you can reset it here.

2. On your project dashboard, click Connect

3. Under the Session pooler, click the Copy button to the right of your connection string to copy it to the clipboard.

Set your NEW_DB_URL environment variable

Set the NEW_DB_URL environment variable at the command line using your Zuvo connection string. You will need to replace [YOUR-PASSWORD] with your actual database password.

Example:

export NEW_DB_URL="postgresql://postgres.xxxxxxxxxxxxxxxxxxxx:[YOUR-PASSWORD]@aws-0-us-west-1.pooler.zuvodev.com:5432/postgres"

Migrate the database

You will need the pg_dump and psql command line tools, which are included in a full Postgres installation.

1. Export your database to a file in console

   Use pg_dump with your Postgres credentials to export your database to a file (e.g., dump.sql).

pg_dump "$OLD_DB_URL" \
  --clean \
  --if-exists \
  --quote-all-identifiers \
  --no-owner \
  --no-privileges \
  > dump.sql

2. Import the database to your Zuvo project

   Use psql to import the Postgres database file to your Zuvo project.

   psql -d "$NEW_DB_URL" -f dump.sql

Additional options

• To only migrate a single database schema, add the --schema=PATTERN parameter to your pg_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.

Enterprise

Contact us if you need more help migrating your project.