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 1rmsWO-00ANRH-QN for pgsql-admin@arkaria.postgresql.org; Wed, 20 Mar 2024 09:46:09 +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 1rmsWN-00441v-7W for pgsql-admin@arkaria.postgresql.org; Wed, 20 Mar 2024 09:46:07 +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 1rmsWM-00441n-Sa for pgsql-admin@lists.postgresql.org; Wed, 20 Mar 2024 09:46:07 +0000 Received: from mail-wm1-x32c.google.com ([2a00:1450:4864:20::32c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rmsWI-005WYH-NB for pgsql-admin@lists.postgresql.org; Wed, 20 Mar 2024 09:46:06 +0000 Received: by mail-wm1-x32c.google.com with SMTP id 5b1f17b1804b1-4146bcff793so3740245e9.3 for ; Wed, 20 Mar 2024 02:46:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1710927961; x=1711532761; darn=lists.postgresql.org; h=user-agent:in-reply-to:content-disposition:mime-version:references :subject:cc:to:from:date:sender:message-id:from:to:cc:subject:date :message-id:reply-to; bh=OUYjXLZQ8hK56fIUezw8Rljkr2z6NABWzppVtciDrqM=; b=htESszp7ODeJqV09F+x4FtW9OmgssnL4g1DOsk2PyF2HgwQ9m3+wWmPFIU/+jCmLeJ xvKInapthCwG75nPCBiRHRScihQ1YA5Dvckj/eObKZr01xlmYnflQo9Ok2S+q6T3apPK LESbR1DkvLhkPl+h5CveIJqBV9GIlONBpGBAIpl5qL+zl6UhmEdTZmus9mBj80we/o6N S3neBV+HYuoK92MvmFD3uyQqKhLA4RxI4isss1oiKzJI4umBrUlfe7YlKdluIZaKMuk5 5HDj8nPRQwmLa3XF4DJ4hscBd0WB2dxW/ai5MXNzq4o0O/36eDuLrWJHCmpQpPcg9yLt ZR5Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1710927961; x=1711532761; h=user-agent:in-reply-to: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=OUYjXLZQ8hK56fIUezw8Rljkr2z6NABWzppVtciDrqM=; b=Po6dNONEIQZAoutX8NYN93UedMCFfVS3WcaUXj8MnWjcpjRYA81o+OK3DVSdeSiiA9 m4JU2wMki8J+r9WDtisAfHGoAx5yihHZ079dkR8GdGMsxYU9wPPQG+QhaNf3eW4xaRUA A4LP7nejePHZym8Bfeiy8mFSSlZj0r7GxVM0+YQjtq/1cgXz8IxEy3ImCzU90XUi6KMu z7YNrapNw7FkCihR/VOTWwO97D8D9ySdCNzgTUdES367C2eBAp9UDtReNNP8i7kWxHoy m7iMFp+ZN/wifFnNHO6AK3Ur7MAquwHL7H3L9unvx1CQkirypbU0Y6I+F3rP+3CBtDTe unCg== X-Forwarded-Encrypted: i=1; AJvYcCXFQqrT2MjX+8IM167brwhUlnzzM44IHfy3KTIV4dDUtkWrOrJGtXov4Ac+d9Zf/JbKOzQyoDQqReWdaHC8IARbFFg2dDf2cf56WKVSUh+uDg== X-Gm-Message-State: AOJu0Yz/1hPzkuOSsLlW0fznvQwcY0DXpAJiwIK0M94ECxqCMkxjxpUq WZ7g5CnVMKzfuAF+hCtWW2oJEx10i0hRA/wXsk8ourBFSbknAbBI X-Google-Smtp-Source: AGHT+IHET3+TaJqmZDV+cnw/btUpWeW4GtXmW6e3DZKV4oIQaahV6RCFTKXFQoEb/0AmpWGrHDzUWA== X-Received: by 2002:a5d:54c5:0:b0:33e:76d7:a8ad with SMTP id x5-20020a5d54c5000000b0033e76d7a8admr1078706wrv.38.1710927961484; Wed, 20 Mar 2024 02:46:01 -0700 (PDT) Received: from lightning.caipicrew.dd-dns.de ([2001:a61:a0e:9401:f815:e42b:c961:9a62]) by smtp.gmail.com with ESMTPSA id z18-20020adfec92000000b0033e7de97214sm14296929wrn.40.2024.03.20.02.46.01 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 20 Mar 2024 02:46:01 -0700 (PDT) Message-ID: <65fab059.df0a0220.e26b7.56c1@mx.google.com> X-Google-Original-Message-ID: <20240320094600.GD11539@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 1rmsWG-00088z-NU; Wed, 20 Mar 2024 10:46:00 +0100 Date: Wed, 20 Mar 2024 10:46:00 +0100 From: Michael Banck To: vignesh kumar Cc: Rajesh Kumar , Pgsql-admin Subject: Re: Validation of db post minor upgradation References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: 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, Mar 20, 2024 at 06:49:47AM +0000, vignesh kumar wrote: > Pg_upgrade should infact take care of the upgrade. That's why it's > better to do a pg_upgrade check before doing actual upgrade.. hope > this helps. pg_upgrade is for major upgrades. This thread is about minor/maintenance upgrades if I understood correctly. Michael