Provide packages for RHEL 8 and onwards

[JamesGuthrie]

With CentOS 8 being deprecated, our CentOS-based rpm build needs to be reworked for RHEL 8 and derivatives.

[b00ga]

+1 for EL8 (and should look to EL9 as well) packages.

I'm trying to setup Prometheus + node_exporter + postgresql 13 + timescaledb 2 + promscale and ran into this missing promscale_extension package issue. I'm having trouble working around it. Tried "just using" the EL7 package, but I don't think the extension is ever loading (learning how to debug extensions in pgsql).

If I can't find a way to make the EL7 package work, I may try compiling from source, but then I need to install a whole rust toolchain.

[b00ga]

I think I've worked out my issue loading the extension via basically:

dnf install -y https://packagecloud.io/timescale/timescaledb/packages/el/7/promscale-extension-postgresql-13-0.6.0-1.x86_64.rpm/download.rpm

Now I'm having issue with database permissions, but obviously that has nothing to do with the RPM install.

[nmaludy]

+1 We've been using Rocky Linux 8 and Rocky Linux 9 for our non-production workloads. This has been a perfect replacement and stepping stone for RHEL.

Look forward to seeing EL 8+ builds!

[b00ga]

Just checking in on the this issue. Still using my workaround as stated above on AlmaLinux 8 VMs, RHEL8 VMs and the Red hat Universal Base Image (UBI) 8 container with both PG13 and PG14.

Updated command line for PG14 and latest promscale_extension (0.7.0)

dnf install -y https://packagecloud.io/timescale/timescaledb/packages/el/7/promscale-extension-postgresql-14-0.7.0-1.x86_64.rpm/download.rpm

[JamesGuthrie]

I've added RHEL 8 and 9 support (based on Rocky) in #564. When we cut the next release, the packages should be published.