-
-
Notifications
You must be signed in to change notification settings - Fork 184
Add migration with admin
option for permissions to administer roles for postgres role beyond pg16
#1625
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Conversation
…ister roles beyond pg16
@encima migration LGTM but obviously need a repo approver. However - to confirm I'm seeing on the NIx CI / build psql. Is this a normal build failure?
|
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others. Learn more.
Could ALTER ROLE postgres CREATEROLE needed?
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others. Learn more.
Tests need to be adapted:
postgres/nix/tests/expected/roles.out
Lines 120 to 126 in 4039e4c
postgres | anon | f | |
postgres | authenticated | f | |
postgres | pg_monitor | f | |
postgres | pg_read_all_data | f | |
postgres | pg_signal_backend | f | |
postgres | pgtle_admin | f | |
postgres | service_role | f |
What kind of change does this PR introduce?
Fix
What is the current behavior?
PG17 and above does not apply the
with admin
option for the postgres roleWhat is the new behavior?
Apply role permissions for postgres role on versions beyond PG16
Additional context
Changelog