Beta Branch update PostgreSQL default to 17.x in 140.00beta01

update PostgreSQL default to 17.x in 140.00beta01

- when POSTGRESQL='y' set in the persistent config file /etc/centminmod/custom_config.inc prior to centmin.sh menu option 5 PHP upgrade/recompiles, it will install PostgreSQL server and compile PHP-FPM with postgresql support
- update default PostgreSQL version from 16 to 17 PostgreSQL 17 Released! and release notes E.1. Release 17
- note postgreSQL is provided as is, you need to know how to manage, tune and administer PostgreSQL server yourself. If you had previous ran this and installed PostgreSQL 16, you may now have 2 versions of PostgreSQL 16 and 17 installed with their own service files and data directories and need to now how to deal with them yourself and any existing data on prior version for migration into newer version as per release notes instructions E.1. Release 17. PostgreSQL 17 might not start up as it would bind on same default port 5432 as running on existing PostgreSQL 16 server if that exists, so would need to change port temporarily for PostgreSQL 17 config file /var/lib/pgsql/17/data/postgresql.conf until data migration is completed.

Code (Text):

sed -i 's|^#port = 5432|port = 5433|' /var/lib/pgsql/17/data/postgresql.conf
systemctl restart postgresql-17

Code (Text):

systemctl status postgresql-17 --no-pager -l
● postgresql-17.service - PostgreSQL 17 database server
     Loaded: loaded (/usr/lib/systemd/system/postgresql-17.service; enabled; preset: disabled)
     Active: active (running) since Sat 2024-09-28 12:06:05 UTC; 3s ago
       Docs: https://www.postgresql.org/docs/17/static/
    Process: 1060418 ExecStartPre=/usr/pgsql-17/bin/postgresql-17-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
   Main PID: 1060423 (postgres)
      Tasks: 7 (limit: 48716)
     Memory: 18.2M
        CPU: 28ms
     CGroup: /system.slice/postgresql-17.service
             ├─1060423 /usr/pgsql-17/bin/postgres -D /var/lib/pgsql/17/data/
             ├─1060424 "postgres: logger "
             ├─1060425 "postgres: checkpointer "
             ├─1060426 "postgres: background writer "
             ├─1060428 "postgres: walwriter "
             ├─1060429 "postgres: autovacuum launcher "
             └─1060430 "postgres: logical replication launcher "

Sep 28 12:06:05 almalinux9dev2 systemd[1]: Starting PostgreSQL 17 database server...
Sep 28 12:06:05 almalinux9dev2 postgres[1060423]: 2024-09-28 12:06:05.260 UTC [1060423] LOG:  redirecting log output to logging collector process
Sep 28 12:06:05 almalinux9dev2 postgres[1060423]: 2024-09-28 12:06:05.260 UTC [1060423] HINT:  Future log output will appear in directory "log".
Sep 28 12:06:05 almalinux9dev2 systemd[1]: Started PostgreSQL 17 database server.

---

Code (Text):

ss -plt | grep 54
LISTEN 0      200        127.0.0.1:5432        0.0.0.0:*    users:(("postgres",pid=107728,fd=8))
LISTEN 0      200        127.0.0.1:5433        0.0.0.0:*    users:(("postgres",pid=1060423,fd=8))
LISTEN 0      200            [::1]:5432           [::]:*    users:(("postgres",pid=107728,fd=7))
LISTEN 0      200            [::1]:5433           [::]:*    users:(("postgres",pid=1060423,fd=7))

Code (Text):

php --ri pdo_pgsql
pdo_pgsql
PDO Driver for PostgreSQL => enabled
PostgreSQL(libpq) Version => 17.0

showing both v16 and v17 if you had prior v16 installed

Code (Text):

yum -q list installed | grep postgresql
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
postgresql17.x86_64          17.0-2PGDG.rhel9  @pgdg17
postgresql17-contrib.x86_64  17.0-2PGDG.rhel9  @pgdg17
postgresql17-devel.x86_64    17.0-2PGDG.rhel9  @pgdg17
postgresql17-libs.x86_64     17.0-2PGDG.rhel9  @pgdg17
postgresql17-server.x86_64   17.0-2PGDG.rhel9  @pgdg17

Continue reading...

140.00beta01 branch

• Branch: GitHub - centminmod/centminmod at 140.00beta01
• Commit History: Commits · centminmod/centminmod