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

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

• Branch: centminmod/centminmod
• Commit History: centminmod/centminmod