From a.mantzios@cloud.gatewaynet.com Fri May 22 10:21:17 2026 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 1uof4D-007ih4-Ba for pgsql-admin@arkaria.postgresql.org; Wed, 20 Aug 2025 09:25:14 +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 1uof4C-006mz9-OO for pgsql-admin@arkaria.postgresql.org; Wed, 20 Aug 2025 09:25:13 +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 1uof4C-006mxj-DY for pgsql-admin@lists.postgresql.org; Wed, 20 Aug 2025 09:25:13 +0000 Received: from cloud.gatewaynet.com ([185.90.37.94]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uof4A-000ski-22 for pgsql-admin@lists.postgresql.org; Wed, 20 Aug 2025 09:25:12 +0000 Content-Type: multipart/alternative; boundary="------------SuEHoeVfE0wmk7yadyUUB80w" Message-ID: <09634814-40b4-4096-b48e-3ccffb64f872@cloud.gatewaynet.com> Date: Wed, 20 Aug 2025 10:25:08 +0100 MIME-Version: 1.0 Content-Language: en-US To: pgsql-admin@lists.postgresql.org From: Achilleas Mantzios Subject: upgrade from 18beta1 to 18beta3 gives : FATAL: database files are incompatible with server List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------SuEHoeVfE0wmk7yadyUUB80w Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hi for the sake of answering here : https://www.postgresql.org/message-id/48a32f45-57f2-4560-ae94-3488b3568c8a%40cloud.gatewaynet.com (although I didn't find anything indicating any hope for any change regarding my deadlock), it seems I am unable to binary upgrade from 18beta1 to 18beta3 the traditional easy way between minor releases. After : make install , it gives postgres@smadevnu:~ % pg_ctl -D data restart waiting for server to shut down...... done server stopped waiting for server to start.... [15615] 68a5918b.3cff 2025-08-20 12:12:43.679 EEST @ line:1 FATAL: database files are incompatible with server [15615] 68a5918b.3cff 2025-08-20 12:12:43.679 EEST @ line:2 DETAIL: The database cluster was initialized with CATALOG_VERSION_NO 202504091, but the server was compiled with CATALOG_VERSION_NO 20250629 1. [15615] 68a5918b.3cff 2025-08-20 12:12:43.679 EEST @ line:3 HINT: It looks like you need to initdb. [15615] 68a5918b.3cff 2025-08-20 12:12:43.679 EEST @ line:4 LOG: database system is shut down stopped waiting pg_ctl: could not start server Examine the log output. Is the catalog version indeed different between 18beta1 and 18beta3 ? --------------SuEHoeVfE0wmk7yadyUUB80w Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

Hi for the sake of answering here : https://www.postgresql.org/message-id/48a32f45-57f2-4560-ae94-3488b3568c8a%40cloud.gatewaynet.com (although I didn't find anything indicating any hope for any change regarding my deadlock), it seems I am unable to binary upgrade from 18beta1 to 18beta3 the traditional easy way between minor releases. After : make install , it gives

postgres@smadevnu:~ % pg_ctl -D data restart
waiting for server to shut down...... done
server stopped
waiting for server to start.... [15615] 68a5918b.3cff 2025-08-20 12:12:43.679 EEST @ line:1 FATAL: database files are incompatible with server
[15615] 68a5918b.3cff 2025-08-20 12:12:43.679 EEST @ line:2 DETAIL: The database cluster was initialized with CATALOG_VERSION_NO 202504091, but the server was compiled with CATALOG_VERSION_NO 20250629
1.
[15615] 68a5918b.3cff 2025-08-20 12:12:43.679 EEST @ line:3 HINT: It looks like you need to initdb.
[15615] 68a5918b.3cff 2025-08-20 12:12:43.679 EEST @ line:4 LOG: database system is shut down
stopped waiting
pg_ctl: could not start server
Examine the log output.

Is the catalog version indeed different between 18beta1 and 18beta3 ?

--------------SuEHoeVfE0wmk7yadyUUB80w-- From mbanck@gmx.net Fri May 22 10:21:17 2026 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 1uofQZ-007rPH-9n for pgsql-admin@arkaria.postgresql.org; Wed, 20 Aug 2025 09:48:20 +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 1uofQX-006xrb-Rb for pgsql-admin@arkaria.postgresql.org; Wed, 20 Aug 2025 09:48:18 +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 1uofQX-006xrS-Fq for pgsql-admin@lists.postgresql.org; Wed, 20 Aug 2025 09:48:18 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uofQV-000svU-2R for pgsql-admin@lists.postgresql.org; Wed, 20 Aug 2025 09:48:17 +0000 Received: by mail-wm1-x32b.google.com with SMTP id 5b1f17b1804b1-45a286135c8so3765745e9.0 for ; Wed, 20 Aug 2025 02:48:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1755683295; x=1756288095; darn=lists.postgresql.org; h=user-agent:in-reply-to:content-transfer-encoding :content-disposition:mime-version:references:subject:cc:to:from:date :sender:message-id:from:to:cc:subject:date:message-id:reply-to; bh=Pt6p7H6DlX2umAcB+3uJH/LL67NxHyNkJil3rlI0xms=; b=U7UbLCjrQDp58JyTjPlWE3/DrTX5Be0vCoAwROswsS8YGcG+tqBF5T1p9VUbAWxReB kbZmZP1Y6xRfcTVzY/64BXPCq4wy8pvbQye1p5bwvmxxq0AwFjNzndHwvA4nE6EmYT2v sC6wMnbloWLkd9sy39lGdJVNwmji7nukI5r+KpUGC75guWExa/cFMT8xdYEFKEDt8Hcx QrfTzcE3BQhzFABxiYWA8PMwqye7JIcpvL93Lvu9ppIaRTy9OzFa2d3br1ZjW0E5IEg/ 9bJ3WBagxZ0siCEgt/j/UYCWzGQTL93LaoOsQDY3aLWbvqgrHLlVaaD9s9UO6BMgOWTi HxTQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755683295; x=1756288095; h=user-agent:in-reply-to:content-transfer-encoding :content-disposition:mime-version:references:subject:cc:to:from:date :sender:message-id:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=Pt6p7H6DlX2umAcB+3uJH/LL67NxHyNkJil3rlI0xms=; b=m2qQKShTiNImdGotqy/FBL6SEKAdls2e+p17zOmuH7z/vcMjFq3eRZS2xNBuhQCL4P DYUPjVsCtXs7H0ZrtuPbDV4Izdtb+gjDB+qGglhObqwY7ZogDwIiV5JOVSyhaHH9F73B F/CpbbRz1Xekxq4iazE4CXqSxt7kQ9GyodTfT83wBvyyhEPeNRrFi8lPhzSODqJXHNeL To6IGAmlFO8oL+e9DER/Y2rg+Fj0wigbgsuMTuTrE/G3Ty6CBuuj72QC84r1KXoetWOc cXDZ0RH++f/oBN7PHHOQDtsfZlnphcDoW8g3hTDQMxakwZY0w7yLbbieM1ZO3BCZy4Jf selA== X-Gm-Message-State: AOJu0YweV3Y+IQ7/aOOiMLze++zexVLqt3vtfHcxCW9Zkv7cB+iXW6IA f7IruDr/mlJwabmzTlETwOAulfTA+HvQM1P8Gmq9PG68Hl5vQBUiJtzt X-Gm-Gg: ASbGncvd3ikafl0OJ9P5z2k6YLXBwAFTeuuq0ATttx5DDof9lSl4l/eS1ZFnTuxkksv qoa48VgvEJVzoU9yINOW9KoU4SPcK8qpQ0johWZxtQ1XEzGqhTblc67YHSg0PMTggk3lXjAB+pZ 86e2pL7FLgsaZVEdLC/OFyrwYV0ZYmaMFH/unAc7XmaeTfPC79d+eripPYdgXxaUB+B8wEpV3mT SnHq4z+OJSo7xrvQ2ki3QJzOC4PdL0Abrl1vHA9xF3LECkwCOQCuKbfuVAa4DHsfmM7S+J/g5bP Nm1BRyLmY1IAbRQBujZy7MIOnEBxwGtJ5+BGtRX+xNZNufmA6H/1g6BjflU1efT+G6m6wwQ3q+U A3xJNNTwsv2ASBd7boMmEAKtkx6GhjR8NZyuiSIxPqkbr1lOSN9QY98UCsSLnnyGi1JXZ X-Google-Smtp-Source: AGHT+IFklzM8Bs6haHEqK/bz2K2x5BRMQusUxr8L4MnRr7Za1Ds6gqiQ51pnBaz6zM6OOeRagqPEBw== X-Received: by 2002:a05:600c:8592:b0:456:15be:d113 with SMTP id 5b1f17b1804b1-45b446eb150mr35783875e9.1.1755683294505; Wed, 20 Aug 2025 02:48:14 -0700 (PDT) Received: from lightning.caipicrew.dd-dns.de ([2001:a61:103d:2901:820b:90ac:99bb:1af7]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-45b47c29b78sm25167195e9.1.2025.08.20.02.48.13 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 20 Aug 2025 02:48:13 -0700 (PDT) Message-ID: <68a599dd.050a0220.24b0ae.620b@mx.google.com> X-Google-Original-Message-ID: <20250820094812.GA4610@caipicrew.dd-dns.de;lightning.caipicrew.dd-dns.de> Sender: Michael Banck Received: from mbanck by lightning.caipicrew.dd-dns.de with local (Exim 4.92) (envelope-from ) id 1uofQT-00062W-91; Wed, 20 Aug 2025 11:48:13 +0200 Date: Wed, 20 Aug 2025 11:48:13 +0200 From: Michael Banck To: Achilleas Mantzios Cc: pgsql-admin@lists.postgresql.org Subject: Re: upgrade from 18beta1 to 18beta3 gives : FATAL: database files are incompatible with server References: <09634814-40b4-4096-b48e-3ccffb64f872@cloud.gatewaynet.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <09634814-40b4-4096-b48e-3ccffb64f872@cloud.gatewaynet.com> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Wed, Aug 20, 2025 at 10:25:08AM +0100, Achilleas Mantzios wrote: > 12:12:43.679 EEST �@ line:1 FATAL: �database files are incompatible with > server > [15615] 68a5918b.3cff 2025-08-20 12:12:43.679 EEST �@ line:2 DETAIL: �The > database cluster was initialized with CATALOG_VERSION_NO 202504091, but the > server was compiled with CATALOG_VERSION_NO 20250629 > 1. > [15615] 68a5918b.3cff 2025-08-20 12:12:43.679 EEST �@ line:3 HINT: �It looks > like you need to initdb. > > Is the catalog version indeed different between 18beta1 and 18beta3 ? Yes, that is correct, you will need to do a migration. Postgres only guarantees catalog stability after the first stable release (but usually at least the release candidates no longer change the catalog). Michael From a.mantzios@cloud.gatewaynet.com Fri May 22 10:21:18 2026 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 1uogTA-008B7r-PU for pgsql-admin@arkaria.postgresql.org; Wed, 20 Aug 2025 10:55: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 1uogTA-007RPd-4t for pgsql-admin@arkaria.postgresql.org; Wed, 20 Aug 2025 10:55:04 +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 1uogT9-007RPV-QD for pgsql-admin@lists.postgresql.org; Wed, 20 Aug 2025 10:55:04 +0000 Received: from cloud.gatewaynet.com ([185.90.37.94]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uogT8-000tXh-0w for pgsql-admin@lists.postgresql.org; Wed, 20 Aug 2025 10:55:04 +0000 Message-ID: Date: Wed, 20 Aug 2025 11:54:59 +0100 MIME-Version: 1.0 Subject: Re: upgrade from 18beta1 to 18beta3 gives : FATAL: database files are incompatible with server To: Michael Banck Cc: pgsql-admin@lists.postgresql.org References: <09634814-40b4-4096-b48e-3ccffb64f872@cloud.gatewaynet.com> <68a599dd.050a0220.24b0ae.620b@mx.google.com> Content-Language: en-US From: Achilleas Mantzios In-Reply-To: <68a599dd.050a0220.24b0ae.620b@mx.google.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 8/20/25 10:48, Michael Banck wrote: > Hi, > > On Wed, Aug 20, 2025 at 10:25:08AM +0100, Achilleas Mantzios wrote: >> 12:12:43.679 EEST @ line:1 FATAL: database files are incompatible with >> server >> [15615] 68a5918b.3cff 2025-08-20 12:12:43.679 EEST @ line:2 DETAIL: The >> database cluster was initialized with CATALOG_VERSION_NO 202504091, but the >> server was compiled with CATALOG_VERSION_NO 20250629 >> 1. >> [15615] 68a5918b.3cff 2025-08-20 12:12:43.679 EEST @ line:3 HINT: It looks >> like you need to initdb. >> >> Is the catalog version indeed different between 18beta1 and 18beta3 ? > Yes, that is correct, you will need to do a migration. Postgres only > guarantees catalog stability after the first stable release (but usually > at least the release candidates no longer change the catalog). ok, thanks, makes sense. > > Michael