Your Web News in One Place

Help Webnuz

Referal links:

Sign up for GreenGeeks web hosting
November 6, 2022 05:35 am GMT

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".


Original Link: https://dev.to/devkazuki/migrate-from-render-to-supabase-2en

Share this article:    Share on Facebook
View Full Article

Dev To

An online community for sharing and discovering great ideas, having debates, and making friends

More About this Source Visit Dev To