roles management problem after upgrading in PG 17

Поиск
Список
Период
Сортировка
От Fabrice Chapuis
Тема roles management problem after upgrading in PG 17
Дата
Msg-id CAA5-nLAjVBt=C=K5VpkigKMbyBkVr2xGRkqtL8vxEgjOn07Z7Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: roles management problem after upgrading in PG 17
Список pgsql-hackers
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 по дате отправления: