Welcome to Centmin Mod Community
Register Now

Beta Branch update POSTGRESQL variable to v16 & add EL8/EL9 support in 130.00beta01

Discussion in 'Centmin Mod Github Commits' started by eva2000, Oct 10, 2023.

  1. eva2000

    eva2000 Administrator Staff Member

    51,985
    11,976
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,473
    Local Time:
    12:27 AM
    Nginx 1.25.x
    MariaDB 10.x
    update POSTGRESQL variable to v16 & add EL8/EL9 support in 130.00beta01

    Centmin Mod can optionally install PostreSQL server via official PostgreSQL YUM install https://www.postgresql.org/download/linux/redhat/ via optional setting POSTGRESQL='y' set in persistent config file at /etc/centminmod/custom_config.inc + run centmin.sh menu option 5 to recompile PHP server. The PostgreSQL install is triggered by PHP compilation as PHP needs to be recompiled with PostgreSQL supported libraries that are installed via PostgreSQL YUM repo.

    It will install latest PostgreSQL 16 version these days. Previous implementations in Centmin Mod 130.00beta01 before October 10, 2023 installed PostreSQL 13 and due to additional manual steps required to upgrade between major versions outlined at https://www.postgresql.org/docs/current/upgrading.html. So folks who previously installed on PostgreSQL 13 or earlier via Centmin Mod method will remain on previous PostgreSQL versions with minor updates and will not automatically be updated to PostgreSQL 16. See docs for manual upgrading https://www.postgresql.org/docs/current/upgrading.html


    PostgreSQL optional install is provided as is. Centmin Mod provides the installation but administration and management of PostgreSQL databases are left to end user to do. So you will need to be familiar with PostgreSQL server and client usage.

    With POSTGRESQL='y' set in persistent config file at /etc/centminmod/custom_config.inc and after centmin.sh menu option 5 update/recompile, you can inspect the PHP-FPM configure options check for --with-pgsql=/usr/pgsql-16 --with-pdo-pgsql=/usr/pgsql-16 references.

    Note, currently Centmin Mod 124.00stable is still stuck on PostgreSQL v13 if you use POSTGRESQL='y' set in persistent config file at /etc/centminmod/custom_config.inc + run centmin.sh menu option 5 to recompile PHP server

    Continue reading...

    130.00beta01 branch

    Support Centmin Mod


    If you find Centmin Mod useful, please help support Centmin Mod
     
  2. hakabe

    hakabe New Member

    3
    1
    3
    Dec 18, 2016
    Ratings:
    +1
    Local Time:
    5:27 PM
    1.11.7
    10
    Option for insaller to choose which DB to use? Postgre|MariaDB?

    Menu option 6 for Postresql management?
    1. User Config & Creation
    2. Create database >> name & user permissions
    3. Server port|ip|allowedip config
    4. Upgrade|downgrade|uninstall

    Same menus for 11 (MariaDB) if anyone doesn't run double databases.
     
  3. eva2000

    eva2000 Administrator Staff Member

    51,985
    11,976
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,473
    Local Time:
    12:27 AM
    Nginx 1.25.x
    MariaDB 10.x
    There currently is not menu for PostgreSQL management or choice between MariaDB or PostgreSQL.You'd have to know how to manage PostgreSQL yourself right now.

    One reason is I don't have much production experience with PostgreSQL right now. So if folks want such PostgreSQL menus, they would need to help provide their production experience and feedback input into creating such menu management