From 5889a05587732f787714880b75612d0d059713cb Mon Sep 17 00:00:00 2001 From: Adis Nezirovic Date: Thu, 13 Oct 2016 21:11:08 +0700 Subject: system/postgresql: Updated for version 9.6.0. Signed-off-by: Willy Sudiarto Raharjo --- system/postgresql/README.SBo | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) (limited to 'system/postgresql/README.SBo') diff --git a/system/postgresql/README.SBo b/system/postgresql/README.SBo index e5151969e8..0bd4fc3f2e 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.5/data --locale=en_US.UTF-8 -A md5 -W" + # su postgres -c "initdb -D /var/lib/pgsql/9.6/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.5/interactive/logfile-maintenance.html +http://www.postgresql.org/docs/9.6/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,19 +28,19 @@ 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.5/static/app-pg-ctl.html +See http://www.postgresql.org/docs/9.6/static/app-pg-ctl.html From PostgreSQL 9.3 we support in place database upgrades using pg_upgrade: - http://www.postgresql.org/docs/9.5/static/pgupgrade.html + http://www.postgresql.org/docs/9.6/static/pgupgrade.html -A few hints for PostgreSQL 9.4 -> 9.5 upgrade: - - Don't remove old PostgreSQL 9.4.x package - - Install PostgreSQL 9.5.x, note that binaries are in - '/usr/lib64/postgresql/9.5/bin' +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' - 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.5.x-x86_64-1_SBo' (doinst.sh script) + - 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 -- cgit v1.2.3