© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•8mo ago•
4 replies
Fadlillah

How to enable aggregate functions on self hosted supabase.

When using supabase on their infrastructure, we enable it by using this sql.

ALTER ROLE authenticator SET pgrst.db_aggregates_enabled = 'true';
NOTIFY pgrst, 'reload config';

but I think it's different when we enable it on self_hosted. Cause when I try that, aggregate function still cannot be called.
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Supabase Edge Functions with Self Hosted
SupabaseSSupabase / help-and-questions
2mo ago
Supabase CLI on Self Hosted
SupabaseSSupabase / help-and-questions
4y ago
How to enable extensions in self hosted
SupabaseSSupabase / help-and-questions
2mo ago
Cannot enable PG_CRON in self hosted Supabase
SupabaseSSupabase / help-and-questions
3y ago