Postgres Pro
Downloads
Home   >   mailing lists

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

From Axel Rau
Subject struggling with GRANT while upgrading from 13 to 16
Date
Msg-id A9A63660-310A-4F87-B01D-998E3A3A086A@Chaos1.DE
Whole thread Raw
Responses Re: struggling with GRANT while upgrading from 13 to 16
Re: struggling with GRANT while upgrading from 13 to 16
List pgsql-sql
Tree view 
Hi all,

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.

Correcting this on 13 seems impossible as new syntax/options are required.

What would be the upgrade path to fix this?
What would be the SQL phrase to do it ?

Any help appreciated,
Axel
---
PGP-Key: CDE74120  ☀ mobile: +49 160 7568212
computing @ chaos claudius

pgsql-sql by date:

Previous
From: Kanimozhi Manoharan
Date:
Subject: Re: Postgres fine tuning
Next
From: Steve Midgley
Date:
Subject: Re: struggling with GRANT while upgrading from 13 to 16