would anybody be able to give me some help migrati...
# sqlb
backjisceglia
07/14/2022, 6:20 AMwould anybody be able to give me some help migrating my supabase DB schema over to GCP? I plan on using supabase for dev, and am having a tough time with the best way to just copy the db schema over to my GCP Database
j
jaitaiwan
07/14/2022, 7:43 AMHave yous seen this @backjisceglia ?
https://supabase.com/docs/guides/database#migrating-between-projects
jaitaiwan
07/14/2022, 7:43 AMWondering if this will help lead you in the right direction
b
backjisceglia
07/14/2022, 7:48 AMYea, I was able to get the dump, but I think trying to recreate the db in an environment outside of GCP is causing issues
j
jaitaiwan
07/14/2022, 8:47 AMOutside of GCP?
b
backjisceglia
07/15/2022, 12:31 AMsorry i was tired and didnt know what i was saying lol
backjisceglia
07/15/2022, 12:31 AMI meant, outside of Supabase
backjisceglia
07/15/2022, 12:32 AMim trying to do it in pgAdmin, and pretty much its erroring out a lot
backjisceglia
07/15/2022, 12:32 AMfrankly, all i need is the table schemas + the extensions that are in place for uuid generation and time.now()
backjisceglia
07/15/2022, 12:32 AMjust wondering if there was a simpler way
j
jaitaiwan
07/15/2022, 12:35 AM@backjisceglia what you do, is you initialise the self-hosted supabase in gcp... then you apply the dump over the top
jaitaiwan
07/15/2022, 12:36 AMThe only thing that's outstanding after that is your auth settings
b
backjisceglia
07/15/2022, 12:36 AMi apologize but i don't quite understand what this means
j
jaitaiwan
07/15/2022, 1:05 AMOk so you're setting up self-hosted supabase in your GCP right?
b
backjisceglia
07/15/2022, 1:05 AMi just have a Postgres db set up in GCP
j
jaitaiwan
07/15/2022, 1:18 AMPerfect ok
jaitaiwan
07/15/2022, 1:19 AMNext step is to use the Postgres creds in the self-hosting setup
jaitaiwan
07/15/2022, 1:19 AMb
backjisceglia
07/15/2022, 1:25 AMso i dont need to do all of this right? like assuming i need none of the api stuff
j
jaitaiwan
07/15/2022, 1:40 AMWhat do you mean? Maybe I need to ask, what are you trying to achieve?
b
backjisceglia
07/15/2022, 1:44 AMso i have two database tables on supabase
backjisceglia
07/15/2022, 1:44 AMi want those two tables on my gcp instance of postgres
backjisceglia
07/15/2022, 1:44 AMand manually recreating them seems like the incorrect way to go about this
j
jaitaiwan
07/15/2022, 1:50 AMYou need it replicated or you need supabase to use the gcp db
jaitaiwan
07/15/2022, 1:50 AM?
b
backjisceglia
07/15/2022, 1:51 AMreplicated
j
jaitaiwan
07/15/2022, 7:49 AMOk well I don’t know how Postgres replication works…
jaitaiwan
07/15/2022, 7:50 AMBut what you could do is use the http extension + Postgres trigger function and a google function to send data from inside Postgres to gcp
b
backjisceglia
07/15/2022, 10:11 PMOk yea this sounds difficult
backjisceglia
07/15/2022, 10:13 PMRealistically, if I’ve got 2 relatively basic tables, and I want two instances of them (prod and dev) how much traffic/interaction would I need to eat up all of free tier
backjisceglia
07/15/2022, 10:13 PMBecause this is a project I’ll make no money off of and I can’t really afford supabase paid tier. The only reason I’m trying to move to GCP is bc I have a bunch of spare credits
j
jaitaiwan
07/16/2022, 12:59 AMI’m not sure, but the free riser in oracle cloud is pretty generous and you could host your own supabase instance there and then migrate the project across using the migration steps in the guide