Heroku Deployment
I managed to prepare a deployment for Heroku. the deployment happens successfully. However I'm having issues with initializing postgres.
https://github.com/sagararyal/twenty-heroku
-> https://planet-20-1b4a1117717b.herokuapp.com/welcome
Running heroku run yarn database:init:prod returns memory error. see image.
I tried to run postgres docker locally as well and am unable to do so.
Can anyone review what could be wrong, or help me to proceed further by sharing a copy of empty postgres dump with twenty's schema?
2 Replies
After some debugging, I have some answers, and more questions. DB init runs with larger dyno.
However, does this mean twenty doesn't run with most db providers?
heroku-postgres is not compatible, as it doesn't seem to support quite some pg extensions.
And supabase also doesn't seem to support mysql_fdw pg extension.
And supabase also doesn't seem to support mysql_fdw pg extension.
Twenty isn't memory-efficient as of now so it can be a problem (docs recommend at least 4 GB of RAM while I'd say 8 GB is the least needed amount of RAM to use the app freely without any problems). Another problem is with database because of GraphQL extensions so if your database provider doesn't support installing extensions to postgres, then you won't be able to run project (although that may change once core team gets rid of underlaying GraphQL API calls but I'm not sure if it'll fix your problem)
You can check vendor-specific instructions here if you decide in the future to change provider https://twenty.com/developers/section/self-hosting/cloud-providers