DEV Community

Kazuki πŸ‡―πŸ‡΅
Kazuki πŸ‡―πŸ‡΅

Posted on

Migrate from render to Supabase

I used PostgreSQL from render.com and I paid $7 per month for Starter plan.
This DB was for own project.
There was no revenue and It was in the red.

So, I migrate from render to Supabase.
Because Supabase's free plan was sufficient.
Nothing was difficult, it was simple.

  1. Execute pg_dump in redner's DB
    Execute the following code on the command line
    pg_dump --clean --if-exists --quote-all-identifiers \
    -h $RENDER_HOST -U $RENDER_USER -d $RENDER_DATABASE \
    --no-owner --no-privileges > render_dump.sql

  2. Import dump files into Supabase's DB
    Execute the following code on the command line
    psql -h $SUPABASE_HOST -U postgres -f redner_dump.sql

  3. Change the Web Application's DB URI to that of Supabase
    The URI of Supabase can be found in
    "Project Settings" β†’ "Database" β†’ "Connection string".

Top comments (0)