supabase-postgres.git / summary / log / commit / refs

commit    50d0c7701fa7874b4dad9d2a3ec807cb9ff8b44a
Author:   Paul Cioanca <paul.cioanca@supabase.io>
Commit:   GitHub <noreply@github.com>
Date:     Fri Jun 06 10:57:31 2025 +0000

    fix(pg_upgrade): enable alter role queries after upgrade completes (#1630)


 ansible/files/admin_api_scripts/pg_upgrade_scripts/complete.sh | 1 +
 1 file changed, 1 insertion(+)

diff --git a/ansible/files/admin_api_scripts/pg_upgrade_scripts/complete.sh b/ansible/files/admin_api_scripts/pg_upgrade_scripts/complete.sh
index 37115ce0..31cc7d09 100755
--- a/ansible/files/admin_api_scripts/pg_upgrade_scripts/complete.sh
+++ b/ansible/files/admin_api_scripts/pg_upgrade_scripts/complete.sh
@@ -268,6 +268,7 @@ EOF
       SELECT current_setting('server_version_num')::INT / 10000 INTO major_version;
       IF major_version >= 16 THEN
         GRANT pg_create_subscription TO postgres;
+        GRANT anon, authenticated, service_role, authenticator, pg_monitor, pg_read_all_data, pg_signal_backend TO postgres WITH ADMIN OPTION;
       END IF;
       GRANT pg_monitor, pg_read_all_data, pg_signal_backend TO postgres;
     END


[parent: 19bdfcce7a55]