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 1riX2C-0005Ni-29 for pgsql-general@arkaria.postgresql.org; Fri, 08 Mar 2024 10:01:00 +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 1riX2A-00BdAj-KI for pgsql-general@arkaria.postgresql.org; Fri, 08 Mar 2024 10:00:59 +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 1riX2A-00BdAb-8q for pgsql-general@lists.postgresql.org; Fri, 08 Mar 2024 10:00:58 +0000 Received: from ms-10.1blu.de ([178.254.4.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 1riX26-003SYf-Ih for pgsql-general@lists.postgresql.org; Fri, 08 Mar 2024 10:00:57 +0000 Received: from [212.222.85.178] (helo=pureos) by ms-10.1blu.de with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.95) (envelope-from ) id 1riX25-006cLV-OG; Fri, 08 Mar 2024 11:00:53 +0100 Date: Fri, 8 Mar 2024 11:00:52 +0100 From: Matthias Apitz To: Christophe Pettus Cc: pgsql-general@lists.postgresql.org Subject: Re: update to 16.2 Message-ID: Reply-To: Matthias Apitz References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: X-Operating-System: FreeBSD 14.0-CURRENT 1400094 (amd64) X-message-flag: Mails in HTML will not be read! Send only plain text. X-Con-Id: 51246 X-Con-U: 0-guru X-Originating-IP: 212.222.85.178 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk El día viernes, marzo 08, 2024 a las 12:56:16 -0800, Christophe Pettus escribió: > > > > On Mar 8, 2024, at 00:53, Matthias Apitz wrote: > > It does not say definitely that for all other versions a dump/restore is > > required. > > You cannot just replace the binaries to upgrade from an earlier major version to 16.X. The release notes use "a dump/restore (is/is not) required" to indicated whether you can just replace the binaries ("is not") and restart the server on the same database files. > I know we can't just switch the binaries and restart the server. We're compiling the PostgreSQL software by our own (even with some small changes in the C-code) and deliver the full tree as /usr/local/sisis-pap/pgsql-11.1 /usr/local/sisis-pap/pgsql-14.1 /usr/local/sisis-pap/pgsql-15.1 ... Also the migration path for customers is described and based on pg_dumpall, setup a new cluster fromm the above new version and load the dump with the new psql command into. The other option (pg_upgrade) we never used. matthias -- Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub I am not at war with Russia. Я не воюю с Россией. Ich bin nicht im Krieg mit Russland.