Hi,

After upgrading from Postgres version 14 to Postgres version 17, I noticed
that some "grantor" roles (admin_role) disappear when exporting all roles
with grants

/usr/pgsql-17/bin/pg_dumpall  --globals-only --quote-all-identifiers
--binary-upgrade --no-sync -f /var/lib/pgsql/roles_bin.sql

Consequently, the admin_role could not administer some roles in version 17
related to modifications made in version 16 concerning roles administration.

A message could be displayed when executing pg_upgrade with option --check
that the attribute "createrole"  for a user is more restrictive since
version 16 and anomalies may appear after upgrading in the new version.

What is your opinion

Fabrice

Reply via email to