aboutsummaryrefslogtreecommitdiff
path: root/system
diff options
context:
space:
mode:
authorWilly Sudiarto Raharjo <willysr@slackbuilds.org>2021-12-08 13:14:02 +0700
committerWilly Sudiarto Raharjo <willysr@slackbuilds.org>2022-01-25 14:44:39 +0700
commit2e1e179158c17d3c2ea4109c5002852ca7140c9c (patch)
tree487a4b9cb2eeec0c890f4b3ccff9cf2890e6e548 /system
parentd0f395d52c3d9cfe03e0984331762d89a9b933a5 (diff)
downloadslackbuilds-2e1e179158c17d3c2ea4109c5002852ca7140c9c.tar.xz
system/postgresql: Updated for version 14.1.
Signed-off-by: Willy Sudiarto Raharjo <willysr@slackbuilds.org> Signed-off-by: Andrew Clemons <andrew.clemons@gmail.com>
Diffstat (limited to 'system')
-rw-r--r--system/postgresql/README.SBo27
-rw-r--r--system/postgresql/postgresql.SlackBuild6
-rw-r--r--system/postgresql/postgresql.info6
3 files changed, 14 insertions, 25 deletions
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=""