Postgres Pro
Downloads
Home   >   mailing lists

Re: struggling with GRANT while upgrading from 13 to 16 - Mailing list pgsql-sql

From Tom Lane
Subject Re: struggling with GRANT while upgrading from 13 to 16
Date
Msg-id 1347597.1719341169@sss.pgh.pa.us
Whole thread Raw
In response to struggling with GRANT while upgrading from 13 to 16  (Axel Rau <Axel.Rau@Chaos1.DE>)
Responses Re: struggling with GRANT while upgrading from 13 to 16
[RESOLVED] Re: struggling with GRANT while upgrading from 13 to 16
List pgsql-sql
Tree view 
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?

            regards, tom lane

pgsql-sql by date:

Previous
From: Axel Rau
Date:
Subject: Re: struggling with GRANT while upgrading from 13 to 16
Next
From: Axel Rau
Date:
Subject: Re: struggling with GRANT while upgrading from 13 to 16