On Mon, Jul 28, 2025 at 12:11:22PM -0400, Bruce Momjian wrote:
> On Fri, Jul 25, 2025 at 10:07:38AM +0200, Fabrice Chapuis wrote:
> > Thank you for your reply, Robert.
> > My main goal was to report this observation, because I was surprised to see
> > that in the dump the grantors were not exported
On Fri, Jul 25, 2025 at 10:07:38AM +0200, Fabrice Chapuis wrote:
> Thank you for your reply, Robert.
> My main goal was to report this observation, because I was surprised to see
> that in the dump the grantors were not exported.
> Thanks for drawing my attention to the "observes" section; it is in
Thank you for your reply, Robert.
My main goal was to report this observation, because I was surprised to see
that in the dump the grantors were not exported.
Thanks for drawing my attention to the "observes" section; it is indeed
very useful.
For my part, I corrected the problem related to this pe
On Thu, Jul 24, 2025 at 7:03 AM Fabrice Chapuis wrote:
> 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
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
Con
