From 2e1e179158c17d3c2ea4109c5002852ca7140c9c Mon Sep 17 00:00:00 2001 From: Willy Sudiarto Raharjo Date: Wed, 8 Dec 2021 13:14:02 +0700 Subject: system/postgresql: Updated for version 14.1. Signed-off-by: Willy Sudiarto Raharjo Signed-off-by: Andrew Clemons --- system/postgresql/README.SBo | 27 ++++++++------------------- system/postgresql/postgresql.SlackBuild | 6 +++--- system/postgresql/postgresql.info | 6 +++--- 3 files changed, 14 insertions(+), 25 deletions(-) (limited to 'system') diff --git a/system/postgresql/README.SBo b/system/postgresql/README.SBo index d4b48e11d77e..a303cc84ac0f 100644 --- a/system/postgresql/README.SBo +++ b/system/postgresql/README.SBo @@ -1,11 +1,11 @@ Before you can run postgresql you'll need to create the database files in /var/lib/pgsql. The following should do the trick. - # su postgres -c "initdb -D /var/lib/pgsql/10.2/data --locale=en_US.UTF-8 -A md5 -W" + # su postgres -c "initdb -D /var/lib/pgsql/14.1/data --locale=en_US.UTF-8 -A md5 -W" Additionally, a logrotation script and init script are included. For production level log file handling please read -http://www.postgresql.org/docs/10.2/interactive/logfile-maintenance.html +http://www.postgresql.org/docs/14/interactive/logfile-maintenance.html In order to start postgresql at boot and stop it properly at shutdown, make sure rc.postgresql is executable and add the following lines to @@ -28,15 +28,15 @@ the following files: Additionally, rc.postgresql script has additional modes for stop/restart: force-stop|force-restart (i.e. pg_ctl 'fast' mode) unclean-stop|unclean-restart (i.e. pg_ctl 'immediate' mode) -See http://www.postgresql.org/docs/10.2/static/app-pg-ctl.html +See http://www.postgresql.org/docs/14/app-pg-ctl.html -From PostgreSQL 9.3 we support in place database upgrades using pg_upgrade: - http://www.postgresql.org/docs/10.2/static/pgupgrade.html +From PostgreSQL 9.6 we support in place database upgrades using pg_upgrade: + http://www.postgresql.org/docs/14/pgupgrade.html -A few hints for PostgreSQL 9.6 -> 10.2 upgrade: +A few hints for PostgreSQL 9.6 -> X.Y upgrade: - Don't remove old PostgreSQL 9.6.x package - - Install PostgreSQL 10.2.x, note that binaries are in - '/usr/lib64/postgresql/10.2/bin' + - Install PostgreSQL X.Y, note that binaries are in + '/usr/lib64/postgresql/X.Y/bin' - Follow regular pg_upgrade docs - Remove old package when transition is over, or read comments in rc.postgresql if you want to run multiple PostgreSQL versions in parallel @@ -51,14 +51,3 @@ To build PostgreSQL with all extensions, use the following command: Please note that in order to actually use extension, you must execute 'CREATE EXTENSION [ IF NOT EXISTS ] extension_name' for each extension. - -OpenLDAP Notes - -With OpenLDAP versions 2.4.24 through 2.4.31, inclusive, each backend -process that loads libpq (via WAL receiver, dblink, or postgres_fdw) and -also uses LDAP will crash on exit. - -The LDAP wont be enabled (regardless of '--with-ldap' flag in slackbuild) -for affected OpenLDAP versions, so we've removed that build flag alltogether. - -(OpenLDAP 2.4.31 is the version included in Slackware 14.1) diff --git a/system/postgresql/postgresql.SlackBuild b/system/postgresql/postgresql.SlackBuild index 57045bb60fb8..366c363e320c 100644 --- a/system/postgresql/postgresql.SlackBuild +++ b/system/postgresql/postgresql.SlackBuild @@ -27,12 +27,12 @@ cd $(dirname $0) ; CWD=$(pwd) PRGNAM=postgresql -VERSION=${VERSION:-10.17} +VERSION=${VERSION:-14.1} BUILD=${BUILD:-1} TAG=${TAG:-_SBo} PKGTYPE=${PKGTYPE:-tgz} -PG_VERSION=${PG_VERSION:-10.17} +PG_VERSION=${PG_VERSION:-14.1} PG_PORT=${PG_PORT:-5432} PG_UID=${PG_UID:-209} PG_GID=${PG_GID:-209} @@ -142,7 +142,7 @@ make install-docs DESTDIR=$PKG ) # Some interesting additional modules: -# https://www.postgresql.org/docs/10/contrib.html +# https://www.postgresql.org/docs/14/contrib.html # # adminpack - helper extension for pgAdmin # pgcrypto - extension for some business applications diff --git a/system/postgresql/postgresql.info b/system/postgresql/postgresql.info index cd4def779b80..e531bca2ff4c 100644 --- a/system/postgresql/postgresql.info +++ b/system/postgresql/postgresql.info @@ -1,8 +1,8 @@ PRGNAM="postgresql" -VERSION="10.17" +VERSION="14.1" HOMEPAGE="https://www.postgresql.org" -DOWNLOAD="https://ftp.postgresql.org/pub/source/v10.17/postgresql-10.17.tar.gz" -MD5SUM="db221f79265f849616d719f3fe168d44" +DOWNLOAD="https://ftp.postgresql.org/pub/source/v14.1/postgresql-14.1.tar.gz" +MD5SUM="882ba38db78cc5f103f701fc68f50293" DOWNLOAD_x86_64="" MD5SUM_x86_64="" REQUIRES="" -- cgit v1.2.3