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 1tM8ok-0026nB-IE for pgsql-general@arkaria.postgresql.org; Fri, 13 Dec 2024 16:47:06 +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 1tM8oi-0098uN-0T for pgsql-general@arkaria.postgresql.org; Fri, 13 Dec 2024 16:47:05 +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 1tM8og-0098tp-Pt for pgsql-general@lists.postgresql.org; Fri, 13 Dec 2024 16:47:04 +0000 Received: from fhigh-a1-smtp.messagingengine.com ([103.168.172.152]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tM8od-002fkp-EV for pgsql-general@postgresql.org; Fri, 13 Dec 2024 16:47:03 +0000 Received: from phl-compute-06.internal (phl-compute-06.phl.internal [10.202.2.46]) by mailfhigh.phl.internal (Postfix) with ESMTP id 04004114018C; Fri, 13 Dec 2024 11:46:58 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-06.internal (MEProxy); Fri, 13 Dec 2024 11:46:58 -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=1734108417; x=1734194817; bh=rv/J2IG2RPulwPXrXxo40sRmVH0pMrI6bNXufmaos3Q=; b= aO3MCPFQrmrsMIg5SLCvc+qq+BmoGhxoRPA654z7X7sRvbcqjyrCKNgFeg1ODO+D RTL2+rp0o6CzTa+1OdRQC2tsULTATz5zcIFkYYnEosk46BkvjNzll56sJTvDJpOt Aj2wNAPuR1XzSQAunqc0w4yjWEooQEHksWVlSQiKlaJsnxNVRtcAFHuy9FUcgZ5V I43Px4lkrlh/wWg62xIB/6FQ2zGC38bz1SPAHAoYGbXpvcmHVv70mBRYigBHJwfP ObtaGpNgSqSq0BfA1TveieGJFbG8HoVuZaT8tRe5ecz+Z+2nChbGTvnSN5RHUL7p VMy0zgBt1+KDjSZpoxkt0A== 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=1734108417; x= 1734194817; bh=rv/J2IG2RPulwPXrXxo40sRmVH0pMrI6bNXufmaos3Q=; b=Z E4ID2XZF3A2jQbSumMcX9zjYiq0X2BpNbKGL16e4vSTcWb9w0SGA4IbYtHhJhekj rw04+ksNThOE873vTkb6FK7ZIaOUXeYXsTbp6Brp3xhYN4nEavxw7KLATH5RGtKp BtwnJlQQhWRbZp2XpJD7arx6otT9n/EIUdKP9oF85bd1dIsqyypPYeo3MwUVVa8q CaH+i+3sFYlFNSozZgSW5ugQlVBZHo7HbrSJMbLZdNyCfHlhImhudbut1dYT2pNq i6fS4RjXELXihxsdRHKoFvXRx0MVdqB/Y5PZbIIocyCic4RBo/hiJwNNS2REweRP VU9hTHv+MmF5qzxF+w/+g== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrkeejgdelvdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdpuffr tefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnth hsucdlqddutddtmdenucfjughrpefkffggfgfuvfevfhfhjggtgfesthejredttddvjeen ucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrse grkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpeeuudefjeejgffgtddtgeeh gfekueevkeekieettedtkeffheeivdethfevffegueenucffohhmrghinhepphhoshhtgh hrvghsqhhlrdhorhhgnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghi lhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomhdpnhgspg hrtghpthhtohepgedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepphhophgvrhhi ghgshiesmhgrihhlsghogidrohhrghdprhgtphhtthhopehtghhlsehsshhsrdhpghhhrd hprgdruhhspdhrtghpthhtohepuggrvhhiugdrghdrjhhohhhnshhtohhnsehgmhgrihhl rdgtohhmpdhrtghpthhtohepphhgshhqlhdqghgvnhgvrhgrlhesphhoshhtghhrvghsqh hlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 13 Dec 2024 11:46:56 -0500 (EST) Message-ID: Date: Fri, 13 Dec 2024 08:46:56 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Errors when restoring backup created by pg_dumpall To: PopeRigby , 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: Adrian Klaver In-Reply-To: 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/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. -- Adrian Klaver adrian.klaver@aklaver.com