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 1soMcX-00Aef3-Br for pgsql-admin@arkaria.postgresql.org; Wed, 11 Sep 2024 12:38:54 +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 1soMcW-00GiIN-JJ for pgsql-admin@arkaria.postgresql.org; Wed, 11 Sep 2024 12:38:52 +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 1soMcW-00GiIA-7l for pgsql-admin@lists.postgresql.org; Wed, 11 Sep 2024 12:38:52 +0000 Received: from mail-oi1-x232.google.com ([2607:f8b0:4864:20::232]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1soMcS-000e06-7M for pgsql-admin@lists.postgresql.org; Wed, 11 Sep 2024 12:38:51 +0000 Received: by mail-oi1-x232.google.com with SMTP id 5614622812f47-3e0438e81aaso2178884b6e.3 for ; Wed, 11 Sep 2024 05:38:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1726058327; x=1726663127; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=k9+Uwk+BFSM3Lo9ta2YRspiv9OSfLvz6InvUEgD/G00=; b=E1GRr2nVGXqkYFjVJ8pAJgrqDzBZ2rcGh5bJvIy8QTvJXUDPh1TjJK/jhLuLAVnD2z W7+HNvVq0P8BMt2HnXqZanUtuh9RJcTMl8ol6Gu1Aq3lDD3jG7KWLKyk3EQyeFqxTpxd 4dmui5ymB1j78ozZ5NHJiozMOcVUQo9JLzyRN/BrC1fu6g6FdVunlPM8mgMR1FvAM46l s/GgM8UUB3TzUuObhUD+IbEzshOFKui1yJma061zkdzynXJsYYxTh8Tk49f7AQqoVNdS RloG1MNnn2ET/UP0RO2hbb9kFk1m5DEUC9aZ6sVhFpYQEL+glVFdnwqeOzjO273jqaTE 8Eog== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726058327; x=1726663127; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=k9+Uwk+BFSM3Lo9ta2YRspiv9OSfLvz6InvUEgD/G00=; b=jvsDadMzDk7VOvFgr8JsbEoMIE0aXtHLEx3HKoTT1JuybQI/lxttUTrfv5MlNE20xG lLNSByECX3KGqUEtufZh4IFG+G+yT40L+2zCsyHLjZf3EulcdYYQeJLOz/KqmsTrfUUk xJrnv2hmiazZVK7Vuf8xTTzcqSp9m7KbJeFyMglm7UVm/y/xnXAZqqwmol5g9jJEvrdQ z4IYHQoLli/ohLmArerDV3z7ecOYvdEga9m0g54swIyjpK52HR/rtBxE8T4LKhwphcyg x4yLK9ONPKN5JnOF01hNz6hlARgjpJvG0hIHUrAU64Y06bzEoryboKd2+hswfRcomJE+ Ss8A== X-Gm-Message-State: AOJu0YzMwFwY5J3bUBWnXScCstJkaG79pCyB1V/TkPcaWbQKjKwHeX8n HyIFeVOEiuJrtb4hqxNWl3e5n8gu5rrpy8Uvq0USIMSDATfCE/4mKfg5GthfBGVJv/LHkm3/mJY EUAzRoD+5KRZoT7CdH6ao5tzIISNalMQV X-Google-Smtp-Source: AGHT+IGL2eLhsH/CidljKWCE7NCmt+beRmau4c/mHbkYjN1ixM4s95uc/G72gEaH0UArKqnycJjXr9+kduSP4Ko5EI0= X-Received: by 2002:a05:6808:2105:b0:3e0:67be:a24d with SMTP id 5614622812f47-3e067bea87bmr2507792b6e.9.1726058327457; Wed, 11 Sep 2024 05:38:47 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Wed, 11 Sep 2024 08:38:36 -0400 Message-ID: Subject: Re: Patching Postgres from 15.5 to 15.8 To: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000007845690621d745da" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007845690621d745da Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Sep 11, 2024 at 3:56=E2=80=AFAM P=C3=A4r Mattsson wrote: > Hi! > I have this packages on the server. > > [root@vidi-db02 pama]# dnf list installed | grep postgres > postgresql15.x86_64 15.5-1PGDG.rhel8 > @pgdg15 > postgresql15-libs.x86_64 15.5-1PGDG.rhel8 > @pgdg15 > postgresql15-server.x86_64 15.5-1PGDG.rhel8 > @pgdg15 > > > Is is okay to download > postgresql15-server-15.8-1PGDG.rhel8.x86_64.rpm > postgresql15-libs-15.8-1PGDG.rhel8.x86_64.rpm > postgresql15-15.8-1PGDG.rhel8.x86_64.rpm > > And apply them manually? > Sure. Why not? (Our Linux servers are firewalled from the Internet, and *They* won't open ports 80 and 443 just for me. Thus, every three months I manually download a bunch of RPM files from https://download.postgresql.org/pub/repos then do the OneDrive+scp dance to get them to the servers. "sudo yum install PgXX.YY_RHEL8/*rpm" works just perfectly. I've been doing it that way for years. A PowerShell script downloads the relevant packages so I don't have to do a lot of manual clicking and saving.) --=20 Death to America, and butter sauce. Iraq lobster! --0000000000007845690621d745da Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Sep 11, 2024 at 3:56=E2=80=AFAM P= =C3=A4r Mattsson <par.x.matt= sson@gmail.com> wrote:
=
Hi!=C2=A0
I have thi= s packages on the server.

[root@vidi-db02 pam= a]# dnf list installed | grep postgres
postgresql15.x86_64=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A015.5-1PGDG.rhel8=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 @pgdg15
postgres= ql15-libs.x86_64=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 15.5-1PGDG.rhel8=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 @pgdg15
postgre= sql15-server.x86_64=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 15.5-1PGDG.rhel8=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 @pgdg15

<= /div>

Is is okay to download
postgresql15-serv= er-15.8-1PGDG.rhel8.x86_64.rpm
postgresql15-libs-15.8-1PGDG.r= hel8.x86_64.rpm
postgresql15-15.8-1PGDG.rhel8.x86_64.rpm
<= /div>

And apply them manually?

Sure.=C2=A0 Why not?
<= br>
(Our Linux servers=C2=A0are firewalled from the Internet, and= They=C2=A0won't open ports 80 and 443 just for me.=C2=A0 Thus, = every three months I manually download a bunch of RPM files from=C2=A0https://download.postgresq= l.org/pub/repos then do the OneDrive+scp dance to get them to the serve= rs.=C2=A0 "sudo yum install PgXX.YY_RHEL8/*rpm" works just perfec= tly.=C2=A0 I've been doing it that way for years.

<= div>A PowerShell script downloads the relevant packages so I don't have= to do a lot of manual clicking and saving.)

--
Death to America, and butter sauce.
I= raq lobster!
--0000000000007845690621d745da--