We want to move our postgres from Supabase to Render. (The fourth of four parts of our stack to make the move! We already have what used to run on three different cloud platforms running on Render.)
We’re working on getting data from Supabase to render, with minimal downtime. (I was already able to move over the schema with no fuss.)
Make the render database a read replica of supabase. Then once it’s fully replicated, promote it and switch over.
Schedule downtime with our users. Put supabase into read-only mode. pgdump and pgrestore. Cut over to the render database.
We would much prefer (1) if possible, but the issue I ran into is that you guys don’t allow superuser access on hosted postgres which seems necessary to make a read replica. Maybe someone can do that part for me on your end?
For (2), it was taking hours to download the pg_dump, so we could contact Supabase to see if they could help us speed that up.
If you have any other ideas, I’m all ears! Thanks