Migrate from Render to Supabase

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

So, I migrate from Render to Supabase.
Because the free plan of Supabase was enough.
Nothing was difficult, it was simple.

  1. Execute pg_dump in Radnor’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 DB URI of web application to Supabase
    The URI of Supabase can be found at
    “Project Settings” → “Database” → “Connection String”.

Leave a Comment