[PostgreSQL]package postgresql15-llvmjit-15.3-2PGDG.rhel8.x86_64 requires libLLVM-15.so()(64bit), but none of the providers can be installed

# AlmaLinux8において、PostgreSQLを15.3-2にアップデートできない

AlmaLinux8においてPostgreSQLを15.3-2にアップデートしようとしたところ、libLLVM-15.so()(64bit)がないとエラーがでました

```
# yum check-update
PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64                                           97  B/s | 195  B     00:02
PostgreSQL Supplementary ucommon RPMs for RHEL / Rocky 8 - x86_64                           106  B/s | 195  B     00:01
PostgreSQL 15 for RHEL / Rocky 8 - x86_64                                                    87  B/s | 195  B     00:02

postgresql15.x86_64                                              15.3-2PGDG.rhel8                                     pgdg15
postgresql15-contrib.x86_64                                      15.3-2PGDG.rhel8                                     pgdg15
postgresql15-docs.x86_64                                         15.3-2PGDG.rhel8                                     pgdg15
postgresql15-libs.x86_64                                         15.3-2PGDG.rhel8                                     pgdg15
postgresql15-llvmjit.x86_64                                      15.3-2PGDG.rhel8                                     pgdg15
postgresql15-plperl.x86_64                                       15.3-2PGDG.rhel8                                     pgdg15
postgresql15-plpython3.x86_64                                    15.3-2PGDG.rhel8                                     pgdg15
postgresql15-pltcl.x86_64                                        15.3-2PGDG.rhel8                                     pgdg15
postgresql15-server.x86_64                                       15.3-2PGDG.rhel8                                     pgdg15
```
```
# dnf update
AlmaLinux 8 - BaseOS                                                                        3.8 kB/s | 4.3 kB     00:01
AlmaLinux 8 - AppStream                                                                     5.6 kB/s | 4.8 kB     00:00
AlmaLinux 8 - Extras                                                                        5.1 kB/s | 4.3 kB     00:00
Error:
 Problem 1: package postgresql15-llvmjit-15.3-2PGDG.rhel8.x86_64 requires libLLVM-15.so()(64bit), but none of the providers can be installed
  - package postgresql15-llvmjit-15.3-2PGDG.rhel8.x86_64 requires libLLVM-15.so(LLVM_15)(64bit), but none of the providers can be installed
  - cannot install the best update candidate for package postgresql15-llvmjit-15.3-1PGDG.rhel8.x86_64
  - package llvm-libs-15.0.7-1.module_el8.8.0+3466+dfcbc058.x86_64 is filtered out by modular filtering
 Problem 2: problem with installed package postgresql15-llvmjit-15.3-1PGDG.rhel8.x86_64
  - package postgresql15-llvmjit-15.3-1PGDG.rhel8.x86_64 requires postgresql15-server(x86-64) = 15.3-1PGDG.rhel8, but none of the providers can be installed
  - cannot install both postgresql15-server-15.3-2PGDG.rhel8.x86_64 and postgresql15-server-15.3-1PGDG.rhel8.x86_64
  - package postgresql15-llvmjit-15.3-2PGDG.rhel8.x86_64 requires libLLVM-15.so()(64bit), but none of the providers can be installed
  - package postgresql15-llvmjit-15.3-2PGDG.rhel8.x86_64 requires libLLVM-15.so(LLVM_15)(64bit), but none of the providers can be installed
  - cannot install the best update candidate for package postgresql15-server-15.3-1PGDG.rhel8.x86_64
  - package llvm-libs-15.0.7-1.module_el8.8.0+3466+dfcbc058.x86_64 is filtered out by modular filtering
(try to add '--allowerasing' to command line to replace conflicting packages or '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)
```

## 環境
```
$ cat /etc/almalinux-release
AlmaLinux release 8.8 (Sapphire Caracal)
```

## 調べたこと
### 現在インストールされているllvmのバージョンとリポジトリを確認
```
# dnf list installed | grep llvm
llvm.x86_64                                   14.0.6-1.el8                                      @pgdg-centos8-sysupdates
llvm-libs.x86_64                              14.0.6-1.el8                                      @pgdg-centos8-sysupdates
postgresql11-llvmjit.x86_64                   11.19-1PGDG.rhel8                                 @pgdg11
postgresql15-llvmjit.x86_64                   15.3-1PGDG.rhel8                                  @pgdg15
```

### リポジトリpgdg-centos8-sysupdatesの場所を確認
```
# cat  /etc/yum.repos.d/pgdg-redhat-all.repo
#######################################################
# PGDG Red Hat Enterprise Linux / Rocky repositories  #
#######################################################

(中略)

[pgdg-centos8-sysupdates]
name=PostgreSQL Supplementary ucommon RPMs for RHEL / Rocky $releasever - $basearch
baseurl=https://download.postgresql.org/pub/repos/yum/common/pgdg-centos8-sysupdates/redhat/rhel-$releasever-$basearch
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
repo_gpgcheck = 1
```
https://download.postgresql.org/pub/repos/yum/common/pgdg-centos8-sysupdates/redhat/rhel-8-x86_64/
を確認
```
git-clang-format-11.0.0-1.el8.x86_64.rpm           18-May-2021 16:06               19712
llvm-10.0.1-3PGDG.el8.x86_64.rpm                   12-Nov-2020 22:18             4762300
llvm-11.0.0-2.el8.x86_64.rpm                       18-May-2021 12:41            12919200
llvm-12.0.1-2.el8.x86_64.rpm                       12-Nov-2021 13:37            16481076
llvm-13.0.1-1.el8.x86_64.rpm                       10-May-2022 11:30            17145500
llvm-14.0.6-1.el8.x86_64.rpm                       10-Nov-2022 19:26            17661228
llvm-debuginfo-10.0.1-3PGDG.el8.x86_64.rpm         12-Nov-2020 22:18            91759936
```
llvm-libs-15.0.7-1がない。

上のディレクトリを覗いてみて、https://download.postgresql.org/pub/repos/yum/common/pgdg-rocky9-sysupdates/redhat/rhel-9-x86_64/ を確認
```
git-clang-format-15.0.7-2.el9.x86_64.rpm           11-May-2023 02:08               15684
llvm-15.0.7-1.el9.x86_64.rpm                       10-May-2023 19:55            13994701
llvm-debuginfo-15.0.7-1.el9.x86_64.rpm             10-May-2023 19:55           124030437
```
llvm-libs-15.0.7-1がある。

そのうち、rhel-8-x86_64にも追加されるかな…と思うので待ちます。