PostgreSQL won't install

Yes.

 

It still froze for me.

Code:

cmupdate
No local changes to save
Already up to date.
No local changes to save
Already up to date.

[03:59][root@domain ~]# cmdir
/usr/local/src/centminmod ~
[03:59][root@domain centminmod]# wget -O postgresql.patch https://gist.github.com/centminmod/d3178e50ff57227e7f9ee43440566a87/raw/postgresql.patch
--2024-09-28 04:00:02--  https://gist.github.com/centminmod/d3178e50ff57227e7f9ee43440566a87/raw/postgresql.patch
Resolving gist.github.com (gist.github.com)... 140.82.121.3
Connecting to gist.github.com (gist.github.com)|140.82.121.3|:443... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: https://gist.githubusercontent.com/centminmod/d3178e50ff57227e7f9ee43440566a87/raw/postgresql.patch [following]
--2024-09-28 04:00:02--  https://gist.githubusercontent.com/centminmod/d3178e50ff57227e7f9ee43440566a87/raw/postgresql.patch
Resolving gist.githubusercontent.com (gist.githubusercontent.com)... 185.199.109.133, 185.199.110.133, 185.199.111.133, ...
Connecting to gist.githubusercontent.com (gist.githubusercontent.com)|185.199.109.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3762 (3.7K) [text/plain]
Saving to: ‘postgresql.patch’

postgresql.patch                        100%[===============================================================================>]   3.67K  --.-KB/s    in 0s

2024-09-28 04:00:02 (15.2 MB/s) - ‘postgresql.patch’ saved [3762/3762]

[04:00][root@domain centminmod]# patch -p1 < postgresql.patch
patching file inc/postgresql.inc
[04:00][root@domain centminmod]# centmin
/usr/local/src/centminmod /usr/local/src/centminmod

--------------------------------------------------------
     Centmin Mod Menu 140.00beta01 centminmod.com
