Re: Patching Postgres from 15.5 to 15.8

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

On Wed, Sep 11, 2024 at 3:56 AM Pär Mattsson <par.x.mattsson@xxxxxxxxx> 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.)

--

Death to America, and butter sauce.

Iraq lobster!