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 1qlUqR-0033qX-9L for pgsql-admin@arkaria.postgresql.org; Wed, 27 Sep 2023 13:44:51 +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 1qlUqP-004I97-Qt for pgsql-admin@arkaria.postgresql.org; Wed, 27 Sep 2023 13:44:49 +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 1qlUqP-004I8t-Et for pgsql-admin@lists.postgresql.org; Wed, 27 Sep 2023 13:44:49 +0000 Received: from mail-wr1-x433.google.com ([2a00:1450:4864:20::433]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qlUqI-006w27-Go for pgsql-admin@lists.postgresql.org; Wed, 27 Sep 2023 13:44:48 +0000 Received: by mail-wr1-x433.google.com with SMTP id ffacd0b85a97d-31f7400cb74so10094016f8f.2 for ; Wed, 27 Sep 2023 06:44:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1695822281; x=1696427081; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=/JZ1jHLWqp6+ceeDlv8eEtkxDCg7+DJJWYAFbMUQZSE=; b=GzhImY67dgEyANugYk8ODbFgJJFAPRKoOnuzCx1p7hFlfg7wjA0GpZcPaeEriWvmy4 6dTGk6dY1jsQNzN8iGxLPU2hnJubq1Vw3+pbzk34z75nk5pfnc1HJE2QmY6Zg3+fw0gL 9F6g2dOIdMgqHXXyRiNNOEMRmPCxLUMYQvPyEY8+qZa7yzQtSznJs8VXFZqHBD+o1Sh8 ehXrE/OT6oNsC8+zjXOP8Wpz07gFDwGe4wQzXUXnCXpPrMeQ2OLzi3uJBTl8uL9Fw2fk J9nl3xID2Yc0iPIiE2PU+XiLMRwTOsujgIoakq0rC+RfV+fd10iDqYddbpzZU9GFCvOh Rekw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1695822281; x=1696427081; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=/JZ1jHLWqp6+ceeDlv8eEtkxDCg7+DJJWYAFbMUQZSE=; b=GGHYAABAQ+EgCjP/r6K4aDSJs2ifpQmr8rzVjFQpUVm6O5z4ywewgBBioTs7hWoUX2 PVMEvNFkaGS51pqpWYvMK3tsrfsbNqQXocDR6rDekdgc/m1FP4wNMuJXYsJWNIMAhD2S g3yfa2OViSCnZ3EepMxOtjojjxg8IEvwB7Tx05j5cTZl/51J+nqlOyUip3/n5OAUPjea KzWb5efyBJ2Aqx9PEUNhI4H7ibArdnE2zl8XoJZH4HHjM22szEURZd5fZiHy+nD1WmY5 cS1en2Jet14WFEdwXzX/lneHuCgNL3ZALMbakGz/ADPeIxsyVqB86TTNEYSYAwRDrzVs TJeg== X-Gm-Message-State: AOJu0YyZKpMBBXmZ0mDGzGxMFdDAHRF65+iaGye++A6gfd7DplCOv0oa 2DwOJc2imN607GVYjBJGP/fhDOJq3IdSc5RBVpM= X-Google-Smtp-Source: AGHT+IHeYwnAbWZWrwCu0kVzfZctTUp6ixYsg9kcF+AnTrIShkM+75TmSmhGfnFbUF+WzmReZPL3EA== X-Received: by 2002:a5d:568e:0:b0:31f:bab8:a31a with SMTP id f14-20020a5d568e000000b0031fbab8a31amr1687640wrv.39.1695822280837; Wed, 27 Sep 2023 06:44:40 -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 c10-20020a5d4f0a000000b0031f3ad17b2csm17156795wru.52.2023.09.27.06.44.40 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 27 Sep 2023 06:44:40 -0700 (PDT) Message-ID: <62efa249b4e06a91856c380b065f5af7ca84c382.camel@cybertec.at> Subject: Re: Upgrade postgres 14.6 to minor version using source code From: Laurenz Albe To: Daulat Cc: pgsql-admin Date: Wed, 27 Sep 2023 15:44:39 +0200 In-Reply-To: References: <625c28dec5dc475aad665714d94eef74551cddc6.camel@cybertec.at> 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: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2023-09-27 at 14:41 +0530, Daulat wrote: > You mean, just we have to perform the below steps > download software=C2=A0,=C2=A0wget https://ftp.postgresql.org/pub/source/= v14.9/postgresql-14.9.tar.gz > sudo ./configure --prefix=3D/opt/PostgreSQL-14/ --with-openssl --exec-pre= fix=3D/opt/PostgreSQL-14/ --bindir=3D/opt/PostgreSQL-14/bin --with-ldap > make > make install Pretty much, yes. I'd delete the old software before I run "make install", so that no files are left behind. There should be no missing files in a minor update, but it cannot hurt. Yours, Laurenz Albe