Restore 1GB Of Data to a New Supabase - pg_restore dump
🔢DB Connections
storage
Solved
storageSolvedI'm migrating a firebase DB into Supabase, so my approach is basically an ETL using local docker pg to process the data, its faster then using cloud.
After that i generate a .dump backup file from the pg docker, it contains around 1GB.
Then after several different tests and method, the best one i found was to simply create an aws ec2 instance t4g.small to use pg_restore directly into supabase
Finally i run
This takes around 20min to process the 1GB dump
Supabase Config
- Im using Pro Small (15USD) + IPV4 (4USD)
After that i generate a .dump backup file from the pg docker, it contains around 1GB.
Then after several different tests and method, the best one i found was to simply create an aws ec2 instance t4g.small to use pg_restore directly into supabase
Finally i run
This takes around 20min to process the 1GB dump
Supabase Config
- Im using Pro Small (15USD) + IPV4 (4USD)
