https://blog.cpbprojects.me/how-to-self-host-supab...
# readingc
chit
12/24/2022, 10:42 PMhttps://blog.cpbprojects.me/how-to-self-host-supabase-a-complete-guide
I wrote a blog post about how to self-host Supabase
m
madjar
12/25/2022, 5:12 PMHey, what about decoupling the database?
c
chit
12/25/2022, 5:12 PMthanks for asking, the funny thing is that this is what I wasn't able to figure it out
chit
12/25/2022, 5:13 PMI tried to spin up another postgres db, and input the credentials in the .env file
chit
12/25/2022, 5:13 PMbut I was unable to get it to work
chit
12/25/2022, 5:13 PMMy guess would be normally the db part of the docker initialize the db, but decoupled db needs to be set up
chit
12/25/2022, 5:14 PMat last, since I was able to connect to the dockered db anyways, I gave up
n
NiX
12/26/2022, 10:36 AMI also tried to decouple the database with a postgre server managed on digitalocean, it's really a hassle.
m
madjar
12/26/2022, 11:00 AMdo you wanna maybe take a session sometime, like 30 mins, and try to figure out this stuff together?
madjar
12/26/2022, 11:00 AMyeah so there is this issue on docker database losing its data after the stack restarts, its not persistent, a lot of discussions are open about it
madjar
12/26/2022, 11:01 AMim not sure about hosting the database itself on the server, the best practice would be to have it dockerized but either in a different compose file or something else
madjar
12/26/2022, 11:01 AMyeah
c
chit
12/26/2022, 11:02 AMhmm, I'm thinking maybe after supabase has generated the db on the docker db, we can call a postgresql backup function, get that sql file, and run it in another postgres db, and see if this works
n
NiX
12/26/2022, 1:22 PMI would ideally like to use digitalocean's self-managed database
NiX
12/26/2022, 1:22 PMbut you have to run the following migrations: https://github.com/supabase/postgres/tree/develop/migrations
NiX
12/26/2022, 1:24 PMI have errors everywhere, and digitalocean does not allow to create super users on posgre..
m
madjar
12/26/2022, 2:23 PMhey nix
madjar
12/26/2022, 2:23 PM@NiX
madjar
12/26/2022, 2:23 PMif you wanna hop on a call or something to see what can we do, i got a bit of time now
madjar
12/26/2022, 2:24 PMi would make a replication service or something, although i think its already built into postgres
madjar
12/26/2022, 2:24 PMidk never used pg before
c
chit
12/26/2022, 3:10 PMi've learnt from somewhere that we can do postgres backup, and it creates a sql script that, when run, creates the exact same db
3 Views