PostgreSQL › PostgreSQL - general

yum update for postgresql rpms

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

4 messages Options

Haas, Scott

yum update for postgresql rpms

RHEL 7.9

PostgreSQL 12 (12.5.1 to 12.6.1)

I am updating RPMs for postgres and was interested to know whether this is indeed expected behavior for the rpm update:

When the "yum update" is executed, postgresql rpms are updated. It looks at that point, postgresql (postmaster) processes automatically restart. In the procedure I was building, I figured I'd need to stop/start postgres (systemctl stop postgresql-12, systemctl start postgresql-12), but that doesn't look to be necessary.

I don't recall this automatic postmaster restart occurring a few weeks ago when I went from 12.4.1 to 12.5.1 - perhaps it did, but I just stopped/re-started postgres unnecessarily.

Thanks,

Scott

Scott Haas

Enterprise Applications

[hidden email]
814-863-3526
https://keybase.io/sah209

Haas, Scott

Re: yum update for postgresql rpms

Tickling this thread to see if I can get a confirmation of the described behavior for rpm update via yum.

I do not want to cross-post (but if this is not the correct forum, please let me know).

Thanks,

Scott

From: Haas, Scott
Sent: Thursday, February 18, 2021 11:23 AM
To: [hidden email] <[hidden email]>
Subject: yum update for postgresql rpms

RHEL 7.9

PostgreSQL 12 (12.5.1 to 12.6.1)

I am updating RPMs for postgres and was interested to know whether this is indeed expected behavior for the rpm update:

I don't recall this automatic postmaster restart occurring a few weeks ago when I went from 12.4.1 to 12.5.1 - perhaps it did, but I just stopped/re-started postgres unnecessarily.

Thanks,

Scott

Scott Haas

Enterprise Applications

[hidden email]
814-863-3526
https://keybase.io/sah209

Ron-2

Re: yum update for postgresql rpms

It's standard procedure for package managers to stop daemons before update and then start them back up afterward.

On 2/23/21 8:22 AM, Haas, Scott wrote:

Tickling this thread to see if I can get a confirmation of the described behavior for rpm update via yum.

I do not want to cross-post (but if this is not the correct forum, please let me know).

Thanks,

Scott

From: Haas, Scott
Sent: Thursday, February 18, 2021 11:23 AM
To: [hidden email] [hidden email]
Subject: yum update for postgresql rpms
RHEL 7.9

PostgreSQL 12 (12.5.1 to 12.6.1)

I am updating RPMs for postgres and was interested to know whether this is indeed expected behavior for the rpm update:

When the "yum update" is executed, postgresql rpms are updated. It looks at that point, postgresql (postmaster) processes automatically restart. In the procedure I was building, I figured I'd need to stop/start postgres (systemctl stop postgresql-12, systemctl start postgresql-12), but that doesn't look to be necessary.

I don't recall this automatic postmaster restart occurring a few weeks ago when I went from 12.4.1 to 12.5.1 - perhaps it did, but I just stopped/re-started postgres unnecessarily.

Thanks,

Scott
--

Scott Haas

Enterprise Applications
[hidden email]
814-863-3526
https://keybase.io/sah209

--
Angular momentum makes the world go 'round.

Devrim GÜNDÜZ

Re: yum update for postgresql rpms

In reply to this post by Haas, Scott

Hi,

On Thu, 2021-02-18 at 16:23 +0000, Haas, Scott wrote:

> RHEL 7.9
> PostgreSQL 12 (12.5.1 to 12.6.1)
>
> I am updating RPMs for postgres and was interested to know whether
> this is indeed expected behavior for the rpm update:
>
> When the "yum update" is executed, postgresql rpms are updated. It
> looks at that point, postgresql (postmaster) processes automatically
> restart. In the procedure I was building, I figured I'd need to
> stop/start postgres (systemctl stop postgresql-12, systemctl start
> postgresql-12), but that doesn't look to be necessary.
>
> I don't recall this automatic postmaster restart occurring a few
> weeks ago when I went from 12.4.1 to 12.5.1 - perhaps it did, but I
> just stopped/re-started postgres unnecessarily.

That is the behaviour since 15 years :)

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

signature.asc (849 bytes) Download Attachment