Re: struggling with GRANT while upgrading from 13 to 16

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Axel Rau <Axel(dot)Rau(at)Chaos1(dot)DE>
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: struggling with GRANT while upgrading from 13 to 16
Date: 2024-06-25 18:46:09
Message-ID: 1347597.1719341169@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Axel Rau 2024-06-26 11:01:30 Re: struggling with GRANT while upgrading from 13 to 16
Previous Message Axel Rau 2024-06-25 17:38:33 Re: struggling with GRANT while upgrading from 13 to 16