summaryrefslogtreecommitdiffstats
path: root/system/postgresql/README.SBo
diff options
context:
space:
mode:
author Adis Nezirovic2014-01-06 18:19:29 +0100
committer Erik Hanson2014-01-07 18:13:07 +0100
commit4911bc963f072a216abb4b9c15cfba679e6795b7 (patch)
tree62eac071981816f072f0bc171c3da1725fa90d50 /system/postgresql/README.SBo
parent11a427aed5293863f0798045ba9fd9ac57da246c (diff)
downloadslackbuilds-4911bc963f072a216abb4b9c15cfba679e6795b7.tar.gz
system/postgresql: Updated for version 9.3.2.
More sensible defaults for database encoding and auth Misc cleanups Signed-off-by: Matteo Bernardini <ponce@slackbuilds.org>
Diffstat (limited to 'system/postgresql/README.SBo')
-rw-r--r--system/postgresql/README.SBo12
1 files changed, 6 insertions, 6 deletions
diff --git a/system/postgresql/README.SBo b/system/postgresql/README.SBo
index 95ff14e57a..f5ab595037 100644
--- a/system/postgresql/README.SBo
+++ b/system/postgresql/README.SBo
@@ -1,7 +1,7 @@
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.3/data"
+ # su postgres -c "initdb -D /var/lib/pgsql/9.3/data -E utf-8 -A md5 -W"
Additionally, a logrotation script and init script are included.
For production level log file handling please read
@@ -33,14 +33,14 @@ 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'
+A few hints for (future) PostgreSQL 9.3 -> 9.4 upgrade:
+ - Don't remove old PostgreSQL 9.3.x package
+ - Install PostgreSQL 9.4.x, note that binaries are in
+ '/usr/lib64/postgresql/9.4/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)
+ - Run '/var/log/scripts/postgresql-9.4.x-x86_64-1_SBo' (doinst.sh script)
from filesystem root, to create symlinks in /usr/bin to PostgreSQL binaries