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 1tMDiD-002kui-Q6 for pgsql-general@arkaria.postgresql.org; Fri, 13 Dec 2024 22:00:41 +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 1tMDiB-00Cttz-8I for pgsql-general@arkaria.postgresql.org; Fri, 13 Dec 2024 22:00:40 +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 1tMDiA-00Cttq-R1 for pgsql-general@lists.postgresql.org; Fri, 13 Dec 2024 22:00:40 +0000 Received: from mout-p-101.mailbox.org ([2001:67c:2050:0:465::101]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tMDi9-002gxw-3m for pgsql-general@postgresql.org; Fri, 13 Dec 2024 22:00:38 +0000 Received: from smtp102.mailbox.org (smtp102.mailbox.org [10.196.197.102]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-p-101.mailbox.org (Postfix) with ESMTPS id 4Y93DY6q4Yz9ssx; Fri, 13 Dec 2024 23:00:29 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mailbox.org; s=mail20150812; t=1734127230; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=2LR9Mem8MZ5N4afvGye1mR0dioY5s1sG7Zr2rtgixcg=; b=urwmy9m6pRXqO6NYXO6ZUtF/MHPgfi7qEs/TAa99dsRr8lU04rE0UpcLZCKU+WWUoj4IUa qTxY+nNO0PWv2W049ViYRPbwoG5oKsDvcExwg/KZA1IBCDDNvhbLfICa+YsuvBU6XH1VJo cMIze7sBc8F4FznqfYqzas0ynbw0lIcK7kq5iBIvojb4vBQtbuXAh9XNoeg5+MBBndh7t5 I9KujeqoYSIy/uyeeCnTGtRGXNVTMGPxoqk7WyHYUKDJK1rJtEeWAE38IXIXeMaKLkP1Rs 2eDAErTtVNa0lrkxGkkbufKsdoP7cOm04RuDQdskctPSus66eq+9/MCOUJskZw== Message-ID: <4fafbaf4-9b08-493a-878b-53679acbfb1e@mailbox.org> Date: Fri, 13 Dec 2024 14:00:16 -0800 MIME-Version: 1.0 Subject: Re: Errors when restoring backup created by pg_dumpall To: Adrian Klaver , Tom Lane Cc: "David G. Johnston" , "pgsql-general@postgresql.org" References: <6a6439f1-8039-44e2-8fb9-59028f7f2014@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> <16a6330b-9e6c-4f09-974b-075a7facb4c5@aklaver.com> <2b1143ef-2740-437a-a68d-664bb36beca8@aklaver.com> Content-Language: en-US From: PopeRigby In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-MBO-RS-META: iiwf9odjhsk7t49t8ygx6dmtoqpqqk6o X-MBO-RS-ID: d62723cfcf971327f2a List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 12/13/24 08:46, Adrian Klaver wrote: > On 12/12/24 22:19, PopeRigby wrote: >> On 12/10/24 21:22, Adrian Klaver wrote: >>> On 12/10/24 19:05, PopeRigby wrote: > >>> >>> If I am following correctly I believe you need this one: >>> >>> https://www.postgresql.org/message-id/attachment/166859/v2-0002-Use-new-style-SQL-function-in-earthdistance-exten.patch >>> >>> >>> It has the changes that include the schema qualifications. The one >>> you used does not have those modifications. >>> >> Beautiful. How can I follow this so I know when it gets upstream? >> > > > You can check here: > > https://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=contrib/earthdistance;h=282f5a80b204a488b5c8ec6d24eaaab8a714bfaf;hb=HEAD > > > and see when the earthdistance--1.1--1.2.sql and earthdistance--1.2.sql > scripts show up. > > Though a formal release won't happen until the dates listed here: > > https://www.postgresql.org/developer/roadmap/ > > with nearest one being February 13th, 2025. > > FYI, these are target dates and not set in stone. > Thanks!