Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sMSqt-002XAh-Gf for pgsql-sql@arkaria.postgresql.org; Wed, 26 Jun 2024 13:38:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sMSqr-004bzW-RT for pgsql-sql@arkaria.postgresql.org; Wed, 26 Jun 2024 13:38:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sMSqr-004bzN-Ik for pgsql-sql@lists.postgresql.org; Wed, 26 Jun 2024 13:38:21 +0000 Received: from mail.nepustil.net ([2001:14f8:1:1::8]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sMSqp-003enm-Eb for pgsql-sql@lists.postgresql.org; Wed, 26 Jun 2024 13:38:21 +0000 Received: from [2001:14f8:21c:10::124] (port=60522 helo=axels-imac.in.chaos1.de) by mail.nepustil.net with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.95 (FreeBSD)) (envelope-from ) id 1sMSpJ-000FqQ-7g; Wed, 26 Jun 2024 15:38:14 +0200 From: Axel Rau Message-Id: <5589C96E-32A2-4FFD-A750-11FB7F444B5D@Chaos1.DE> Content-Type: multipart/alternative; boundary="Apple-Mail=_1E884433-6DA5-4D77-B1A9-0912B54AAE3E" Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\)) Subject: [RESOLVED] Re: struggling with GRANT while upgrading from 13 to 16 Date: Wed, 26 Jun 2024 15:38:15 +0200 In-Reply-To: <1347597.1719341169@sss.pgh.pa.us> Cc: pgsql-sql@lists.postgresql.org To: Tom Lane , Steve Midgley References: <1347597.1719341169@sss.pgh.pa.us> X-Mailer: Apple Mail (2.3608.120.23.2.7) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_1E884433-6DA5-4D77-B1A9-0912B54AAE3E Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 > Am 25.06.2024 um 20:46 schrieb Tom Lane : >=20 > Axel Rau writes: >> I=E2=80=99m getting >=20 >> 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". >=20 >> while trying load a dump from 13 into 16 server. >=20 > 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 =E2=98=80 mobile: +49 160 7568212 computing @ chaos claudius --Apple-Mail=_1E884433-6DA5-4D77-B1A9-0912B54AAE3E Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8

Am 25.06.2024 um 20:46 schrieb Tom Lane <tgl@sss.pgh.pa.us>:

Axel = Rau <Axel.Rau@Chaos1.DE> writes:
I=E2=80=99m 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 =  =E2=98=80 mobile: +49 160 7568212
computing @ = chaos claudius

= --Apple-Mail=_1E884433-6DA5-4D77-B1A9-0912B54AAE3E--