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 1tKnnH-00Arrj-HT for pgsql-general@arkaria.postgresql.org; Tue, 10 Dec 2024 00:08:03 +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 1tKnnE-00D8LP-6Q for pgsql-general@arkaria.postgresql.org; Tue, 10 Dec 2024 00:08:01 +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 1tKnnC-00D8LF-TP for pgsql-general@lists.postgresql.org; Tue, 10 Dec 2024 00:08:00 +0000 Received: from fout-b3-smtp.messagingengine.com ([202.12.124.146]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tKnnA-001zBg-RR for pgsql-general@postgresql.org; Tue, 10 Dec 2024 00:07:58 +0000 Received: from phl-compute-12.internal (phl-compute-12.phl.internal [10.202.2.52]) by mailfout.stl.internal (Postfix) with ESMTP id 54AEE11400D8; Mon, 9 Dec 2024 19:07:55 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-12.internal (MEProxy); Mon, 09 Dec 2024 19:07:55 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1733789275; x=1733875675; bh=n6qSZlpD4X6PZd0PRT+IZEqS5awOjOAe18HueSKvz1k=; b= g6lQa/PKoCOjWmEBzguv8NvE20+XE204P7W3VMcSFNYvjRKujIcZCLF6UFTIzTXI I/LHYvSQ7MRpGYevKfY8S/NxhfU6/02TnXGQzEhjC/yWtJ8QR9iU7ZkaW4i8TKoV 29CdquwyYXNaFIZ303mOpUfU9fbjW4AB4p2RJH/aczmdzAVFqCdVjI/rWCx4STk4 HXwpQ/APmxqp64GdRHvKZPvuVzYYjAIaBzSFk7BMRROwoIWgXeqWAbCDztqd948q A4ZKNMJ6xOaIFxa0gm8XJd4L60TirGPAuoCvpqgrkLLIl2/QTg2GliHXe5nyFEwa gGSqf/In6vwCArtWHwriOg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1733789275; x= 1733875675; bh=n6qSZlpD4X6PZd0PRT+IZEqS5awOjOAe18HueSKvz1k=; b=b pV1NA9pL8E3tan+OvUGFbikotrv/8+Xou9k4usbXiU/Vd/8JbCTqERRNtdMqXZPc F8onBW8HgycbYKQUrdHowSmueh0yXWMX1jiaiItvHAXy4MRnTNWVWs8a4J+lzFQa oSS8XvsDsuaeK5TrCVP5SU3fnLU8n1LtXk6EEMyEpQGzYWUggWtpImkjUOHTtoLc CRF3ATT/MWmb8iVUSEXp20dT579oZUuFxufDDHkifuGNzOVsQQwKM7qVQ9/R8AQc R3OV5cSvHcXOCZMBCKHud2gjRhZcokzT69BJitqL3T9mu9ef1wFE0yesNAGZIztI ey3M7q/8m2ALc39DW0+NQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrjeejgddulecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdpuffr tefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnth hsucdlqddutddtmdenucfjughrpefkffggfgfuvfevfhfhjggtgfesthejredttddvjeen ucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrse grkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpeeuudefjeejgffgtddtgeeh gfekueevkeekieettedtkeffheeivdethfevffegueenucffohhmrghinhepphhoshhtgh hrvghsqhhlrdhorhhgnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghi lhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomhdpnhgspg hrtghpthhtohepgedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepthhglhesshhs shdrphhghhdrphgrrdhushdprhgtphhtthhopehpohhpvghrihhgsgihsehmrghilhgsoh igrdhorhhgpdhrtghpthhtohepuggrvhhiugdrghdrjhhohhhnshhtohhnsehgmhgrihhl rdgtohhmpdhrtghpthhtohepphhgshhqlhdqghgvnhgvrhgrlhesphhoshhtghhrvghsqh hlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 9 Dec 2024 19:07:54 -0500 (EST) Message-ID: Date: Mon, 9 Dec 2024 16:07:53 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Errors when restoring backup created by pg_dumpall To: Tom Lane Cc: PopeRigby , "David G. Johnston" , "pgsql-general@postgresql.org" References: <6a6439f1-8039-44e2-8fb9-59028f7f2014@mailbox.org> <41791b6d-aaf5-4fed-9cc3-e89bc49e8637@mailbox.org> <1257068.1733025493@sss.pgh.pa.us> <06425038-e012-4bac-aec1-d9541436f893@mailbox.org> <92405f98-7f0c-4442-8252-697352daefc1@aklaver.com> <1470486.1733087658@sss.pgh.pa.us> <4ab662d8-57cc-471f-8a58-cfd71d1cea22@aklaver.com> <1475512.1733090108@sss.pgh.pa.us> <19d5f2c7-1252-4442-accb-8aa2cb289ad0@mailbox.org> <9a7ca237-7696-40e3-9ae6-12bd98c1b86c@mailbox.org> <5dc9dd9e-a3c9-45a1-8497-7e304812eb! 8c@aklaver.com> <4147349.1733786606@sss.pgh.pa.us> Content-Language: en-US From: Adrian Klaver In-Reply-To: <4147349.1733786606@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 12/9/24 15:23, Tom Lane wrote: > Adrian Klaver writes: >> You could file an issue here: >> https://www.postgresql.org/account/login/?next=/account/submitbug/ >> Ask if the developers could use the mechanisms available here: >> https://www.postgresql.org/docs/current/extend-extensions.html#EXTEND-EXTENSIONS-RELOCATION > > This wouldn't really move the needle, since (a) there is not some > magic group of people that will become involved who aren't already > and (b) the requested fix seems exactly the same as the work > already in progress at [1]. I made the suggestion to the OP, my mistake. Somewhere I missed that work was being done on this. > > What would help is to figure out why the proposed patch didn't > seem to work for you. I continue to suspect that you didn't > really install the updated extension, but it's unclea Are you referring to this?: https://www.postgresql.org/message-id/3316564.aeNJFYEL58@aivenlaptop > > regards, tom lane > > [1] https://www.postgresql.org/message-id/flat/3395418.1618352794@sss.pgh.pa.us -- Adrian Klaver adrian.klaver@aklaver.com