Request a Demo
Home   >   mailing lists

roles management problem after upgrading in PG 17 - Mailing list pgsql-hackers

From Fabrice Chapuis
Subject roles management problem after upgrading in PG 17
Date
Msg-id CAA5-nLAjVBt=C=K5VpkigKMbyBkVr2xGRkqtL8vxEgjOn07Z7Q@mail.gmail.com
Whole thread Raw
Responses Re: roles management problem after upgrading in PG 17
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Fixing MSVC's inability to detect elog(ERROR) does not return
Next
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: recoveryStopsAfter is not usable when recovery_target_inclusive is false