supautils icon indicating copy to clipboard operation
supautils copied to clipboard

Published 20 hours ago • verified publisher icon supabase

PostgreSQL 16 fixes the CREATEROLE problem

Open steve-chavez opened this issue 1 year ago • 1 comments

See https://rhaas.blogspot.com/2023/01/surviving-without-superuser-coming-to.html.

We could add a note here https://github.com/supabase/supautils#role-security.

steve-chavez avatar May 12 '23 01:05 steve-chavez

This is already giving trouble for migrating to pg 16, many tests fail. I think we should just disable the whole reserved roles/memberships feature for pg >= 16.

steve-chavez avatar Sep 20 '23 21:09 steve-chavez

Postgresql 17 has now dropped... And supabase appears to still only support PG15. Is this issue one of the main reasons for that? I tried monkey-hits-keyboard style to get PG16 working with a few of the required extensions but quickly realised I was out of my depth. Supabase seemed to track relatively well with updates until then, and there are some interesting performance updates in there with 17.

AntonOfTheWoods avatar Sep 28 '24 01:09 AntonOfTheWoods

https://github.com/supabase/supautils/pull/86 already fixed this issue.

steve-chavez avatar Oct 01 '24 23:10 steve-chavez