RPMs missing for RHEL PGDG 17 repos

[chris-gooch]

Unable to install powa from PGDG 17 redhat repos.

Please can you publish v5 versions

[rjuju]

hi,

Unfortunately this isn't something we can do ourselves.

@devrimgunduz any info? FTR powa-archivist 5.0.0 was released some time ago and powa-web 5.0.1 was release last weekend

[chris-gooch]

Hi, any progress on this? @rjuju not sure if @devrimgunduz gets notified here as not showing as an option for me

[devrimgunduz]

They are in the oven. Will be out in less than an hour.

[rjuju]

Thanks a lot @devrimgunduz !

[devrimgunduz]

Packages are out for RHEL (x86_64). Fedora and SLES packages will be out later in the day.

[MichaelDBA]

I downloaded and installed the latest PGDG binaries forCentOS 8 stream:

wget https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum install pgdg-redhat-repo-latest.noarch.rpm
yum update cache

but I still don't see binary package for Powa for PostgreSQL version 17.

[rjuju]

I don't think that centos stream is supported by the PGDG repository, as far as I know centos was entirely dropped after centos 7. The usual alternative is rocky linux.

[MichaelDBA]

PGDG is supported on my CentOS 8 Stream host with:
https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest

Everything in PG is there up to and including PG16.

It seems starting with PG17, I have to get them directly from here for CentOS 8:
https://download.postgresql.org/pub/repos/yum/17/redhat/rhel-8-x86_64/

Maybe note that somewhere to help other folks out.

[rjuju]

The issue probably exist for all other extensions, as powa-archivist doesn't really do anything different from other. The page at https://yum.postgresql.org/packages/, while not explicitly mentioning it, only mentions centos up to version 7, and not above. I'm not really an rpm-based distro user, but as I understand it it means that centos stream is not officially supported by the PGDG. That unfortunately means that if you wish to keep using centos stream it's up to you to make it work, and probably accept that at some point the packages may not work at all anymore.

[devrimgunduz]

PGDG is supported on my CentOS 8 Stream host with: https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest

Everything in PG is there up to and including PG16.

It seems starting with PG17, I have to get them directly from here for CentOS 8: https://download.postgresql.org/pub/repos/yum/17/redhat/rhel-8-x86_64/

Maybe note that somewhere to help other folks out.

Hi @MichaelDBA ,

CentOS Stream is not supported. It is not tested and won't be tested due to the nature of the distro. "It works for me" does not mean that it is supported.

Devrim - the maintainer :-)

[devrimgunduz]

The issue probably exist for all other extensions, as powa-archivist doesn't really do anything different from other. The page at https://yum.postgresql.org/packages/, while not explicitly mentioning it, only mentions centos up to version 7, and not above. I'm not really an rpm-based distro user, but as I understand it it means that centos stream is not officially supported by the PGDG. That unfortunately means that if you wish to keep using centos stream it's up to you to make it work, and probably accept that at some point the packages may not work at all anymore.

Exactly.

[devrimgunduz]

FWIW this is on RHEL/Rocky 8.

[MichaelDBA]

I'm kinda confused, since I can still find packages for CentOS 8 and 9 for using this link:
download.postgresql.org/pub/repos/yum/17/redhat/

Who is maintaining this?