From 4911bc963f072a216abb4b9c15cfba679e6795b7 Mon Sep 17 00:00:00 2001 From: Adis Nezirovic Date: Mon, 6 Jan 2014 18:19:29 +0100 Subject: system/postgresql: Updated for version 9.3.2. More sensible defaults for database encoding and auth Misc cleanups Signed-off-by: Matteo Bernardini --- system/postgresql/README.SBo | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'system/postgresql/README.SBo') 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 -- cgit v1.2.3