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,
