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 1sMQPD-002Fsd-Hg for pgsql-sql@arkaria.postgresql.org; Wed, 26 Jun 2024 11:01:39 +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 1sMQPB-003VO2-DY for pgsql-sql@arkaria.postgresql.org; Wed, 26 Jun 2024 11:01:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sMQPB-003VNs-4a for pgsql-sql@lists.postgresql.org; Wed, 26 Jun 2024 11:01:37 +0000 Received: from mail.nepustil.net ([2001:14f8:1:1::8]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sMQP8-003DGj-8L for pgsql-sql@lists.postgresql.org; Wed, 26 Jun 2024 11:01:36 +0000 Received: from [2001:14f8:21c:10::124] (port=60086 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 1sMQNd-000DW7-LQ; Wed, 26 Jun 2024 13:01:31 +0200 From: Axel Rau Message-Id: <2D10E4D5-1DE0-41A8-821C-FFDA42F0C512@Chaos1.DE> Content-Type: multipart/alternative; boundary="Apple-Mail=_6FBC4C35-5E16-4EF9-A541-A7868195DC48" Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\)) Subject: Re: struggling with GRANT while upgrading from 13 to 16 Date: Wed, 26 Jun 2024 13:01:30 +0200 In-Reply-To: <5436D737-391B-4912-82B9-8E479B0A36AE@Chaos1.DE> Cc: pgsql-sql@lists.postgresql.org To: Steve Midgley References: <5436D737-391B-4912-82B9-8E479B0A36AE@Chaos1.DE> 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=_6FBC4C35-5E16-4EF9-A541-A7868195DC48 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 > Am 25.06.2024 um 19:38 schrieb Axel Rau : >=20 >> GRANT daemons TO axel WITH ADMIN OPTION; >> GRANT xtrole TO axel WITH ADMIN OPTION;=20 > No this worked. (-: > I do another dump and try to load it. But this failed as before, Axel --- PGP-Key: CDE74120 =E2=98=80 mobile: +49 160 7568212 computing @ chaos claudius --Apple-Mail=_6FBC4C35-5E16-4EF9-A541-A7868195DC48 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8

Am 25.06.2024 um 19:38 schrieb Axel Rau <Axel.Rau@chaos1.de>:

GRANT daemons TO axel WITH ADMIN = OPTION;
GRANT xtrole TO axel WITH ADMIN = OPTION; 
No this worked. (-:
I do another dump and try = to load it.
But this failed as = before,

Axel
---
PGP-Key: CDE74120 =  =E2=98=80 mobile: +49 160 7568212
computing @ = chaos claudius

= --Apple-Mail=_6FBC4C35-5E16-4EF9-A541-A7868195DC48--