summaryrefslogtreecommitdiff
path: root/system/postgresql/README.SBo
diff options
context:
space:
mode:
authorAdis Nezirovic <adis_at_linux.org.ba>2018-02-11 14:53:38 +0000
committerWilly Sudiarto Raharjo <willysr@slackbuilds.org>2018-02-17 07:42:53 +0700
commit0023a1b9b9ba676fdc86f42f30f603a4be918b40 (patch)
tree138cf0ebf427bdcd3fba9c5bfbc01f845d296fb9 /system/postgresql/README.SBo
parenta5a29c0aabee4ba7105e6e133e35fea0455221ce (diff)
downloadslackbuilds-0023a1b9b9ba676fdc86f42f30f603a4be918b40.tar.gz
system/postgresql: Updated for version 10.2.
Signed-off-by: David Spencer <idlemoor@slackbuilds.org>
Diffstat (limited to 'system/postgresql/README.SBo')
-rw-r--r--system/postgresql/README.SBo21
1 files changed, 10 insertions, 11 deletions
diff --git a/system/postgresql/README.SBo b/system/postgresql/README.SBo
index 04080f0be4..d4b48e11d7 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/9.6/data --locale=en_US.UTF-8 -A md5 -W --data-checksums"
+ # su postgres -c "initdb -D /var/lib/pgsql/10.2/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/9.6/interactive/logfile-maintenance.html
+http://www.postgresql.org/docs/10.2/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,21 +28,20 @@ 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/9.6/static/app-pg-ctl.html
+See http://www.postgresql.org/docs/10.2/static/app-pg-ctl.html
From PostgreSQL 9.3 we support in place database upgrades using pg_upgrade:
- http://www.postgresql.org/docs/9.6/static/pgupgrade.html
+ http://www.postgresql.org/docs/10.2/static/pgupgrade.html
-A few hints for PostgreSQL 9.5 -> 9.6 upgrade:
- - Don't remove old PostgreSQL 9.5.x package
- - Install PostgreSQL 9.6.x, note that binaries are in
- '/usr/lib64/postgresql/9.6/bin'
+A few hints for PostgreSQL 9.6 -> 10.2 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'
- 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
- - Run '/var/log/scripts/postgresql-9.6.x-x86_64-1_SBo' (doinst.sh script)
- from filesystem root, to create symlinks in /usr/bin to PostgreSQL binaries
-
+ - Check the /usr/bin for stale symlinks for old binaries_
+ e.g. in v10.0 pg_xlogdump got renamed to pg_waldump.
This script builds postgresql with some useful extension modules from
the contrib directory, see PG_EXTENSIONS in SlackBuild file.