Learn about Centmin Mod LEMP Stack today
Become a Member

Master Branch update optional PostgreSQL server install to version 11 branch in 123…

Discussion in 'Centmin Mod Github Commits' started by eva2000, Feb 12, 2019 at 11:01 AM.

  1. eva2000

    eva2000 Administrator Staff Member

    38,023
    8,349
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,862
    Local Time:
    11:54 PM
    Nginx 1.15.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 https://www.postgresql.org/docs/current/upgrading.html 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

    php-config --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 --enable-zip --with-bz2 --enable-soap --enable-sockets --enable-sysvmsg --enable-sysvsem --enable-sysvshm --enable-shmop --with-pear --enable-mbstring --with-openssl --with-mysql=mysqlnd --with-libdir=lib64 --with-mysqli=mysqlnd --with-mysql-sock=/var/lib/mysql/mysql.sock --with-curl --with-gd --with-xmlrpc --enable-bcmath --enable-calendar --enable-ftp --enable-gd-native-ttf --with-freetype-dir=/usr --with-jpeg-dir=/usr --with-png-dir=/usr --with-xpm-dir=/usr --with-webp-dir=/usr --with-t1lib=/usr --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 --disable-fileinfo --with-ldap --with-ldap-sasl --with-pgsql=/usr/pgsql-11 --with-pdo-pgsql=/usr/pgsql-11 --enable-huge-code-pages --with-config-file-scan-dir=/etc/centminmod/php.d --with-fpm-systemd --with-xsl

    PostgreSQL php extension after centmin.sh menu option 5 recompile

    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

    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

    /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

    Continue reading...

    Centmin Mod Github Master branch

    Master branch is where most recent commits are made as at May 24, 2015.
     
..