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 1tIhiE-00FzqQ-7h for pgsql-general@arkaria.postgresql.org; Wed, 04 Dec 2024 05:14:10 +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 1tIhiB-00Ez6d-Me for pgsql-general@arkaria.postgresql.org; Wed, 04 Dec 2024 05:14:08 +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 1tIhiB-00Ez4b-9l for pgsql-general@lists.postgresql.org; Wed, 04 Dec 2024 05:14:08 +0000 Received: from mout-p-202.mailbox.org ([2001:67c:2050:0:465::202]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tIhi9-000wqH-Ll for pgsql-general@postgresql.org; Wed, 04 Dec 2024 05:14:07 +0000 Received: from smtp1.mailbox.org (smtp1.mailbox.org [10.196.197.1]) (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-202.mailbox.org (Postfix) with ESMTPS id 4Y35KK6wBmz9spN; Wed, 4 Dec 2024 06:13:57 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mailbox.org; s=mail20150812; t=1733289238; 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=dY8VJtUwLW5IuX3rSABZT+YH84v4sKO0Mj7O9tFBHjY=; b=uq2beWTz9rZ+059mh3IiG9vi/vG7BQu5z6zZMHfAz0ha1uEHWll5Tt/o1WG2AsCJ1AcGfF /90a2RYKYaMcyWqOvKR+LUbwGzsEmjOs3SJkaKaqBgS47jmpdgwKI4sgttjILRbA6oin/L 45WHlkchTRS5PmffYV/XKpentBzmkpRsTmeEL2pvKkoARE7vbLTsQOXGDZMYAk2xDDr++v P2TaoMgfKRwo2aFBHzOPVZ/ib0k7mbl1BBnPDvZcI1IoUF/CciEA6Ci35I6E0qUMBBmCYJ 38JxJ7dPAE/fUiOI9KZ0rvoX5Qdzduq1KNKrm7DSWY546Q4uPvLQWkK8ekT6+g== Message-ID: <35df4a37-1a93-4aa5-9ecb-14a208f88e6f@mailbox.org> Date: Tue, 3 Dec 2024 21:13:42 -0800 MIME-Version: 1.0 Subject: Re: Errors when restoring backup created by pg_dumpall To: Tom Lane Cc: "David G. Johnston" , Adrian Klaver , "pgsql-general@postgresql.org" References: <6a6439f1-8039-44e2-8fb9-59028f7f2014@mailbox.org> <9c5ba566-27b8-4e8c-bf7d-2dc561509991@mailbox.org> <41791b6d-aaf5-4fed-9cc3-e89bc49e8637@mailbox.org> <1257068.1733025493@sss.pgh.pa.us> <06425038-e012-4bac-aec1-d9541436f893@mailbox.org> <1455925.1733084109@sss.pgh.pa.us> <8dfc7361-7cba-485b-b286-d4c011dffd47@mailbox.org> <1707489.1733188641@sss.pgh.pa.us> Content-Language: en-US From: PopeRigby In-Reply-To: <1707489.1733188641@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-MBO-RS-META: roehws1eepfmpzthba4dk1o8mfwfqyb3 X-MBO-RS-ID: ee3f079b84ee3f1fa24 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 12/2/24 17:17, Tom Lane wrote: > PopeRigby writes: >> On 12/1/24 12:15, Tom Lane wrote: >>> Cool. You did actually install the new scripts into your target >>> installation, right? >> Oh, is applying the patch and rebuilding PostgreSQL not enough? > Not unless you did "make install" in the contrib/earthdistance > directory (or something wider-scope that would invoke that). > > regards, tom lane Well, I did actually compile PostgreSQL after applying the patch.