Discover Centmin Mod today
Register Now

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:35 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

    51,261
    11,900
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,375
    Local Time:
    11:35 PM
    Nginx 1.25.x
    MariaDB 10.x
  3. mrkip

    mrkip New Member

    17
    14
    3
    Jan 29, 2019
    Ratings:
    +19
    Local Time:
    1:35 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

    125
    1
    18
    Jun 23, 2023
    Ratings:
    +13
    Local Time:
    5:35 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

    51,261
    11,900
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,375
    Local Time:
    11:35 PM
    Nginx 1.25.x
    MariaDB 10.x
    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

    125
    1
    18
    Jun 23, 2023
    Ratings:
    +13
    Local Time:
    5:35 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.