Migrate from render to Supabase

Kazuki 🇯🇵 — Sun, 06 Nov 2022 05:35:14 +0000

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.

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
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
Change the Web Application's DB URI to that of Supabase
The URI of Supabase can be found in
"Project Settings" → "Database" → "Connection string".

DEV Community: Kazuki 🇯🇵