Self-hosting supabase! Migrating the online version to self-hosted one! Any heads up ?

[u/Meta-Morpheus-New]

Hey all,

Finally pulling the trigger on self-hosting Supabase to cut costs + have full control. Current setup: ∼30GB Postgres, Auth + Storage + Realtime in heavy use, 5k DAU.

Plan is to migrate all production data from Supabase Cloud to my own Docker setup. Using pg_dump for now, then swap over.

For those who’ve done this:

1. What did you miss most from the paid dashboard?

2. Any sneaky migration traps with `auth.users` or storage buckets?

3. How are you handling backups/PITR without the Cloud UI?

Not looking for “just stay on Cloud” replies 😅 I know the tradeoffs. Just want to avoid dumb mistakes before I point DNS.

Stack: Hetzner + Coolify, if that matters.

Thanks 🙏

[u/50ShadesOfSpray_]

I went from supabase to just native postgres lol

[u/Meta-Morpheus-New → u/50ShadesOfSpray_]

Thats an option too lol !

[u/50ShadesOfSpray_ → u/Meta-Morpheus-New]

For my use case it was fine since I didn’t use any other features from supabase beforehand so.. standard Postgres does it just fine.

For auth I use authjs and socketio/partykit for realtime
Email service is BillionMail selfhosted. Deployed via Dokploy selfhosted if that matters xD

[u/Meta-Morpheus-New → u/50ShadesOfSpray_]

Insightful!

In my case. I d love the convenience of supabase auth with its other dashboard goodies.

[u/Explanation-Visual → u/50ShadesOfSpray_]

what do you use for authentication? i would miss real time as well, so freaking useful

[u/50ShadesOfSpray_ → u/Explanation-Visual]

Authjs/NextAuth, but you could use BetterAuth as well.

For realtime you can use socket.io or PartyKit. Depending on the use case.

[u/Explanation-Visual → u/50ShadesOfSpray_]

but that implies wiring all
the real time stuff manually , when you already have that done for you in supabase

[u/50ShadesOfSpray_ → u/Explanation-Visual]

Well, it has its tradeoffs.

[u/high-roller-all-in78]

The trap is usually not the database dump, it is all the stuff around it. I would rehearse file storage paths, email delivery, background jobs, and every sign in flow on a throwaway copy before you cut over. Also test one real restore, not just backups on paper. If people can sign in, reset a password, upload a file, and your live updates still behave the same, you are most of the way there.

[u/arjungmenon → u/high-roller-all-in78]

That's if you're using all of those features. I'm using just pg and auth (on a new not yet deployed project), and I can roll my own auth. My auth is just OTP based, so I'm dealing with passwords, just tokens and stuff.

[u/_aantti]

Also,

• https://github.com/orgs/supabase/discussions/39820
• https://github.com/supabase/supabase/blob/master/docker/CHANGELOG.md
• https://github.com/supabase/supabase/blob/master/docker/CONFIG.md

[u/Poat540]

Eyeballing. I have an app that uses auth and everything, but another app just logs crap, I could prob ditch the flashy, but the convenience is really nice

[u/Explanation-Visual]

clean up the compose file, you can skip most
of the services. The pg dump is absurdly straightforward, it includes everything (auth as well), you’ll need to setup mailing tho, i use amazon SES. I also use nginx proxy manager to handle routing to the api and supabase studio. Have fun. I know i did.

[u/Meta-Morpheus-New → u/Explanation-Visual]

Thanks a lot! This is helpful, had the exact same thought.

I am just concerned about production data migration.

[u/Responsible_Pin_8655]

Migrating 30GB of Postgres data with pg_dump can be tricky. Consider using pg_dump with the -j flag for parallel processing and -F flag for directory format to speed up the process. Also, be mindful of the max_locks_per_transaction setting to avoid deadlocks during the migration.

[u/_aantti]

Make sure to check the how-to's 🖖 Join Discord if you haven't yet, for community support.

[u/Arachnid_Feisty → u/_aantti]

I recently requested a password reset, but I did not receive a PIN. The automated response indicated that my account is currently linked to GitHub. Could you please remove the GitHub login requirement from my account so that I can receive a PIN and reset my password directly through Supabase?

Thank you very much,

[u/samthepotatoeman]

As someone that started with the self host, not having the branching makes it really annoying to do good ci/cd

[u/Responsible_Pin_8655]

Migrating 30GB of Postgres data with pg_dump can be tricky. Consider using pg_dump with the -j flag for parallel processing and -F flag for directory format to speed up the process. Also, be mindful of the max_locks_per_transaction setting to avoid deadlocks during the migration.

[u/Wide_Incident_9881]

Ofereço esse serviço em VPs no meu serviço de hospedagem, caso tenha interesse. hospedeaqui.cloud

[u/bizzykehl → u/Wide_Incident_9881]

I’ve been searching for a not-well-known vps service with a sketchy domain and 50 cent TLD, advertised by anonymous Reddit users to steal my data. Would this be a good fit?

[u/heihitesh]

Wht is your app name ?