Learn about Centmin Mod LEMP Stack today
Become a Member

PostgreSQL won't install

Discussion in 'Bug Reports' started by mrkip, Oct 25, 2021.

  1. mrkip

    mrkip New Member

    17
    14
    3
    Jan 29, 2019
    Ratings:
    +19
    Local Time:
    1:01 PM
    Think I've found an issue with PostgreSQL installation process.

    My custom.conf is the following:
    Code:
    POSTGRESQL='y'
    LETSENCRYPT_DETECT='y'
    And I've then proceeded to recompile PHP.

    The process seems to halt when the script tries to import the GPG keys. So I think it's a repo issue.


    Here's some further info:
    Code:
    warning: /svr-setup/pgdg-redhat-repo-latest.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
    Preparing...                          ########################################
    Updating / installing...
    pgdg-redhat-repo-42.0-20              ########################################
    ls: cannot access /etc/yum.repos.d/pgdg-13-redhat.repo: No such file or directory
    cat: /etc/yum.repos.d/pgdg-13-redhat.repo: No such file or directory
    
    Loaded plugins: fastestmirror, versionlock
    Loading mirror speeds from cached hostfile
     * base: mirror.netsite.dk
     * centos-sclo-rh: mirrors.xtom.de
     * centos-sclo-sclo: mirror.netsite.dk
     * epel: mirrors.coreix.net
     * extras: mirror.netsite.dk
     * updates: mirror.23m.com
    Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
    Importing GPG key 0x442DF0F8:
     Userid     : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"
     Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
     Package    : pgdg-redhat-repo-42.0-20.noarch (installed)
     From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
    
    https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-7-x86_64/repodata/repomd.xml: [Errno -1] Gpg Keys not imported, cannot verify repomd.xml for repo pgdg-common
    Trying other mirror.
    
    
     One of the configured repositories failed (PostgreSQL common RPMs for RHEL/CentOS 7 - x86_64),
     and yum doesn't have enough cached data to continue. At this point the only
     safe thing yum can do is fail. There are a few ways to work "fix" this:
    
         1. Contact the upstream for the repository and get them to fix the problem.
    
         2. Reconfigure the baseurl/etc. for the repository, to point to a working
            upstream. This is most often useful if you are using a newer
            distribution release than is supported by the repository (and the
            packages for the previous distribution release still work).
    
         3. Run the command with the repository temporarily disabled
                yum --disablerepo=pgdg-common ...
    
         4. Disable the repository permanently, so yum won't use it by default. Yum
            will then just ignore the repository until you permanently enable it
            again or use --enablerepo for temporary usage:
    
                yum-config-manager --disable pgdg-common
            or
                subscription-manager repos --disable=pgdg-common
    
         5. Configure the failing repository to be skipped, if it is unavailable.
            Note that yum will try to contact the repo. when it runs most commands,
            so will have to try and fail each time (and thus. yum will be be much
            slower). If it is a very temporary problem though, this is often a nice
            compromise:
    
                yum-config-manager --save --setopt=pgdg-common.skip_if_unavailable=true
    
    failure: repodata/repomd.xml from pgdg-common: [Errno 256] No more mirrors to try.
    https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-7-x86_64/repodata/repomd.xml: [Errno -1] Gpg Keys not imported, cannot verify repomd.xml for repo pgdg-common
    Is this ok [y/N]:
    real    8m22.416s
    user    0m0.366s
    sys     0m0.109s
    I'm currently playing about with this on a test VPS. So if you want me to try anything out feel free to make suggestions. I'm not too fussed about borking my server and having to reinstall it again.
     
  2. eva2000

    eva2000 Administrator Staff Member

    54,368
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    11:01 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  3. mrkip

    mrkip New Member

    17
    14
    3
    Jan 29, 2019
    Ratings:
    +19
    Local Time:
    1:01 PM
    No worries mate:) I understand you've got a lot on your plate ATM, and I'm happy to wait for a fix.

    PS: I wish your mum a speedy recovery.

    Best,
     
  4. MaximilianKohler

    MaximilianKohler Member

    197
    5
    18
    Jun 23, 2023
    Ratings:
    +29
    Local Time:
    5:01 AM
    Hmm, this was back in 2021. I just tried to upgrade php from 8.1.27 to 8.2.15 since Xenforo just updated their recommendation to php 8.2 and it froze on me in the same spot. But I didn't get the extra info that the OP did. It's just frozen on "Importing GPG key".

    "Command+C" doesn't exit. The only way to exit seems to be closing the Putty window.

    My php_upgrade.log doesn't have anything more than what was shown on the screen, which wasn't much since it freezes up early on.

    Custom config settings:
    Code:
    MARCH_TARGETNATIVE='n'        # Off for compatibility, on for speed.
    LETSENCRYPT_DETECT='y'        #
    VHOSTCTRL_CLOUDFLAREINC='y'   #
    NGINX_ZERODT='y'              # Zero downtime upgrades
    PHP_PGO='y'                   # Speed up php
    PHP_ARGON='y'                 # Enable more secure Argon2 password hash algorithm. Recompile php after enabling.
    
    SET_DEFAULT_MYSQLCHARSET='utf8mb4'  # For Xenforo
    ENABLE_MARIADBTENTWOUPGRADE='y'     #
    ENABLE_MARIADBTENTHREEUPGRADE='y'   #
    ENABLE_MARIADBTENFOURUPGRADE='y'    #
    
    POSTGRESQL='y'          # Install PostgreSQL with PHP recompile
    NEEDRESTART_CHECK='y'   # Check if system needs to be rebooted after system updates
    
     
  5. eva2000

    eva2000 Administrator Staff Member

    54,368
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    11:01 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Well I'd still need the php upgrade log https://community.centminmod.com/threads/how-to-troubleshoot-php-installs-upgrades.17857/
     
  6. MaximilianKohler

    MaximilianKohler Member

    197
    5
    18
    Jun 23, 2023
    Ratings:
    +29
    Local Time:
    5:01 AM
    php upgrade log - Pastebin.com

    Code:
    CentOS Version: CentOS 7 64bit
    Centmin Mod Version Installed: 123.09beta01
    Nginx Version Installed: nginx/1.25.3 (241023-215906-centos7-kvm-545176e)
    PHP Version Installed: 8.1.27
    MariaDB MySQL Version Installed: 10.4.32-MariaDB MariaDB Server
    When was last time updated Centmin Mod code base ? : It's up to date.
     
  7. MaximilianKohler

    MaximilianKohler Member

    197
    5
    18
    Jun 23, 2023
    Ratings:
    +29
    Local Time:
    5:01 AM
    I noticed that php_upgrade.inc was updated. Should I be trying this again or waiting for you to say something here?
     
  8. eva2000

    eva2000 Administrator Staff Member

    54,368
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    11:01 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Haven't done anything related to PostgreSQL yet. Been busy with work, but thanks for the reminder to look at this again.
     
  9. MaximilianKohler

    MaximilianKohler Member

    197
    5
    18
    Jun 23, 2023
    Ratings:
    +29
    Local Time:
    5:01 AM
  10. eva2000

    eva2000 Administrator Staff Member

    54,368
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    11:01 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Yeah I don't have time to look at it right now. For now you can disable PostgreSQL YUM repo as outlined in the error message
    Code (Text):
     3. Run the command with the repository temporarily disabled
                yum --disablerepo=pgdg-common ...
     
         4. Disable the repository permanently, so yum won't use it by default. Yum
            will then just ignore the repository until you permanently enable it
            again or use --enablerepo for temporary usage:
     
                yum-config-manager --disable pgdg-common

    Disable the PostgreSQL YUM repo
    Code (Text):
    yum-config-manager --disable pgdg-common pgdg11 pgdg12 pgdg13 pgdg14 pgdg15
    

    Then install docker as usual
    Can later re-enable when fixed
    Code (Text):
    yum-config-manager --enable pgdg-common pgdg11 pgdg12 pgdg13 pgdg14 pgdg15
    
     
  11. eva2000

    eva2000 Administrator Staff Member

    54,368
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    11:01 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    You can also try these manual commands to see if PostgreSQL YUM repos still complain
    Code (Text):
    rpm --import https://download.postgresql.org/pub/repos/yum/RPM-GPG-KEY-PGDG-16
    rpm --import https://download.postgresql.org/pub/repos/yum/RPM-GPG-KEY-PGDG
    yum makecache
    yum-config-manager --enable pgdg-common pgdg11 pgdg12 pgdg13 pgdg14 pgdg15
    yum repolist all
    

    If they still complain, disable them again
    Code (Text):
    yum-config-manager --disable pgdg-common pgdg11 pgdg12 pgdg13 pgdg14 pgdg15
    
     
  12. MaximilianKohler

    MaximilianKohler Member

    197
    5
    18
    Jun 23, 2023
    Ratings:
    +29
    Local Time:
    5:01 AM
    I did that and it happened again, but with pgdg11 pgdg11 error - Pastebin.com

    And then pgdg12, pgdg13, pgdg14, pgdg15. After disabling them all it worked. Thanks!

    Since I already disabled them and installed Docker, it's too late to try that?

    EDIT:
    Code:
    rpm --import https://download.postgresql.org/pub/repos/yum/RPM-GPG-KEY-PGDG-16
    curl: (22) The requested URL returned error: 404 Not Found
    error: https://download.postgresql.org/pub/repos/yum/RPM-GPG-KEY-PGDG-16: import read failed(2).
    
     
  13. eva2000

    eva2000 Administrator Staff Member

    54,368
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    11:01 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    looks like they moved the GPG key URLs PostgreSQL RPM repository GPG key update - 3 January 2024 - PostgreSQL YUM Repository!

    try

    Code (Text):
    rpm --import https://download.postgresql.org/pub/repos/yum/keys/PGDG-RPM-GPG-KEY-RHEL7
    yum makecache
    yum-config-manager --enable pgdg-common pgdg11 pgdg12 pgdg13 pgdg14 pgdg15
    yum repolist all
    

    If they still complain, disable them again
    Code (Text):
    yum-config-manager --disable pgdg-common pgdg11 pgdg12 pgdg13 pgdg14 pgdg15
     
  14. eva2000

    eva2000 Administrator Staff Member

    54,368
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    11:01 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    updated the GPG Key to
    try

    Code (Text):
    rpm --import https://download.postgresql.org/pub/repos/yum/keys/PGDG-RPM-GPG-KEY-RHEL7
    yum makecache
    yum-config-manager --enable pgdg-common pgdg11 pgdg12 pgdg13 pgdg14 pgdg15
    yum repolist all
    

    If they still complain, disable them again
    Code (Text):
    yum-config-manager --disable pgdg-common pgdg11 pgdg12 pgdg13 pgdg14 pgdg15
     
  15. MaximilianKohler

    MaximilianKohler Member

    197
    5
    18
    Jun 23, 2023
    Ratings:
    +29
    Local Time:
    5:01 AM
    Thanks! That seemed to work.
     
  16. MaximilianKohler

    MaximilianKohler Member

    197
    5
    18
    Jun 23, 2023
    Ratings:
    +29
    Local Time:
    5:01 AM
    I tried to upgrade from 8.1.27 to 8.1.28 today and got the same issue with it freezing: https://community.centminmod.com/threads/postgresql-wont-install.22086/#post-98504

    New log: php upgrade fail - Pastebin.com

    I ran
    Code:
    yum repolist all
    And I get a bunch of "not found" errors:
    Code:
    pgdg-common/7/x86_64/signature                                                                                                           |  665 B  00:00:00
    Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
    Importing GPG key 0x442DF0F8:
     Userid     : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"
     Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
     Package    : pgdg-redhat-repo-42.0-35PGDG.noarch (@pgdg-common)
     From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
    Is this ok [y/N]: y
    pgdg-common/7/x86_64/signature                                                                                                           | 2.9 kB  00:00:17 !!!
    https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-7-x86_64/repodata/repomd.xml: [Errno -1] repomd.xml signature could not be verified for pgdg-common
    Trying other mirror.
    https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/repodata/repomd.xml: [Errno 14] HTTPS Error 404 - Not Found
    Trying other mirror.
    To address this issue please refer to the below wiki article
    
    https://wiki.centos.org/yum-errors
    
    If above article doesn't help to resolve this issue please use https://bugs.centos.org/.
    
    pgdg12/7/x86_64/signature                                                                                                                |  665 B  00:00:00
    Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
    Importing GPG key 0x442DF0F8:
     Userid     : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"
     Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
     Package    : pgdg-redhat-repo-42.0-35PGDG.noarch (@pgdg-common)
     From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
    Is this ok [y/N]: y
    pgdg12/7/x86_64/signature                                                                                                                | 3.6 kB  00:01:01 !!!
    https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7-x86_64/repodata/repomd.xml: [Errno -1] repomd.xml signature could not be verified for pgdg12
    Trying other mirror.
    pgdg13/7/x86_64/signature                                                                                                                |  665 B  00:00:00
    Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
    Importing GPG key 0x442DF0F8:
     Userid     : "PostgreSQL RPM Building Project <pgsql-pkg-yum@postgresql.org>"
     Fingerprint: 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8
     Package    : pgdg-redhat-repo-42.0-35PGDG.noarch (@pgdg-common)
     From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
    Is this ok [y/N]:
    
    I ran
    Code:
    yum --disablerepo=* -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
    and that seemed to fix it.
     
    Last edited: Apr 22, 2024
  17. eva2000

    eva2000 Administrator Staff Member

    54,368
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    11:01 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    cheers strange as that is what initial install does install
    Code (Text):
    https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
    
     
  18. MaximilianKohler

    MaximilianKohler Member

    197
    5
    18
    Jun 23, 2023
    Ratings:
    +29
    Local Time:
    5:01 AM
    My understanding from your #13 post, is that these commands are temporary/incomplete to some extent:
    Code:
    rpm --import https://download.postgresql.org/pub/repos/yum/keys/PGDG-RPM-GPG-KEY-RHEL7
    yum makecache
    yum-config-manager --enable pgdg-common pgdg11 pgdg12 pgdg13 pgdg14 pgdg15
    yum repolist all
    So they worked temporarily for me before, but the "--disablerepo=* -y install" should be longer lasting.
     
  19. eva2000

    eva2000 Administrator Staff Member

    54,368
    12,198
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,763
    Local Time:
    11:01 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    What I mean is that https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm is installed by Centmin Mod when setting up and installing PostgreSQL.
     
  20. MaximilianKohler

    MaximilianKohler Member

    197
    5
    18
    Jun 23, 2023
    Ratings:
    +29
    Local Time:
    5:01 AM
    This is still happening on AlmaLinux 9. Full log:
    Code:
         ____   _   _  ____       _   _                                _       
        |  _ \ | | | ||  _ \  _  | | | | _ __    __ _  _ __  __ _   __| |  ___
        | |_) || |_| || |_) |(_) | | | || '_ \  / _` || '__|/ _` | / _` | / _ \
        |  __/ |  _  ||  __/  _  | |_| || |_) || (_| || |  | (_| || (_| ||  __/
        |_|    |_| |_||_|    (_)  \___/ | .__/  \__, ||_|   \__,_| \__,_| \___|
                                        |_|     |___/                         
    [?2004hPHP Upgrade/Downgrade - Would you like to continue? [y/n] y
    [?2004l
    ----------------------------------------------------------------
    Install which version of PHP? (i.e. 7.3.33, 7.4.33, 8.0.30, 8.1.30, 8.2.24, 8.3.12, NGDEBUG)
    PHP 7.x/7.1.x/7.2.x/7.3.x is GA Stable but still may have broken PHP extensions.
    NGDEBUG is PHP 8.4 dev builds minus incompatible PHP extensions
    ----------------------------------------------------------------
    
    Current PHP Version: 8.2.21
    Latest PHP Version Installable: 8.3.12, 8.2.24, 8.1.30, 8.0.30
    
    [?2004hEnter PHP Version number you want to upgrade/downgrade to: 8.2.24
    [?2004l
    [?2004hDo you still want to continue? [y/n] y
    [?2004l
    ----------------------------------------------------------------
    existing php.ini will be backed up at /usr/local/lib/php.ini-oldversion_280924-015633
    ----------------------------------------------------------------
    
    -----------------------------------------------------------------------------------------
    [1;33;40mDetected PHP 8.2 branch.
    (B[mYou can compile Zend OPcache (Zend Optimizer Plus+) support
    as an alternative to using APC Cache or Xcache cache.
    But Zend OPcache only provides PHP opcode cache and
    DOESN'T do data caching, so if your web apps such as Wordpress,
    Drupal or vBulletin require data caching to APC or Xcache,
    it won't work with Zend OPcache.
    
    -----------------------------------------------------------------------------------------
    [?2004hDo you want to use Zend OPcache [y/n] ? yy[K
    [?2004l
    removing duplicate _opcache.php files
    rm -rf /usr/local/nginx/html/9af915acf941236e_opcache.php
    *************************************************
    [1;32;40m* Zend Optimizer Plus OPcache configured
    (B[m*************************************************
    *************************************************
    [1;32;40m* Upgrading PHP
    (B[m*************************************************
     ____   _   _  ____       ____                          _                    _
    |  _ \ | | | ||  _ \  _  |  _ \   ___ __      __ _ __  | |  ___    __ _   __| |
    | |_) || |_| || |_) |(_) | | | | / _ \\ \ /\ / /| '_ \ | | / _ \  / _` | / _` |
    |  __/ |  _  ||  __/  _  | |_| || (_) |\ V  V / | | | || || (_) || (_| || (_| |
    |_|    |_| |_||_|    (_) |____/  \___/  \_/\_/  |_| |_||_| \___/  \__,_| \__,_|
                                                                                   
    HTTP/2 200
    1
    0
      % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                     Dload  Upload   Total   Spent    Left  Speed
    
      0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
    100 11.5M  100 11.5M    0     0  26.6M      0 --:--:-- --:--:-- --:--:-- 26.6M
    [1;33;40mDownload done.
    (B[m
    [1;33;40mphp-8.2.24.tar.xz valid file.
    (B[m
    PHP VERSION ID: 80224
    
    *************************************************
    [1;32;40m* Updating php.ini...
    (B[m*************************************************
    old php.ini will be saved at /usr/local/lib/php.ini-oldversion_280924-015633
    if you have modified your old php.ini i.e. installed and loaded
    APC, Xcache, Memcache or Suhosin - please re-install them after php upgrade
    ...
    
    make: *** No rule to make target 'clean'.  Stop.
    buildconf: Checking installation
    buildconf: autoconf version 2.69 (ok)
    buildconf: Forcing buildconf. The configure files will be regenerated.
    buildconf: Cleaning cache and configure files
    buildconf: Rebuilding configure
    buildconf: Rebuilding main/php_config.h.in
    buildconf: Run ./configure to proceed with customizing the PHP build.
    make: *** No rule to make target 'clean'.  Stop.
      ____   _   _  ____        ____                __  _                         
     |  _ \ | | | ||  _ \  _   / ___| ___   _ __   / _|(_)  __ _  _   _  _ __  ___
     | |_) || |_| || |_) |(_) | |    / _ \ | '_ \ | |_ | | / _` || | | || '__|/ _ \
     |  __/ |  _  ||  __/  _  | |___| (_) || | | ||  _|| || (_| || |_| || |  |  __/
     |_|    |_| |_||_|    (_)  \____|\___/ |_| |_||_|  |_| \__, | \__,_||_|   \___|
                                                           |___/                   
    PHP configure stage
    
    export ONIG_CFLAGS='-I/usr/include'
    export ONIG_LIBS='-L/usr/lib64 -lonig'
    
    ls -lAh /usr/include | grep onig
    -rw-r--r--    1 root root 3.3K Aug 13  2019 oniggnu.h
    -rw-r--r--    1 root root 6.7K Nov 10  2021 onigposix.h
    -rw-r--r--    1 root root  48K Oct  7  2023 oniguruma.h
    
    ls -lAh /usr/lib64 | grep onig
    lrwxrwxrwx   1 root root    18 Oct 17  2023 libonig.so -> libonig.so.105.4.0
    lrwxrwxrwx   1 root root    18 Oct 17  2023 libonig.so.105 -> libonig.so.105.4.0
    -rwxr-xr-x   1 root root  617K Oct 17  2023 libonig.so.105.4.0
    lrwxrwxrwx.  1 root root    16 Feb 10  2022 libonig.so.5 -> libonig.so.5.1.0
    -rwxr-xr-x.  1 root root  589K Feb 10  2022 libonig.so.5.1.0
    
    NEWLIBICU=y
    NEWLIBICU=y
    NEWLIBICU=y
    Importing GPG key 0x08B40D20:
     Userid     : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org>"
     Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
     From       : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
    
    
    

    Code:
    yum repolist all
    Does not give errors though.
    Code:
    repo id                                    repo name                                                                                                    status
    appstream                                  AlmaLinux 9 - AppStream                                                                                      enabled
    appstream-debuginfo                        AlmaLinux 9 - AppStream - Debug                                                                              disabled
    appstream-source                           AlmaLinux 9 - AppStream - Source                                                                             disabled
    backports-rsync                            AlmaLinux 9 Backports - rsync                                                                                enabled
    baseos                                     AlmaLinux 9 - BaseOS                                                                                         enabled
    baseos-debuginfo                           AlmaLinux 9 - BaseOS - Debug                                                                                 disabled
    baseos-source                              AlmaLinux 9 - BaseOS - Source                                                                                disabled
    crb                                        AlmaLinux 9 - CRB                                                                                            enabled
    crb-debuginfo                              AlmaLinux 9 - CRB - Debug                                                                                    disabled
    crb-source                                 AlmaLinux 9 - CRB - Source                                                                                   disabled
    epel                                       Extra Packages for Enterprise Linux 9 - x86_64                                                               enabled
    epel-cisco-openh264                        Extra Packages for Enterprise Linux 9 openh264 (From Cisco) - x86_64                                         enabled
    epel-cisco-openh264-debuginfo              Extra Packages for Enterprise Linux 9 openh264 (From Cisco) - x86_64 - Debug                                 disabled
    epel-cisco-openh264-source                 Extra Packages for Enterprise Linux 9 openh264 (From Cisco) - x86_64 - Source                                disabled
    epel-debuginfo                             Extra Packages for Enterprise Linux 9 - x86_64 - Debug                                                       disabled
    epel-source                                Extra Packages for Enterprise Linux 9 - x86_64 - Source                                                      disabled
    epel-testing                               Extra Packages for Enterprise Linux 9 - Testing - x86_64                                                     disabled
    epel-testing-debuginfo                     Extra Packages for Enterprise Linux 9 - Testing - x86_64 - Debug                                             disabled
    epel-testing-source                        Extra Packages for Enterprise Linux 9 - Testing - x86_64 - Source                                            disabled
    extras                                     AlmaLinux 9 - Extras                                                                                         enabled
    extras-debuginfo                           AlmaLinux 9 - Extras - Debug                                                                                 disabled
    extras-source                              AlmaLinux 9 - Extras - Source                                                                                disabled
    highavailability                           AlmaLinux 9 - HighAvailability                                                                               disabled
    highavailability-debuginfo                 AlmaLinux 9 - HighAvailability - Debug                                                                       disabled
    highavailability-source                    AlmaLinux 9 - HighAvailability - Source                                                                      disabled
    mariadb                                    MariaDB                                                                                                      enabled
    nfv                                        AlmaLinux 9 - NFV                                                                                            disabled
    nfv-debuginfo                              AlmaLinux 9 - NFV - Debug                                                                                    disabled
    nfv-source                                 AlmaLinux 9 - NFV - Source                                                                                   disabled
    pgdg-common                                PostgreSQL common RPMs for RHEL / Rocky / AlmaLinux 9 - x86_64                                               enabled
    pgdg-common-debuginfo                      PostgreSQL common RPMs for RHEL / Rocky / AlmaLinux 9 - x86_64 - Debuginfo                                   disabled
    pgdg-common-srpm-testing                   PostgreSQL common testing SRPMs for RHEL / Rocky / AlmaLinux 9 - x86_64                                      disabled
    pgdg-common-testing                        PostgreSQL common testing RPMs for RHEL / Rocky / AlmaLinux 9 - x86_64                                       disabled
    pgdg-rhel9-extras                          Extra packages to support some RPMs in the PostgreSQL RPM repo RHEL / Rocky / AlmaLinux 9 - x86_64           disabled
    pgdg-rhel9-sysupdates                      PostgreSQL Supplementary ucommon RPMs for RHEL / Rocky / AlmaLinux 9 - x86_64                                disabled
    pgdg-source-common                         PostgreSQL 12 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Source                                               disabled
    pgdg12                                     PostgreSQL 12 for RHEL / Rocky / AlmaLinux 9 - x86_64                                                        enabled
    pgdg12-debuginfo                           PostgreSQL 12 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Debuginfo                                            disabled
    pgdg12-source                              PostgreSQL 12 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Source                                               disabled
    pgdg12-source-updates-testing              PostgreSQL 12 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Source update testing                                disabled
    pgdg12-updates-testing                     PostgreSQL 12 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Updates testing                                      disabled
    pgdg12-updates-testing-debuginfo           PostgreSQL 12 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Debuginfo                                            disabled
    pgdg13                                     PostgreSQL 13 for RHEL / Rocky / AlmaLinux 9 - x86_64                                                        enabled
    pgdg13-debuginfo                           PostgreSQL 13 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Debuginfo                                            disabled
    pgdg13-source                              PostgreSQL 13 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Source                                               disabled
    pgdg13-source-updates-testing              PostgreSQL 13 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Source updates testing                               disabled
    pgdg13-updates-testing                     PostgreSQL 13 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Updates testing                                      disabled
    pgdg13-updates-testing-debuginfo           PostgreSQL 13 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Debuginfo                                            disabled
    pgdg14                                     PostgreSQL 14 for RHEL / Rocky / AlmaLinux 9 - x86_64                                                        enabled
    pgdg14-debuginfo                           PostgreSQL 14 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Debuginfo                                            disabled
    pgdg14-source                              PostgreSQL 14 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Source                                               disabled
    pgdg14-source-updates-testing              PostgreSQL 14 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Source updates testing                               disabled
    pgdg14-updates-testing                     PostgreSQL 14 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Updates testing                                      disabled
    pgdg14-updates-testing-debuginfo           PostgreSQL 14 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Debuginfo                                            disabled
    pgdg15                                     PostgreSQL 15 for RHEL / Rocky / AlmaLinux 9 - x86_64                                                        enabled
    pgdg15-debuginfo                           PostgreSQL 15 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Debuginfo                                            disabled
    pgdg15-source                              PostgreSQL 15 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Source                                               disabled
    pgdg15-source-updates-testing              PostgreSQL 15 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Source updates testing                               disabled
    pgdg15-updates-testing                     PostgreSQL 15 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Updates testing                                      disabled
    pgdg15-updates-testing-debuginfo           PostgreSQL 15 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Debuginfo                                            disabled
    pgdg16                                     PostgreSQL 16 for RHEL / Rocky / AlmaLinux 9 - x86_64                                                        enabled
    pgdg16-debuginfo                           PostgreSQL 16 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Debuginfo                                            disabled
    pgdg16-source                              PostgreSQL 16 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Source                                               disabled
    pgdg16-source-updates-testing              PostgreSQL 16 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Source updates testing                               disabled
    pgdg16-updates-testing                     PostgreSQL 16 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Updates testing                                      disabled
    pgdg16-updates-testing-debuginfo           PostgreSQL 16 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Debuginfo                                            disabled
    pgdg17                                     PostgreSQL 17 for RHEL / Rocky / AlmaLinux 9 - x86_64                                                        enabled
    pgdg17-debuginfo                           PostgreSQL 17 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Debuginfo                                            disabled
    pgdg17-source                              PostgreSQL 17 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Source                                               disabled
    pgdg17-source-updates-testing              PostgreSQL 17 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Source updates testing                               disabled
    pgdg17-updates-testing                     PostgreSQL 17 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Updates testing                                      disabled
    pgdg17-updates-testing-debuginfo           PostgreSQL 17 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Debuginfo                                            disabled
    pgdg18-source-updates-testing              PostgreSQL 18 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Source updates testing                               disabled
    pgdg18-updates-testing                     PostgreSQL 18 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Updates testing                                      disabled
    pgdg18-updates-testing-debuginfo           PostgreSQL 18 for RHEL / Rocky / AlmaLinux 9 - x86_64 - Debuginfo                                            disabled
    plus                                       AlmaLinux 9 - Plus                                                                                           disabled
    plus-debuginfo                             AlmaLinux 9 - Plus - Debug                                                                                   disabled
    plus-source                                AlmaLinux 9 - Plus - Source                                                                                  disabled
    prel-release-noarch                        Percona Release release/noarch YUM repository                                                                enabled
    remi                                       Remi's RPM repository for Enterprise Linux 9 - x86_64                                                        disabled
    remi-debuginfo                             Remi's RPM repository for Enterprise Linux 9 - x86_64 - debuginfo                                            disabled
    remi-modular                               Remi's Modular repository for Enterprise Linux 9 - x86_64                                                    enabled
    remi-modular-debuginfo                     Remi's Modular repository for Enterprise Linux 9 - x86_64 - debuginfo                                        disabled
    remi-modular-test                          Remi's Modular testing repository for Enterprise Linux 9 - x86_64                                            disabled
    remi-modular-test-debuginfo                Remi's Modular testing repository for Enterprise Linux 9 - x86_64 - debuginfo                                disabled
    remi-safe                                  Safe Remi's RPM repository for Enterprise Linux 9 - x86_64                                                   disabled
    remi-safe-debuginfo                        Remi's RPM repository for Enterprise Linux 9 - x86_64 - debuginfo                                            disabled
    remi-test                                  Remi's test RPM repository for Enterprise Linux 9 - x86_64                                                   disabled
    remi-test-debuginfo                        Remi's test RPM repository for Enterprise Linux 9 - x86_64 - debuginfo                                       disabled
    resilientstorage                           AlmaLinux 9 - ResilientStorage                                                                               disabled
    resilientstorage-debuginfo                 AlmaLinux 9 - ResilientStorage - Debug                                                                       disabled
    resilientstorage-source                    AlmaLinux 9 - ResilientStorage - Source                                                                      disabled
    rt                                         AlmaLinux 9 - RT                                                                                             disabled
    rt-debuginfo                               AlmaLinux 9 - RT - Debug                                                                                     disabled
    rt-source                                  AlmaLinux 9 - RT - Source                                                                                    disabled
    sap                                        AlmaLinux 9 - SAP                                                                                            disabled
    sap-debuginfo                              AlmaLinux 9 - SAP - Debug                                                                                    disabled
    sap-source                                 AlmaLinux 9 - SAP - Source                                                                                   disabled
    saphana                                    AlmaLinux 9 - SAPHANA                                                                                        disabled
    saphana-debuginfo                          AlmaLinux 9 - SAPHANA - Debug                                                                                disabled
    saphana-source                             AlmaLinux 9 - SAPHANA - Source                                                                               disabled
    telemetry-release-sources                  Percona Telemetry release/sources YUM repository                                                             disabled
    telemetry-release-x86_64                   Percona Telemetry release/x86_64 YUM repository                                                              enabled
    tools-release-sources                      Percona Tools release/sources YUM repository                                                                 disabled
    tools-release-x86_64                       Percona Tools release/x86_64 YUM repository