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 1rZYqP-005B6S-9S for pgsql-general@arkaria.postgresql.org; Mon, 12 Feb 2024 16:07:45 +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 1rZYqO-00Asgd-8G for pgsql-general@arkaria.postgresql.org; Mon, 12 Feb 2024 16:07:44 +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 1rZYqN-00AsgU-QT for pgsql-general@lists.postgresql.org; Mon, 12 Feb 2024 16:07:43 +0000 Received: from mout.gmx.net ([212.227.15.19]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rZYqJ-006pnT-EB for pgsql-general@lists.postgresql.org; Mon, 12 Feb 2024 16:07:42 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1707754058; x=1708358858; i=karsten.hilbert@gmx.net; bh=qXFhviYhqugnXRpCkw1HTipxWGzTVR4BHjlC+zV5UVg=; h=X-UI-Sender-Class:Date:From:To:Subject:References:In-Reply-To; b=cNZwrTeOowBqPYFFx9jL3jHXPXjHLaCbJeGyJ2YTyOheBVUiqO7T9nGG55pXe87e wv1iRqzhG1ZDf799QiRlCHo7zfEnUKww4cJc1qYIrY4VW3tufFfMjz1AErRzILsPT B1Pd1dr56b8Gm7VfgwUh9vDi55QiLvitqnxRidOb47ydFvJaAEK7jYDVUjAeiFiTX 1ynctG7OFBJemRNKTawed8gP8hLK2h2f+YVZOqCp/fql9k6OGY1BuG60BicR7pWzx JKCxc3jJITbLhBevyNxyZr9s/x/VH0NMBiw/tXBn2eMlvKyrFlTpvTkLNfUloPpy4 jjPuhQKgFNzweBoEyg== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from hermes ([88.117.178.2]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1M7sDg-1rdQSp3uPy-00511F for ; Mon, 12 Feb 2024 17:07:38 +0100 Received: from ncq by hermes with local (Exim 4.96) (envelope-from ) id 1rZYqS-00039t-00 for pgsql-general@lists.postgresql.org; Mon, 12 Feb 2024 17:07:48 +0100 Date: Mon, 12 Feb 2024 17:07:47 +0100 From: Karsten Hilbert To: pgsql-general@lists.postgresql.org Subject: Re: Safest pgupgrade jump distance Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:3BaKF1VZMfLz/xBSQG7bBUx/0RbfiurXsEgPLiVTCjdSvqURrDl asvuc9n96DmpP73bA7oGy30nY2+LUVaPqcuSeE4ob24KZytu5Za8ZFMv+9PQtNymEFMX1t/ Y63p9zhqRvuLFsyr/oS5Al7E8V3KTLutlRKl7Aui099G7rSEZZH4BDuObjSq8QcvV/K8XOT YewYMju/io8/uW5/WHfgw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:9sB03vTQIls=;BwM/pMM0sM3FkGjFdU67j2CqJjp 9Cn7CPGxFPlwSPuJ+odRkintS8kGiTj8gdXq7ubKPtXPWFes4rZEPnB5P5tO2lac0+r9IpxUj T956g+S7rUwOIUDyUlJCKFGWIzRSZDOeVUW3DdijbwhAuD47ghw9EZGdbkIEs2HfDciiQxdFf ewo7WzuXoXWJmMYz4dc1eQN6bKAlXJ3yUOLyGBT6N+UmQmRE8j6ZGv7zRnrD5hMYPah3HvqOw ItjcNmp4Twb96lkHcfy5son5+O6SE/LiotFhaQA2sNCD2npyYDAQ2AIB+90lM7euOHVs6U9rU fpiewSpvBO3zG90Pm2mxIhMYIdv7wmUXigz3wklEuaUCORLdtXncK56znKxyu8MilQRNTWM0J GjeQS32TippXnCh00sACmRblrOvzbPL2CG633gerkxv2lYIDF+yT0zEAYKEF28JgOAJPEn9oU GvvVtc4nM512x/Cht5+tc0HdUWPbXrq0enPZBzYtZ+gAxNlAj5UDkV4Ln87we91siFaS2Rhfx OErX9alPGoOX007n14pm2jckWZ5+/poCc55aS+jjRzZnqWI9WCkvd78+e5987LzG6lVLZFgMQ S5PcR445GyyV8X0nFtGVmxUh3ely6HASiXd7k44PUXPK0j0LmeIi6asSVg/unR94OtDeujZiS hwedj7rn+6uGGt+pHBpoiiq2N8DxDkKGOkrc3eudnogJoKgaXyKIxP/k1JoXV0c1uherr49DK H4SP/DabMmFZBNH4J5ZrwK8ZviaoRQF25TjEVEQkGq4Cts8JVzH+VU1D2FrYCMQSiWOpg5BFw 1VII3UR7/2bvyUTZX8cr2Urb6UNsknPXo9KuGeMn78Sjc= Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Mon, Feb 12, 2024 at 09:31:50AM -0500 schrieb Ron Johnson: > https://www.postgresql.org/docs/16/pgupgrade.html > "pg_upgrade supports upgrades from 9.2.X and later to the current major > release of PostgreSQL, including snapshot and beta releases." Just to be sure: it should be stressed that the binaries of the later version (16 in OPs case) should be used to run the upgrade, right ? Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B