Want more timely Centmin Mod News Updates?
Become a Member

Beta Branch update optional PostgreSQL server install to version 11 branch in 123.09beta01

Discussion in 'Centmin Mod Github Commits' started by eva2000, Feb 7, 2019.

  1. eva2000

    eva2000 Administrator Staff Member

    44,691
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,794
    Local Time:
    5:18 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    update optional PostgreSQL server install to version 11 branch in 123.09beta01

    Centmin Mod can optionally install PostreSQL server via official PostgreSQL YUM install 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 as outlined at https://community.centminmod.com/th...n-option-to-centmin-sh-for-123-09beta01.4490/. It will install latest PostgreSQL 11 version these days. Previous implementations in Centmin Mod 123.09beta01 installed PostreSQL 9.6 and due to additional manual steps required to upgrade between major versions outlined at PostgreSQL: Documentation: 11: 18.6. Upgrading a PostgreSQL Cluster auto upgrades are not possible. So folks who previously installed on PostgreSQL 9.6 will remain on 9.6 branch with minor updates 9.6.x and will not automatically be updated to PostgreSQL 11.

    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.

    Example POSTGRESQL='y' run on PHP 7.2.14 configure options check for --with-pgsql=/usr/pgsql-11 --with-pdo-pgsql=/usr/pgsql-11
    PostgreSQL php extension after centmin.sh menu option 5 recompile
    Code (Text):
    php --ri pgsql
    
    pgsql
    
    PostgreSQL Support => enabled
    PostgreSQL(libpq) Version => 11.1
    PostgreSQL(libpq)  => PostgreSQL 11.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit
    Multibyte character support => enabled
    SSL support => enabled
    Active Persistent Links => 0
    Active Links => 0
    
    Directive => Local Value => Master Value
    pgsql.allow_persistent => On => On
    pgsql.max_persistent => Unlimited => Unlimited
    pgsql.max_links => Unlimited => Unlimited
    pgsql.auto_reset_persistent => Off => Off
    pgsql.ignore_notice => Off => Off
    pgsql.log_notice => Off => Off
    

    yum listing of official PostgreSQL 11 RPM packages
    Code (Text):
    yum list postgresql11 postgresql11-devel postgresql11-contrib postgresql11-libs postgresql11-server -q | tr -s ' ' | column -t
    Installed                    Packages
    postgresql11.x86_64          11.1-1PGDG.rhel7  @pgdg11
    postgresql11-contrib.x86_64  11.1-1PGDG.rhel7  @pgdg11
    postgresql11-devel.x86_64    11.1-1PGDG.rhel7  @pgdg11
    postgresql11-libs.x86_64     11.1-1PGDG.rhel7  @pgdg11
    postgresql11-server.x86_64   11.1-1PGDG.rhel7  @pgdg11
    

    pg_config output
    Code (Text):
    /usr/pgsql-11/bin/pg_config
    BINDIR = /usr/pgsql-11/bin
    DOCDIR = /usr/pgsql-11/doc
    HTMLDIR = /usr/pgsql-11/doc/html
    INCLUDEDIR = /usr/pgsql-11/include
    PKGINCLUDEDIR = /usr/pgsql-11/include
    INCLUDEDIR-SERVER = /usr/pgsql-11/include/server
    LIBDIR = /usr/pgsql-11/lib
    PKGLIBDIR = /usr/pgsql-11/lib
    LOCALEDIR = /usr/pgsql-11/share/locale
    MANDIR = /usr/pgsql-11/share/man
    SHAREDIR = /usr/pgsql-11/share
    SYSCONFDIR = /etc/sysconfig/pgsql
    PGXS = /usr/pgsql-11/lib/pgxs/src/makefiles/pgxs.mk
    CONFIGURE = '--enable-rpath' '--prefix=/usr/pgsql-11' '--includedir=/usr/pgsql-11/include' '--mandir=/usr/pgsql-11/share/man' '--datadir=/usr/pgsql-11/share' '--with-icu' 'CLANG=/opt/rh/llvm-toolset-7/root/usr/bin/clang' 'LLVM_CONFIG=/usr/lib64/llvm5.0/bin/llvm-config' '--with-llvm' '--with-perl' '--with-python' '--with-tcl' '--with-tclconfig=/usr/lib64' '--with-openssl' '--with-pam' '--with-gssapi' '--with-includes=/usr/include' '--with-libraries=/usr/lib64' '--enable-nls' '--enable-dtrace' '--with-uuid=e2fs' '--with-libxml' '--with-libxslt' '--with-ldap' '--with-selinux' '--with-systemd' '--with-system-tzdata=/usr/share/zoneinfo' '--sysconfdir=/etc/sysconfig/pgsql' '--docdir=/usr/pgsql-11/doc' '--htmldir=/usr/pgsql-11/doc/html' 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic' 'LDFLAGS=-Wl,--as-needed' 'PKG_CONFIG_PATH=:/usr/lib64/pkgconfig:/usr/share/pkgconfig'
    CC = gcc
    CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include
    CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic
    CFLAGS_SL = -fPIC
    LDFLAGS = -Wl,--as-needed -L/usr/lib64/llvm5.0/lib -L/usr/lib64 -Wl,--as-needed -Wl,-rpath,'/usr/pgsql-11/lib',--enable-new-dtags
    LDFLAGS_EX =
    LDFLAGS_SL =
    LIBS = -lpgcommon -lpgport -lpthread -lselinux -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lrt -lcrypt -ldl -lm
    VERSION = PostgreSQL 11.1
    

    all YUM RPM package postgresql11 and postgresql11-server binaries
    Code (Text):
    rpm -ql postgresql11-server postgresql11 | grep bin
    /usr/pgsql-11/bin/initdb
    /usr/pgsql-11/bin/pg_controldata
    /usr/pgsql-11/bin/pg_ctl
    /usr/pgsql-11/bin/pg_resetwal
    /usr/pgsql-11/bin/pg_verify_checksums
    /usr/pgsql-11/bin/postgres
    /usr/pgsql-11/bin/postgresql-11-check-db-dir
    /usr/pgsql-11/bin/postgresql-11-setup
    /usr/pgsql-11/bin/postmaster
    /usr/pgsql-11/bin/clusterdb
    /usr/pgsql-11/bin/createdb
    /usr/pgsql-11/bin/createuser
    /usr/pgsql-11/bin/dropdb
    /usr/pgsql-11/bin/dropuser
    /usr/pgsql-11/bin/pg_archivecleanup
    /usr/pgsql-11/bin/pg_basebackup
    /usr/pgsql-11/bin/pg_config
    /usr/pgsql-11/bin/pg_dump
    /usr/pgsql-11/bin/pg_dumpall
    /usr/pgsql-11/bin/pg_isready
    /usr/pgsql-11/bin/pg_receivewal
    /usr/pgsql-11/bin/pg_restore
    /usr/pgsql-11/bin/pg_rewind
    /usr/pgsql-11/bin/pg_test_fsync
    /usr/pgsql-11/bin/pg_test_timing
    /usr/pgsql-11/bin/pg_upgrade
    /usr/pgsql-11/bin/pg_waldump
    /usr/pgsql-11/bin/pgbench
    /usr/pgsql-11/bin/psql
    /usr/pgsql-11/bin/reindexdb
    /usr/pgsql-11/bin/vacuumdb
    /usr/pgsql-11/share/man/man3/SPI_getbinval.3
    


    Continue reading...

    123.09beta01 branch