--------------------------------------------------------
1).  Centmin Install
2).  Add Nginx vhost domain
3).  NSD setup domain name DNS
4).  Nginx Upgrade / Downgrade
5).  PHP Upgrade / Downgrade
6).  MySQL User Database Management
7).  Persistent Config File Management
8).  Option Being Revised (TBA)
9).  Option Being Revised (TBA)
10). Memcached Server Re-install
11). MariaDB MySQL Upgrade & Management
12). Zend OpCache Install/Re-install
13). Install/Reinstall Redis PHP Extension
14). SELinux disable
15). Install/Reinstall ImagicK PHP Extension
16). Change SSHD Port Number
17). Multi-thread compression: zstd,pigz,pbzip2,lbzip2
18). Suhosin PHP Extension install
19). Install FFMPEG and FFMPEG PHP Extension
20). NSD Install/Re-Install
21). Data Transfer
22). Add Wordpress Nginx vhost + Cache Plugin
23). Update Centmin Mod Code Base
24). Exit
--------------------------------------------------------
Enter option [ 1 - 24 ] 5
--------------------------------------------------------
     ____   _   _  ____       _   _                                _
    |  _ \ | | | ||  _ \  _  | | | | _ __    __ _  _ __  __ _   __| |  ___
    | |_) || |_| || |_) |(_) | | | || '_ \  / _` || '__|/ _` | / _` | / _ \
    |  __/ |  _  ||  __/  _  | |_| || |_) || (_| || |  | (_| || (_| ||  __/
    |_|    |_| |_||_|    (_)  \___/ | .__/  \__, ||_|   \__,_| \__,_| \___|
                                    |_|     |___/

PHP Upgrade/Downgrade - Would you like to continue? [y/n] y\
PHP Upgrade/Downgrade - Would you like to continue? [y/n] y

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

Enter PHP Version number you want to upgrade/downgrade to: 8.2.24

Do you still want to continue? [y/n] y

----------------------------------------------------------------
existing php.ini will be backed up at /usr/local/lib/php.ini-oldversion_280924-040023
----------------------------------------------------------------

-----------------------------------------------------------------------------------------
Detected PHP 8.2 branch.
You 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.

-----------------------------------------------------------------------------------------
Do you want to use Zend OPcache [y/n] ? y

*************************************************
* Zend Optimizer Plus OPcache configured
*************************************************
*************************************************
* Upgrading PHP
*************************************************
 ____   _   _  ____       ____                          _                    _
|  _ \ | | | ||  _ \  _  |  _ \   ___ __      __ _ __  | |  ___    __ _   __| |
| |_) || |_| || |_) |(_) | | | | / _ \\ \ /\ / /| '_ \ | | / _ \  / _` | / _` |
|  __/ |  _  ||  __/  _  | |_| || (_) |\ V  V / | | | || || (_) || (_| || (_| |
|_|    |_| |_||_|    (_) |____/  \___/  \_/\_/  |_| |_||_| \___/  \__,_| \__,_|

HTTP/2 200
1
0
php 8.2.24 Archive found, skipping download...
php-8.2.24.tar.xz valid file.

PHP VERSION ID: 80224

*************************************************
* Updating php.ini...
*************************************************
old php.ini will be saved at /usr/local/lib/php.ini-oldversion_280924-040023
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:

php-config
Usage: /usr/local/bin/php-config [OPTION]
Options:
  --prefix            [/usr/local]
  --includes          [-I/usr/local/include/php -I/usr/local/include/php/main -I/usr/local/include/php/TSRM -I/usr/local/include/php/Zend -I/usr/local/include/php/ext -I/usr/local/include/php/ext/date/lib]
  --ldflags           [ -Wl,-z,relro,-z,now -pie -L/usr/lib64/../lib64 -L/usr/local/lib64]
  --libs              [-lcrypt  -lc-client  -ltidy -lncurses -laspell -lpspell -lrt -lldap -llber -lstdc++ -lcrypt -lpam -lgmp -lbz2 -lrt -lm  -lsystemd -lxml2 -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lssl -lcrypto -lsqlite3 -lz -lcurl -lssl -lcrypto -lxml2 -lenchant -lgmodule-2.0 -lglib-2.0 -lffi -lssl -lcrypto -lz -lpng16 -lwebp -ljpeg -lXpm -lX11 -lfreetype -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lssl -lcrypto -licuio -licui18n -licuuc -licudata -lonig -lsqlite3 -ledit -lxml2 -lnetsnmp -lm -lm -lssl -lssl -lcrypto -lxml2 -lsodium -largon2 -lxml2 -lxml2 -lxml2 -lxslt -lxml2 -lexslt -lxslt -lxml2 -lzip -lz -lssl -lcrypto -lcrypt ]
  --extension-dir     [/usr/local/lib/php/extensions/no-debug-non-zts-20220829]
  --include-dir       [/usr/local/include/php]
  --man-dir           [/usr/local/php/man]
  --php-binary        [/usr/local/bin/php]
  --php-sapis         [ cli embed fpm phpdbg cgi]
  --ini-path          [/usr/local/lib]
  --ini-dir           [/etc/centminmod/php.d]
  --configure-options [--enable-fpm --enable-opcache --enable-intl --enable-pcntl --with-mcrypt --with-snmp --enable-embed=shared --with-mhash --with-zlib --with-gettext --enable-exif --with-zip --with-libzip --with-bz2 --enable-soap --enable-sockets --enable-sysvmsg --enable-sysvsem --enable-sysvshm --with-mysql-sock=/var/lib/mysql/mysql.sock --with-curl --enable-gd --with-xmlrpc --enable-bcmath --enable-calendar --enable-ftp --enable-gd-native-ttf --with-freetype --with-jpeg --with-png-dir=/usr --with-xpm --with-webp --with-t1lib=/usr --enable-shmop --with-pear --enable-mbstring --with-openssl --with-mysql=mysqlnd --with-libdir=lib64 --with-mysqli=mysqlnd --enable-pdo --with-pdo-sqlite --with-pdo-mysql=mysqlnd --enable-inline-optimization --with-imap --with-imap-ssl --with-kerberos --with-readline --with-libedit --with-gmp --with-pspell --with-tidy --with-enchant --with-fpm-user=nginx --with-fpm-group=nginx --with-ldap --with-ldap-sasl --with-password-argon2 --with-sodium=/usr/local --with-pic --with-config-file-scan-dir=/etc/centminmod/php.d --with-fpm-systemd --with-ffi --with-xsl PKG_CONFIG_PATH=/usr/local/lib64/pkgconfig: OPENSSL_CFLAGS=-I /usr/include OPENSSL_LIBS=-L /usr/lib64 -lssl -lcrypto PNG_CFLAGS=-I/usr/include PNG_LIBS=-L/usr/lib64 -lpng16 ICU_CFLAGS=-fPIC ICU_LIBS=-L/usr/lib64 -licuio -licui18n -licuuc -licudata ONIG_CFLAGS=-I/usr/include ONIG_LIBS=-L/usr/lib64 -lonig LIBSODIUM_CFLAGS=-fPIC LIBSODIUM_LIBS=-L/usr/local/lib64 -lsodium ARGON2_CFLAGS=-I/usr/local/include ARGON2_LIBS=-L/usr/local/lib64 -largon2 LIBZIP_CFLAGS=-fPIC LIBZIP_LIBS=-L/usr/local/lib64 -lzip]
  --version           [8.2.21]
  --vernum            [80221]

Code:

php -m
[PHP Modules]
bcmath
bz2
calendar
Core
ctype
curl
date
dom
enchant
exif
FFI
fileinfo
filter
ftp
gd
geoip
gettext
gmp
hash
iconv
igbinary
imagick
imap
intl
json
ldap
libxml
mailparse
mbstring
memcache
memcached
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_mysql
pdo_sqlite
Phar
posix
pspell
random
readline
redis
Reflection
session
shmop
SimpleXML
snmp
soap
sockets
sodium
SPL
sqlite3
standard
sysvmsg
sysvsem
sysvshm
tidy
timezonedb
tokenizer
xml
xmlreader
xmlwriter
xsl
Zend OPcache
zip
zlib

[Zend Modules]
Zend OPcache

Code:

php --ri pdo_pgsql
Extension 'pdo_pgsql' not present.

Code:

psql --version
psql (PostgreSQL) 16.4

Code:

yum -q list installed | grep postgresql | tr -s ' ' | column -t
postgresql16.x86_64          16.4-1PGDG.rhel9  @pgdg16
postgresql16-contrib.x86_64  16.4-1PGDG.rhel9  @pgdg16
postgresql16-devel.x86_64    16.4-1PGDG.rhel9  @pgdg16
postgresql16-libs.x86_64     16.4-1PGDG.rhel9  @pgdg16
postgresql16-server.x86_64   16.4-1PGDG.rhel9  @pgdg16

 

I think it's a fresh 140. I created a new server to install almalinux on. Maybe on my old centos server I had 130. I don't remember exactly. In /root/centminlogs I only see centminmod_140.00beta01.log files, no 130.

Yes, there is data in the postgres database. It's currently running listmonk.

I can try this command from comment #13 further up.

Code:

dnf --disablerepo=* -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Code:

dnf --disablerepo=* -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
pgdg-redhat-repo-latest.noarch.rpm                                                                                               70 kB/s |  12 kB     00:00
Package pgdg-redhat-repo-42.0-45PGDG.noarch is already installed.
Dependencies resolved.
Nothing to do.
Complete!

 

I only have one pgdg file in /etc/yum.repos.d. There's no
pgdg-redhat-all.repo.rpmnew. Probably because when that command worked for me I was on centos 7. I think this is the first time I've had issues with this on almalinux 9.

I checked /etc/pki/rpm-gpg, and I do see the PGDG-RPM-GPG-KEY-RHEL key there. Permissions, 644, root root. Last modified 03/05/2024.

 

Interesting, I renamed the old file to pgdg-redhat-all.repo.orig, but running that command didn't create a new file.

Code:

dnf --disablerepo=* -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Waiting for process with pid 48776 to finish.
pgdg-redhat-repo-latest.noarch.rpm                                                                                               45 kB/s |  12 kB     00:00
Package pgdg-redhat-repo-42.0-45PGDG.noarch is already installed.
Dependencies resolved.
Nothing to do.
Complete!

I downloaded PGDG-RPM-GPG-KEY-RHEL from Index of /pub/repos/yum/keys/ and compared it to the existing key in /etc/pki/rpm-gpg, and they're the same.

I ran the php upgrade without a pgdg-redhat-all.repo file and it didn't freeze, but it looks like it failed in the end.

Looking at the log, I see that the php setup tries to cat it and fails:

Code:

-rw-r--r--  1 root root  15K Sep 26 07:41 pgdg-redhat-all.repo.orig
-rw-r--r--  1 root root  961 Sep 28 07:42 remi-safe.repo

cat /etc/yum.repos.d/pgdg-redhat-all.repo
cat: /etc/yum.repos.d/pgdg-redhat-all.repo: No such file or directory

Here's the full log: 54.6 KB file on MEGA

 

That did download a new file.

Code:

dnf --disablerepo=* -y reinstall https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
pgdg-redhat-repo-latest.noarch.rpm                                                                                               42 kB/s |  12 kB     00:00
Dependencies resolved.
================================================================================================================================================================
 Package                                    Architecture                     Version                               Repository                              Size
================================================================================================================================================================
Reinstalling:
 pgdg-redhat-repo                           noarch                           42.0-45PGDG                           @commandline                            12 k

Transaction Summary
================================================================================================================================================================

Total size: 12 k
Installed size: 17 k
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                        1/1
  Reinstalling     : pgdg-redhat-repo-42.0-45PGDG.noarch                                                                                                    1/2
  Cleanup          : pgdg-redhat-repo-42.0-45PGDG.noarch                                                                                                    2/2
  Verifying        : pgdg-redhat-repo-42.0-45PGDG.noarch                                                                                                    1/2
  Verifying        : pgdg-redhat-repo-42.0-45PGDG.noarch                                                                                                    2/2

Reinstalled:
  pgdg-redhat-repo-42.0-45PGDG.noarch

Complete!

I compared the two files with the notepad++ plugin and the only difference is that the old one has "gpgcheck=0" and the new one has "gpgcheck=9", under the [pgdg18-updates-testing-debuginfo] section.

And now when I open Putty I get:

Code:

===============================================================================
* Getting Started Guide - https://centminmod.com/getstarted.html
* Centmin Mod FAQ - https://centminmod.com/faq.html
* Centmin Mod Config Files - https://centminmod.com/configfiles.html
* Centmin Mod Blog - https://blog.centminmod.com
* Community Forums https://community.centminmod.com  [ << Register ]
===============================================================================

===============================================================================
 Centmin Mod local code is up to date at /usr/local/src/centminmod
 no available updates at this time...
===============================================================================
Invalid configuration value: gpgcheck=9 in /etc/yum.repos.d/pgdg-redhat-all.repo; invalid boolean value '9'
 Current local server Centmin Mod branch installed: 140.00beta01
===============================================================================
[09:23][root@hostname ~]#

 

It didn't freeze, so I guess the reason it was freezing was due to gpgcheck=0 instead of gpgcheck=1? So the postgres team keeps putting typos in their files I guess? First 0, then 9.

The php upgrade still failed though. Log: 3.19 MB file on MEGA

Minimal: 183.1 KB file on MEGA