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

> Am 25.06.2024 um 20:46 schrieb Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>
> Axel Rau <Axel(dot)Rau(at)Chaos1(dot)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?

Using version 16 pg_dump fixed the problem.

Soorry for the noise and thanks to all help and hints,
Axel
---
PGP-Key: CDE74120 ☀ mobile: +49 160 7568212
computing @ chaos claudius