summaryrefslogtreecommitdiffstats
path: root/system/postgresql/README.SBo
diff options
context:
space:
mode:
Diffstat (limited to 'system/postgresql/README.SBo')
-rw-r--r--system/postgresql/README.SBo9
1 files changed, 6 insertions, 3 deletions
diff --git a/system/postgresql/README.SBo b/system/postgresql/README.SBo
index 48b30ddc28..c876890a36 100644
--- a/system/postgresql/README.SBo
+++ b/system/postgresql/README.SBo
@@ -5,7 +5,7 @@ the trick.
Additionally, a logrotation script and init script are included.
For production level log file handling please read
-http://www.postgresql.org/docs/8.4/interactive/logfile-maintenance.html
+http://www.postgresql.org/docs/9.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
@@ -25,13 +25,16 @@ the following files:
/etc/rc.d/rc.postgresql stop
fi
-Additionally, rc.postgresql script has additionalg modes for stop/restart:
+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
This script builds postgresql with some useful extension modules from
the contrib directory, see PG_EXTENSIONS in SlackBuild file.
+To build PostgreSQL with all extensions, use the following command:
+
+ # PG_EXTENSIONS=ALL ./postgresql.SlackBuild
Please note that in order to actually use extension, you must execute
-accompanying SQL scripts located in /usr/share/postgresql/contrib
+'CREATE EXTENSION [ IF NOT EXISTS ] extension_name' for each extension.