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 1twk5O-00HBEU-LP for pgsql-general@arkaria.postgresql.org; Mon, 24 Mar 2025 15:51:34 +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 1twk5N-005Nyq-9n for pgsql-general@arkaria.postgresql.org; Mon, 24 Mar 2025 15:51:33 +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 1twk5M-005Nyh-U5 for pgsql-general@lists.postgresql.org; Mon, 24 Mar 2025 15:51:32 +0000 Received: from mout.gmx.net ([212.227.17.20]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1twk5K-000tra-2d for pgsql-general@lists.postgresql.org; Mon, 24 Mar 2025 15:51:32 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1742831489; x=1743436289; i=shammat@gmx.net; bh=acrguZ/LKAxn+68v49dChLbIb/dY0oEgqEZCN5US7gE=; h=X-UI-Sender-Class:Message-ID:Date:MIME-Version:Subject:To: References:From:In-Reply-To:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=RGUf89I5nhYPZ2LqprHXvJ7CyVY2eOIjOBCNaAJJiSmfloXJlZxM8d7nJCyodfH8 WAxgkAo8wV6N30TgDdgdFmYgSyhwOxVmYrqAub0/vhul1HTmiFqKBs3HRIuzu0aLv Y5QjBPKFjojOe5msK23wz698fey9uI8u4iYCXm/e/jNSjk2vnxU1/tDDRZYCNnfYx GyUg2jrELNaaR3g30IIfNYf5lMUx20P0BjppgbrqZe2wINj27iYgzvGIFT7aYSwpI 3+F7yrEWLGDudm3bkuSXEeBcfNk/R4jB6Hsy8UpMN9ScObOiWLmCccRJnDPdsXXn+ YltwQyl+4/I2ObQcdQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.8.0.17] ([185.40.248.10]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MBm1U-1trCBh2xQ4-0072kR for ; Mon, 24 Mar 2025 16:51:29 +0100 Message-ID: <317e02ed-1fa9-4adc-ad0c-f04184fee05b@gmx.net> Date: Mon, 24 Mar 2025 16:51:28 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Experience and feedback on pg_restore --data-only To: pgsql-general@lists.postgresql.org References: <53760c70-4a87-a453-9e02-57abc9cb2e54@gmx.net> Content-Language: de-DE From: shammat@gmx.net In-Reply-To: <53760c70-4a87-a453-9e02-57abc9cb2e54@gmx.net> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:PfYLWrkhIF3rhkpkb+ytaSLMUqs/TyVz4yBsEIFMzkaVXwTCY/2 CFmWWXmBWw+GBRJJLnPiwSXF+T4mm0bxSJURSX3lwrArDeA8scXWI0whT7DNQQXpqcWUEfn 06BFE4OuozqQ5OiR3dFZc1zVyO8knvYCFYIQHBm93ndcOanVIxXurFNRJ4n344aO4FoI38Q wVi5ZKrotpNH05kPUsyug== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:44blot/wMmQ=;qBZm/5zlfQ7DLDuPXK1OUiBkkjc hYICO5ifMoUxHQI72PIuXp6kM/4scdkf3f6uVv7AOkmNe0tyf1eopL0Zkg+GKhjUeHDpxb+N3 kjpmnnIVAuzFsqBzDbYVkoRJpq2zccrsStQb+ErhBio+upQX1W7YGlEQ1JrPr+Epgy2n+OU0q nOQNrspzwBPXqapAhO/03xQilf4GHEIh0C3DxXp5X+c7/T1VGGbss6gBbUN2PXk9oOAihER8t s8dakVmiilsbKTlnFtZhU6Tc+ld09OwCcj5XI2YSP3ZWppnJoWvipJ9fgXvOL8ouiFtJ17TGh actSFDCVSEFoU2X1LD3y1ygD+TrksoTFyyZeiuTMKyP72CKR1aZ998i+z+5vexl13cg6lblun Sh/1gmpp93NtmOBW1LNPcJV/jmwrcKVyOIWg4jXupKg25h3gfz8e44z68wEypYV42FzqovhE1 DzaN1EfF0tFWfdgIbxLqwE0hb2lWJ3twSawCe7lqFZzmEZF6cirCTEfMNPqD/rIqPIpiNoJC4 FxnQFHgSWFik7iLywXZKcCPvwZyC5EWVVAnynnQxpXbQ0/caFrYfKV5+Pcd4TCGzRoXGzuKKV DUYDweuliXPlvvruRqCuJBYe7/a3h1V4n+q+yB34XvzBQvTRrp+f2+Exm5a0AbibLnDNvojRQ 4CaJ/Za1E9qVX92lNJugRjSSb27dWqfNKknBgWlucPX3XxqyrgxHP6ppOwzstpTrJc3z8SmnW 8O8MKIoc8jWEXiYC1+uGT14rMQiQ7s8I+Ud+H7Eq9r6UIFt0AdmPIZ3rTRf3aT0zbiDCvstJg +rY3sdEytpoY6UVO4a9z0pjvSF+31wl8txah2wXMvQ2rLw2RtWGLxuhpKogEUe+3HR4UTBaRF MQ/8WQyWS2Lm3jRvbOLwKN1SHwcEsVltJJe5NkW2BR1KQ0dctkRtxEhFmW4baFPAUYoDBqYed gZ7IcS8AMzwqN2zjw1K+fDubQ2GJfeUGQf31hrLlZqtxRuTHOF9H2Oe3udFjnRNFFZGNmong0 R34tr8IqbtqxuEhBaNsJOOMVsgWPS9yHaI21jbzYZCNuAycluhEUmciZ9ygJgbmQlXBDwJjng K1YVcwfRV9QSIPIBkM8c8L8/TgdU0qNF6JlKVgHXGHGQoIgEorIhDEAjrsEm71CN10j34gu5x hLSECzrCtxg7p8ZLLLWHaWXRY0GFbFMg9YcBSW/uf3wxyAGa13a7TUC+zPksRqt+YQiLhbyyU LCdddl69cYo+JWy1jJMRwINKXoNY2Q+wp8FPOqVabD8Oj1hx2vnejerNWK9WteJSGrURYuxdB ztfQgRijm2DBlr1TQB8SfcIJ7hi5bwqsp9V7cObAh24U15cTdADkU7H4qplEsWEJSm5Igk1S6 Bukr/fAtM1zi+Vm8xUMQ8d1VyA14pHgpXfDb/qms6um3KHtUrFZK/LyrYtkqDw2Zz2IPwxPMx CWod1nQOmbwftulpIEOhZR17Mvng= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Dimitrios Apostolou schrieb am 20.03.2025 um 23:48: > Things that made my life hard: > > * plenty of permission denials for both ALTER OWNER or SET SESSION > =C2=A0 AUTHORIZATION (depending on command line switches).=C2=A0 Both of= these > =C2=A0 require superuser privilege, but in my case this is not really ne= eded. > =C2=A0 Dbowner has CREATEROLE and is the one who creates all the roles (= WITH > =C2=A0 SET TRUE), and their private schemata in the specific database.= =C2=A0 Things > =C2=A0 would work if pg_restore did "SET ROLE" instead of "SET SESSION > =C2=A0 AUTHORIZATION" to switch user. Is this a straightforward change o= r there > =C2=A0 are issues I don't see? I think that can be avoided by using --no-owner and --no-privileges