aboutsummaryrefslogtreecommitdiff
path: root/system/postgresql/README.SBo
diff options
context:
space:
mode:
authorAdis Nezirovic <adis_at_linux.org.ba>2013-10-26 00:40:32 -0500
committerRobby Workman <rworkman@slackbuilds.org>2013-10-27 23:38:51 -0500
commitb81b97324fb0fd50f5a9e29c974c25744a7f1e2d (patch)
treea29383f2e861b9a67efcb670c8c72fd9832425fd /system/postgresql/README.SBo
parent319f898b5f28a560edd68c09dcc7c8facecf0280 (diff)
system/postgresql: Updated for version 9.3.0.
Signed-off-by: Robby Workman <rworkman@slackbuilds.org>
Diffstat (limited to 'system/postgresql/README.SBo')
-rw-r--r--system/postgresql/README.SBo20
1 files changed, 17 insertions, 3 deletions
diff --git a/system/postgresql/README.SBo b/system/postgresql/README.SBo
index c876890a367b1..95ff14e57af04 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/data"
+ # su postgres -c "initdb -D /var/lib/pgsql/9.3/data"
Additionally, a logrotation script and init script are included.
For production level log file handling please read
-http://www.postgresql.org/docs/9.2/interactive/logfile-maintenance.html
+http://www.postgresql.org/docs/9.3/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,7 +28,21 @@ 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/8.4/static/app-pg-ctl.html
+See http://www.postgresql.org/docs/9.3/static/app-pg-ctl.html
+
+From PostgreSQL 9.3 we support in place database upgrades using pg_upgrade:
+ http://www.postgresql.org/docs/9.3/static/pgupgrade.html
+
+A few hints for PostgreSQL 9.2 -> 9.3 upgrade:
+ - Don't remove old PostgreSQL 9.2.x package
+ - Install PostgreSQL 9.3, note that binaries are in
+ '/usr/lib64/postgresql/9.3/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.3.0-x86_64-1_SBo' (doinst.sh script)
+ from filesystem root, to create symlinks in /usr/bin to PostgreSQL binaries
+
This script builds postgresql with some useful extension modules from
the contrib directory, see PG_EXTENSIONS in SlackBuild file.