public inbox for [email protected]
help / color / mirror / Atom feedPatching Postgres from 15.5 to 15.8
4+ messages / 3 participants
[nested] [flat]
* Patching Postgres from 15.5 to 15.8
@ 2024-09-11 07:55 Pär Mattsson <[email protected]>
2024-09-11 08:27 ` Re: Patching Postgres from 15.5 to 15.8 Asad Ali <[email protected]>
2024-09-11 12:38 ` Re: Patching Postgres from 15.5 to 15.8 Ron Johnson <[email protected]>
0 siblings, 2 replies; 4+ messages in thread
From: Pär Mattsson @ 2024-09-11 07:55 UTC (permalink / raw)
To: Pgsql-admin <[email protected]>
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?
BR Pär
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Patching Postgres from 15.5 to 15.8
2024-09-11 07:55 Patching Postgres from 15.5 to 15.8 Pär Mattsson <[email protected]>
@ 2024-09-11 08:27 ` Asad Ali <[email protected]>
2024-09-11 12:41 ` Re: Patching Postgres from 15.5 to 15.8 Ron Johnson <[email protected]>
1 sibling, 1 reply; 4+ messages in thread
From: Asad Ali @ 2024-09-11 08:27 UTC (permalink / raw)
To: Pär Mattsson <[email protected]>; +Cc: Pgsql-admin <[email protected]>
Hi Pär,
Yes, it is okay to download and apply the packages you mentioned manually.
However, I recommend that you first take a backup of your existing
PostgreSQL data before proceeding.
If you have any further questions, please do not hesitate to contact me.
Best regards,
Asad Ali
On Wed, Sep 11, 2024 at 12:56 PM Pär Mattsson <[email protected]>
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?
> BR Pär
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Patching Postgres from 15.5 to 15.8
2024-09-11 07:55 Patching Postgres from 15.5 to 15.8 Pär Mattsson <[email protected]>
2024-09-11 08:27 ` Re: Patching Postgres from 15.5 to 15.8 Asad Ali <[email protected]>
@ 2024-09-11 12:41 ` Ron Johnson <[email protected]>
0 siblings, 0 replies; 4+ messages in thread
From: Ron Johnson @ 2024-09-11 12:41 UTC (permalink / raw)
To: Pgsql-admin <[email protected]>
On Wed, Sep 11, 2024 at 4:28 AM Asad Ali <[email protected]> wrote:
> Hi Pär,
>
> Yes, it is okay to download and apply the packages you mentioned manually.
> However, I recommend that you first take a backup of your existing
> PostgreSQL data before proceeding.
>
1. OP should be backing up anyway.
2. PgBackRest (and probably others, like barman, wal-e, etc) does
"continual backups".
Thus, no need to take a pre-update backup.
--
Death to America, and butter sauce.
Iraq lobster!
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Patching Postgres from 15.5 to 15.8
2024-09-11 07:55 Patching Postgres from 15.5 to 15.8 Pär Mattsson <[email protected]>
@ 2024-09-11 12:38 ` Ron Johnson <[email protected]>
1 sibling, 0 replies; 4+ messages in thread
From: Ron Johnson @ 2024-09-11 12:38 UTC (permalink / raw)
To: Pgsql-admin <[email protected]>
On Wed, Sep 11, 2024 at 3:56 AM Pär Mattsson <[email protected]>
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!
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-09-11 12:41 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-11 07:55 Patching Postgres from 15.5 to 15.8 Pär Mattsson <[email protected]>
2024-09-11 08:27 ` Asad Ali <[email protected]>
2024-09-11 12:41 ` Ron Johnson <[email protected]>
2024-09-11 12:38 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox