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 1v1Ms7-007mMR-Ev for pgsql-general@arkaria.postgresql.org; Wed, 24 Sep 2025 10:37:15 +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 1v1Ms6-00CFoF-4L for pgsql-general@arkaria.postgresql.org; Wed, 24 Sep 2025 10:37:14 +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 1v1Ms5-00CFo7-Op for pgsql-general@lists.postgresql.org; Wed, 24 Sep 2025 10:37:13 +0000 Received: from mail-wm1-x336.google.com ([2a00:1450:4864:20::336]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v1Ms0-002buU-00 for pgsql-general@lists.postgresql.org; Wed, 24 Sep 2025 10:37:13 +0000 Received: by mail-wm1-x336.google.com with SMTP id 5b1f17b1804b1-45ed646b656so57671485e9.3 for ; Wed, 24 Sep 2025 03:37:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1758710223; x=1759315023; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=EyZuE4dBk7vkc3mBJyF66DpnrBvZCPJj6I/Brc0fXp8=; b=dN2ePbgviUZ5oyzEJmlGsMwCTpdwyzv0jOQW45P9jwmbC812CZPBMhXatrwdyIFHOQ qpC+kOCyVAkS7VUFcxXaZGcwtkWY0XsQOW4KjLyix3VWle7CVRjLu7NGtXdTCxbOtTYr pYXE54UAc4pLsgl88ninmgj2Y4XdixF39Cfzsrph6Zcj0/7HpU2BXKMw40Fwm5uWQypt Gxg1eBNiX7MOGyGxdyMcBatXV0wEN8yy1i8ryIgFGZL9m101dGqihKLGaAODWHPn1lKv mSiRul4XDCx+Aws5u7FLMDJ6OnMzhxPDpVD2YTMuupygECyFW5NF51KaUSCweAm9FjKL 53hA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758710223; x=1759315023; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=EyZuE4dBk7vkc3mBJyF66DpnrBvZCPJj6I/Brc0fXp8=; b=fqWOHMZWRSzEozSL6idL/DcW0yg3ZrT20FUd/2cwxcs7hHtOoyQ5ncXSKds0qVVc3J s0mDrrnE9s9WTJ5NbqJcR2fotssudfjEtdS/NqigocvqSDW6KKPimVQK1YAeBeEFjT6k JRWECDFl9WH6xwZWsdg4gW8xXhf1pH/hfKie/uJSZcNOgS/niDJRYE633LY+NWxvRynO IpkVLsUth+kAtdzZaSGFY1UqU1fz+PLfsUJ2apZMRbDHo+0rx+F341rpuFhUsK+lKTFf 4mE4viBJVqASAdXjc+yu3eu3X+JcHhy6BySxfQBuN+yAKxLGDpkL8EB2s+28eYX67z9Z FkEw== X-Forwarded-Encrypted: i=1; AJvYcCWcOOVTji3nACLDr4vjw6RleDUiwwobsVzDbW1WfJCoGzQzQ2RbX0VXv+6L3wLfGaOSEN3AJ4aXR1RrOr/q@lists.postgresql.org X-Gm-Message-State: AOJu0Yw0P1VLVZc1yzNGj+OhchNkucfC5RWcm0+Oy6VKh7rN25wyTztV 2j8a97MO6SL/kEp0YZ5i3Me2+spbbN40xeYW7sUol1Yb9ZKCTf5vSlg9u9q2fXDpsD0= X-Gm-Gg: ASbGnctf1pWfBPkFdBnJejHzARrwnFnUgV8V3TQjqzWWAKTP/7+EJvFmcyg9z8TcH5F 3s2CcsBeO14p3DzZ7e/+6tIfHBVb7+gGU8aZMtV+ERiXeKQqiollHdRM8F9wx24XrQACqEP2Uib IfBOgcrfkUbgtjcDyWMnkoWFlBjjiTFwAhzMp8CCJoqnlttQyZrqoZ/OCC4C/TOqzisC01nLhVB gB3MXkM5GqY2tL1AIQA+VnJLpzRsjaL3s/gZxy9nHwGBAPTjmMud3TpOOhEVRG3n27sTPIZbsaQ KTW+siYqws6ZwtFGrBWwNLjh6CS5gvFF8W1lYj41GmhkyNDh91zcL1ker7TubBha7LL0KtHXdDg C+P1Y6vVlmMs8S2zG5wbpsTelnmocrHhq9G5udrZY7Oe0nnDwSZLmM+ZpmbaNWSdz X-Google-Smtp-Source: AGHT+IHXiTCJ2MPAvMw7ZA9zQTkoIg/0bhUvkpw7R9BnJwctOPJF1FdqM7kLxv6FrXMGGv0w/z2vaw== X-Received: by 2002:a05:600c:1d0d:b0:45d:d1a3:ba6a with SMTP id 5b1f17b1804b1-46e1dac9d42mr53788645e9.33.1758710223319; Wed, 24 Sep 2025 03:37:03 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:b506:15eb:8d4f:1d7d:b92e]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-3ee141e9cf7sm27406525f8f.12.2025.09.24.03.37.02 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 24 Sep 2025 03:37:02 -0700 (PDT) Message-ID: Subject: Re: Query on Patch and Upgrade History in PostgreSQL From: Laurenz Albe To: loganathan P , pgsql-general@lists.postgresql.org Date: Wed, 24 Sep 2025 12:37:02 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2025-09-24 at 13:47 +0530, loganathan P wrote: > How do I find the date and time of applied minor patches and upgrades in = a PostgreSQL database level? This information is not stored inside the database. A minor upgrade just means replacing the files and restarting the server. If you are using a package manager, perhaps you can find the information th= ere. Yours, Laurenz Albe