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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qlPiq-002gQg-7U
	for pgsql-admin@arkaria.postgresql.org; Wed, 27 Sep 2023 08:16:40 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qlPio-001ghh-Ep
	for pgsql-admin@arkaria.postgresql.org; Wed, 27 Sep 2023 08:16:38 +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 <laurenz.albe@cybertec.at>)
	id 1qlPio-001ghQ-2e
	for pgsql-admin@lists.postgresql.org; Wed, 27 Sep 2023 08:16:38 +0000
Received: from mail-wm1-x32d.google.com ([2a00:1450:4864:20::32d])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1qlPil-006tPG-9w
	for pgsql-admin@lists.postgresql.org; Wed, 27 Sep 2023 08:16:36 +0000
Received: by mail-wm1-x32d.google.com with SMTP id
 5b1f17b1804b1-405524e6768so83155865e9.2
        for <pgsql-admin@lists.postgresql.org>;
 Wed, 27 Sep 2023 01:16:35 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1695802594;
 x=1696407394; 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=i2TJczJlwrrNx5MqUyzUHCPyIA0DpOIdbaPhvvTNssY=;
        b=FcuTJNuAt1N2YFmeimcK5x29f1WISuSB4lbzfTg1kJ8RGUuM61Afj4QOCrctB+fm0G
         gMTRzatlrRcS7ucstVRBUvMIWJqSwQslGymXtJVkHI625xBtr/misNDlO05u3WdkwK1b
         UGpUzzE3bFmvIpnpK/V6W08HfpL2K8IoQFrN+EUM/BtODCISqOWNQJOVQ9CYNGVwekHc
         LSEVn8qvqDehB0IjBdGody46We9LZB4JPAxhsQboes+hZtBn8eCye2EeLh3anA5Bni1e
         GdfwE1VCfthLpQDuNlJ5v4wqfVGWij8v5SevBGoxjToY1ijwQujlbNnsn36zznJUuFjc
         HcsA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1695802594; x=1696407394;
        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=i2TJczJlwrrNx5MqUyzUHCPyIA0DpOIdbaPhvvTNssY=;
        b=L/GYL3s+9VebEjBaEeDhwLjEwiAV45OwMOkqDRxL4EW4PEjBaFrcjvCVNA1xIc02C0
         xeE7xEyfCChnnIzvKIgXgEc/igBo8Ui8FHk3lATw3B1RCParjRTyexgWaQZTMjZg9TSL
         dAvTu7pDcTXSmFEsH4bCFg6vjNAq9LAdIq47HL3zCdrRPPVcISEjcbJBbNaUlbE5+K4c
         q6/OC8fhpKT5DCUe+YsLhrqUxTYepqSiKK81HA5BzY+iss7pq2A5J9ninn9NOo7nRG9b
         x7udDofN/eB1PPVR4DHudBbtU7M6BTxNlarT6+Ejwk7JtTuXbY6G2RcM9JcmEC3RdjoT
         XURQ==
X-Gm-Message-State: AOJu0YyGqgaKyD3CV3SFOxx+SEW1gOuQ9Ic0H/WBH3nsgkPi/ea43E5q
	qfjhi3RiSfjmm92u2MNO2ib1P2PXBwGLDc82a14=
X-Google-Smtp-Source: 
 AGHT+IEAJRjHCZWosQfW03HgpvaosDUnaJzLAhJUqj1dnHD8eKHsHVBUEge1+snDY9Z8DfH78meq/g==
X-Received: by 2002:a05:6000:10d0:b0:323:1d6a:3952 with SMTP id
 b16-20020a05600010d000b003231d6a3952mr1255958wrx.4.1695802593744;
        Wed, 27 Sep 2023 01:16:33 -0700 (PDT)
Received: from localhost.localdomain (178-190-177-111.adsl.highway.telekom.at.
 [178.190.177.111])
        by smtp.gmail.com with ESMTPSA id
 p5-20020a5d4585000000b0031ad5470f89sm16519392wrq.18.2023.09.27.01.16.33
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Wed, 27 Sep 2023 01:16:33 -0700 (PDT)
Message-ID: <625c28dec5dc475aad665714d94eef74551cddc6.camel@cybertec.at>
Subject: Re: Upgrade postgres 14.6 to minor version using source code
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Daulat <daulat.dba@gmail.com>, pgsql-admin
	 <pgsql-admin@lists.postgresql.org>
Date: Wed, 27 Sep 2023 10:16:32 +0200
In-Reply-To: 
 <CALfOM6JpMbBfDPcOSc7qvVe4DQi5E9nAFjKkBUab71DY2PGh9g@mail.gmail.com>
References: 
	<CALfOM6JpMbBfDPcOSc7qvVe4DQi5E9nAFjKkBUab71DY2PGh9g@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) 
MIME-Version: 1.0
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/625c28dec5dc475aad665714d94eef74551cddc6.camel%40cybertec.at>
Precedence: bulk

On Wed, 2023-09-27 at 13:40 +0530, Daulat wrote:
> We are using the postgres 14.6 on Ubuntu that was installed=C2=A0via sour=
ce code (./configure) .
> Now we want to upgrade it to minor version 14.9. Please suggest,=C2=A0wha=
t is the process
> for upgrading the minor releases if postgres was installed using source c=
ode.

Simple: stop the server, install 14.9, then start the server with the new s=
oftware.

You should also read the release notes at
https://www.postgresql.org/docs/14/release-14-9.html#id-1.11.6.5.4
Sometimes there are additional things to consider.  However, since you are
upgrading from a release after 14.3, there is nothing more to do.

Yours,
Laurenz Albe