[RESOLVED] Re: struggling with GRANT while upgrading from 13 to 16

Am 25.06.2024 um 20:46 schrieb Tom Lane <tgl@sss.pgh.pa.us>:

Axel Rau <Axel.Rau@Chaos1.DE> writes:

I’m getting

ERROR:  permission denied to grant privileges as role "axel"
DETAIL:  The grantor must have the ADMIN option on role "daemons".
ERROR:  permission denied to grant privileges as role "axel"
DETAIL:  The grantor must have the ADMIN option on role "daemons".
ERROR:  permission denied to grant privileges as role "axel"
DETAIL:  The grantor must have the ADMIN option on role "xtrole".
ERROR:  permission denied to grant privileges as role "axel"
DETAIL:  The grantor must have the ADMIN option on role "xtrole".

while trying load a dump from 13 into 16 server.

First I've heard of such a problem.  Could you provide more detail on
this?  What are the actual roles and privileges involved?  Which
pg_dump version did you use?