diff options
Diffstat (limited to 'system/postgresql/README.SBo')
| -rw-r--r-- | system/postgresql/README.SBo | 22 |
1 files changed, 16 insertions, 6 deletions
diff --git a/system/postgresql/README.SBo b/system/postgresql/README.SBo index 6ec5736c3c..80148572e0 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.3/data --locale=en_US.UTF-8 -A md5 -W" + # su postgres -c "initdb -D /var/lib/pgsql/9.4/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.3/interactive/logfile-maintenance.html +http://www.postgresql.org/docs/9.4/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,12 +28,12 @@ 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.3/static/app-pg-ctl.html +See http://www.postgresql.org/docs/9.4/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 (future) PostgreSQL 9.3 -> 9.4 upgrade: +A few hints for 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' @@ -50,5 +50,15 @@ 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 -'CREATE EXTENSION [ IF NOT EXISTS ] extension_name' for each extension. +Please note that in order to actually use extension, you must execute 'CREATE EXTENSION [ IF NOT EXISTS ] extension_name' for each extension. + +OpenLDAP Notes + +With OpenLDAP versions 2.4.24 through 2.4.31, inclusive, each backend +process that loads libpq (via WAL receiver, dblink, or postgres_fdw) and +also uses LDAP will crash on exit. + +The LDAP wont be enabled (regardless of '--with-ldap' flag in slackbuild) +for affected OpenLDAP versions, so we've removed that build flag alltogether. + +(OpenLDAP 2.4.31 is the version included in Slackware 14.1) |