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 1qXAtP-005Rww-Bd for pgsql-general@arkaria.postgresql.org; Sat, 19 Aug 2023 01:36:43 +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 1qXAtN-00EKp3-Ty for pgsql-general@arkaria.postgresql.org; Sat, 19 Aug 2023 01:36:42 +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 1qXAtN-00EKov-GN for pgsql-general@lists.postgresql.org; Sat, 19 Aug 2023 01:36:41 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qXAtK-000tuI-OK for pgsql-general@lists.postgresql.org; Sat, 19 Aug 2023 01:36:40 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Transfer-Encoding:Content-Type: Message-ID:Subject:To:From:Date:MIME-Version:Sender:Reply-To:Cc:Content-ID: Content-Description:In-Reply-To:References; bh=aEf6Eao4kVIuJEw0U4jK/iHnQsHVdlpSfe58w3u6ytg=; b=lWhFlgnhk313nsNsrC4rN1ROhq tCAcCLDPw9D1B68FsEVXu9TWLZZbC6MXt7Z5cXsOain56T+bN78fXQeYc9PsbiBkGUEsmKrOnMY51 fs2IPzq6Hbown9QpILCmOnTM4qyYE+2wNUEK9SLgqpTRFnoJMJrRH9Bz1o8U2mvpdriQJFoiIMy+O zp6FEjTCpCz0qEzBl9llpQnnghzpTXa53n/8Npgv83jF9cIg9WO08dowG9V5drgR3fFYibYpympUN /tqVqbVWZS5I/WcgcdtK+sIe7hLTfa8tHygYUJIop4MQ2YDWo2ZseXrdrP4BNuM9kLo8xxfn/Rva7 4JNhMQEw==; Received: from meldrar.postgresql.org ([87.238.57.231] helo=webmail.postgresql.org) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qXAtF-002MOm-OU for pgsql-general@lists.postgresql.org; Sat, 19 Aug 2023 01:36:37 +0000 MIME-Version: 1.0 Date: Sat, 19 Aug 2023 11:36:34 +1000 From: Justin Clift To: pgsql-general@lists.postgresql.org Subject: PG minor version in data directory? User-Agent: Roundcube Webmail/1.4.13 Message-ID: X-Sender: justin@postgresql.org Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hiyas, Anyone know if there's a good way to tell what *minor* version of PostgreSQL a data directory has been run with? eg 15.3 vs 15.4 Am working on some "automatic upgrade" stuff, and I'm only aware of the major version being tracked in PGDATA/PG_VERSION. If the minor version is already tracked somewhere as well, that would be extremely useful for my use case. Otherwise, I'll have to start manually adding info to track it. Regards and best wishes, Justin Clift