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 1rSJPI-00Cst4-LI for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jan 2024 16:13:49 +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 1rSJPH-00EBQ1-QK for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jan 2024 16:13:47 +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 1rSJPH-00EBPs-F6 for pgsql-admin@lists.postgresql.org; Tue, 23 Jan 2024 16:13:47 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rSJPF-003KDM-2w for pgsql-admin@postgresql.org; Tue, 23 Jan 2024 16:13:46 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 40NGDgAH4046118; Tue, 23 Jan 2024 11:13:42 -0500 From: Tom Lane To: kaido vaikla cc: pgsql-admin@postgresql.org Subject: Re: pg_dumpall and owner of the extension In-reply-to: References: Comments: In-reply-to kaido vaikla message dated "Tue, 23 Jan 2024 16:31:30 +0200" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <4046116.1706026422.1@sss.pgh.pa.us> Date: Tue, 23 Jan 2024 11:13:42 -0500 Message-ID: <4046117.1706026422@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk kaido vaikla writes: > So pg_dumpall is not aware who ran "CREATE EXTENSION"? Yeah, pg_dump makes no effort to restore extensions with the same owner. This didn't matter back when the feature was designed, because you had to be superuser to install most interesting extensions. I suppose we should revisit the choice sometime. There's no ALTER EXTENSION OWNER command, though, so it would need to be done in a different way from other object types. Not sure offhand what the downsides of that would be. regards, tom lane