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 1v1R4x-008eiS-0L for pgsql-general@arkaria.postgresql.org; Wed, 24 Sep 2025 15:06:47 +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 1v1R4v-00DosM-NL for pgsql-general@arkaria.postgresql.org; Wed, 24 Sep 2025 15:06:45 +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 1v1R4u-00DosD-Tc for pgsql-general@lists.postgresql.org; Wed, 24 Sep 2025 15:06:45 +0000 Received: from fout-b4-smtp.messagingengine.com ([202.12.124.147]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1v1R4s-002CUK-1E for pgsql-general@lists.postgresql.org; Wed, 24 Sep 2025 15:06:43 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfout.stl.internal (Postfix) with ESMTP id 986341D0012F; Wed, 24 Sep 2025 11:06:41 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-02.internal (MEProxy); Wed, 24 Sep 2025 11:06:41 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1758726401; x=1758812801; bh=GnltzlStFbzvzzHmpkvU8ClLJ36Ctk1qfqghYG66aqs=; b= lxzhG/+FRPXTB1+9TuW0gIsFGpgFxhRlz1G7qGxRBT3WKhoRzn3OdUkHto8c84JB Y6VYuatf8GYCpUtlIer9ePcE5uV4AgvdI7V3G0rDnfN5j2+Chul7IHbk5VKWq9Z+ gpN/jFJqCb0Jp5q9fUyNE+3Hrbe0F7NpI8Aa7udZVcFyPd/007njzHXrHxROjcM0 R4MK70qynozYjFqQycPVhs64+cOoOI2W71JCf3hJH1BvMsfcjvRikXWJGoOZoSBu AWvTfS1SiYljGntSSqKdn8alr3ps0AoWwqjasAle/j5QqzvPzyAV5VyIn/pgx3T1 EudD9Caacxngs+XbOr55kQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1758726401; x=1758812801; bh=G nltzlStFbzvzzHmpkvU8ClLJ36Ctk1qfqghYG66aqs=; b=jjL+kJj2tlzssknGo 3gOtmRnvQVrwzeRngp6gmQDN55yg1rb4kEmZYRX17BZUsRSy/M0i/hZWQXeVH8r2 TJRZx1QQtqSa1KSHeY2Nj2bCX0faFsstMuvn/dfa2rjUB0cOuK3RN4nyVs8ictVR xxP/JAn4Eik3u0FrfkXDV/7ZuKA3AysY7iOY8NRWKRZqB2ZyGltCqKjDW+1Ye0y7 Cl0SqhBKZTXNOgbw8KoGfCBUR5xwfxQKDk+NkWYt0mf97G9Lm1da3kVsTg11N6Ik imuSTX5lqQZoxBfdSz9NAzPKkvH0N4TALOLzqYwXUNAljOid4txem4VtXmc2r17D blUWQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggdeifeelfecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecunecujfgurhepkfffgggfuffvfhfhjggtgfesthejredttd dvjeenucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghv vghrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpeekfeehuddvjeeigf eifeejtdduudffledvfeelheeftdeiffeugfdvkeelgedtvdenucffohhmrghinhepphho shhtghhrvghsqhhlrdhorhhgnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpe hmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomhdp nhgspghrtghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepphhloh hgrghnuggsrgesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhgvghnvghr rghlsehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 24 Sep 2025 11:06:40 -0400 (EDT) Message-ID: Date: Wed, 24 Sep 2025 08:06:40 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Query on Patch and Upgrade History in PostgreSQL To: loganathan P , pgsql-general@lists.postgresql.org References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 9/24/25 01:17, loganathan P wrote: > > Dear All, > > How do I find the date and time of applied minor patches and upgrades in > a PostgreSQL database level? In addition to looking at package information, as others have mentioned, there is: https://git.postgresql.org/gitweb/?p=postgresql.git Click on a tag name for when the tag was created. If you click on the shortlog or log links next to the tag you get a list of the commits. > > Thanks. > > Regards, > Loganathan P > -- Adrian Klaver adrian.klaver@aklaver.com