LP#1830749: Bump minimum PostgreSQL version to 9.6

Update README and upgrade notes to reflect that new minimum PostgreSQL 9.6.

Also change all sources to draw from PostgreSQL community repo for
consistency across all supported distributions.

Signed-off-by: Ben Shum <ben@evergreener.net>
Signed-off-by: Jason Stephenson <jason@sigio.com>
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>

diff --git a/Open-ILS/src/extras/install/Makefile.debian-jessie b/Open-ILS/src/extras/install/Makefile.debian-jessie
index 55bb457..fb6f055 100644 (file)
--- a/Open-ILS/src/extras/install/Makefile.debian-jessie
+++ b/Open-ILS/src/extras/install/Makefile.debian-jessie
@@ -69,7 +69,7 @@ export DEBS = \
        libuniversal-require-perl\
        libunix-syslog-perl\
        libyaz-dev\
-       postgresql-client-9.4\
+       postgresql-client-9.6\
        libsoap-lite-perl\
        libbz2-dev\
        libparse-recdescent-perl\
@@ -100,12 +100,12 @@ export CPAN_MODULES_FORCE = \
        Business::Stripe \
        Class::DBI::Frozen::301
 
-PGSQL_SERVER_DEBS_94 = \
+PGSQL_SERVER_DEBS_96 = \
        $(DEB_PGSQL_COMMON_MODS) \
-       postgresql-9.4 \
-       postgresql-contrib-9.4 \
-       postgresql-plperl-9.4 \
-       postgresql-server-dev-9.4
+       postgresql-9.6 \
+       postgresql-contrib-9.6 \
+       postgresql-plperl-9.6 \
+       postgresql-server-dev-9.6
 
 # note: some prereqs are repeated in the developer/packager 
 # sections to support building Evergreen packages on servers
@@ -136,13 +136,17 @@ TRANSLATOR_DEBS = \
        bzr
 
 all:
+       make -f $(DIR)/Makefile.debian DEBS="$(PGSQL_APT_REPO_DEBS)"
+       make -f $(DIR)/Makefile.debian debian_postgresql_repo
        make -f $(DIR)/Makefile.debian install_debs
        make -f $(DIR)/Makefile.common install_cpan
        make -f $(DIR)/Makefile.common install_cpan_force
        make -f $(DIR)/Makefile.debian debian_sys_config
 
 install_postgres_server:
-       make -f $(DIR)/Makefile.debian DEBS="$(PGSQL_SERVER_DEBS_94)"
+       make -f $(DIR)/Makefile.debian DEBS="$(PGSQL_APT_REPO_DEBS)"
+       make -f $(DIR)/Makefile.debian debian_postgresql_repo
+       make -f $(DIR)/Makefile.debian DEBS="$(PGSQL_SERVER_DEBS_96)"
 
 # note: if/when grunt-cli is available as a
 # package, use the packaged version instead.

diff --git a/Open-ILS/src/extras/install/Makefile.debian-stretch b/Open-ILS/src/extras/install/Makefile.debian-stretch
index 2076124..342d71a 100644 (file)
--- a/Open-ILS/src/extras/install/Makefile.debian-stretch
+++ b/Open-ILS/src/extras/install/Makefile.debian-stretch
@@ -135,12 +135,16 @@ TRANSLATOR_DEBS = \
        bzr
 
 all:
+       make -f $(DIR)/Makefile.debian DEBS="$(PGSQL_APT_REPO_DEBS)"
+       make -f $(DIR)/Makefile.debian debian_postgresql_repo
        make -f $(DIR)/Makefile.debian install_debs
        make -f $(DIR)/Makefile.common install_cpan
        make -f $(DIR)/Makefile.common install_cpan_force
        make -f $(DIR)/Makefile.debian debian_sys_config
 
 install_postgres_server:
+       make -f $(DIR)/Makefile.debian DEBS="$(PGSQL_APT_REPO_DEBS)"
+       make -f $(DIR)/Makefile.debian debian_postgresql_repo
        make -f $(DIR)/Makefile.debian DEBS="$(PGSQL_SERVER_DEBS_96)"
 
 # note: if/when grunt-cli is available as a

diff --git a/Open-ILS/src/extras/install/Makefile.ubuntu-xenial b/Open-ILS/src/extras/install/Makefile.ubuntu-xenial
index 0f6ed65..aa8bb44 100644 (file)
--- a/Open-ILS/src/extras/install/Makefile.ubuntu-xenial
+++ b/Open-ILS/src/extras/install/Makefile.ubuntu-xenial
@@ -68,7 +68,7 @@ export DEBS = \
        libuniversal-require-perl\
        libunix-syslog-perl\
        libyaz-dev\
-       postgresql-client-9.5\
+       postgresql-client-9.6\
        libsoap-lite-perl\
        libbz2-dev\
        libparse-recdescent-perl\
@@ -99,12 +99,12 @@ export CPAN_MODULES_FORCE = \
        Business::Stripe \
        Class::DBI::Frozen::301
 
-PGSQL_SERVER_DEBS_95 = \
+PGSQL_SERVER_DEBS_96 = \
        $(DEB_PGSQL_COMMON_MODS) \
-       postgresql-9.5 \
-       postgresql-contrib-9.5 \
-       postgresql-plperl-9.5 \
-       postgresql-server-dev-9.5
+       postgresql-9.6 \
+       postgresql-contrib-9.6 \
+       postgresql-plperl-9.6 \
+       postgresql-server-dev-9.6
 
 # note: some prereqs are repeated in the developer/packager 
 # sections to support building Evergreen packages on servers
@@ -135,13 +135,17 @@ TRANSLATOR_DEBS = \
        bzr
 
 all:
+       make -f $(DIR)/Makefile.debian DEBS="$(PGSQL_APT_REPO_DEBS)"
+       make -f $(DIR)/Makefile.debian debian_postgresql_repo
        make -f $(DIR)/Makefile.debian install_debs
        make -f $(DIR)/Makefile.common install_cpan
        make -f $(DIR)/Makefile.common install_cpan_force
        make -f $(DIR)/Makefile.debian debian_sys_config
 
 install_postgres_server:
-       make -f $(DIR)/Makefile.debian DEBS="$(PGSQL_SERVER_DEBS_95)"
+       make -f $(DIR)/Makefile.debian DEBS="$(PGSQL_APT_REPO_DEBS)"
+       make -f $(DIR)/Makefile.debian debian_postgresql_repo
+       make -f $(DIR)/Makefile.debian DEBS="$(PGSQL_SERVER_DEBS_96)"
 
 # note: if/when grunt-cli is available as a
 # package, use the packaged version instead.

diff --git a/docs/installation/server_installation.adoc b/docs/installation/server_installation.adoc
index d9443a3..1f77011 100644 (file)
--- a/docs/installation/server_installation.adoc
+++ b/docs/installation/server_installation.adoc
@@ -54,7 +54,7 @@ autoreconf -i
 Installing prerequisites
 ------------------------
 
-  * **PostgreSQL**: The minimum supported version is 9.4.
+  * **PostgreSQL**: The minimum supported version is 9.6.
   * **Linux**: Evergreen has been tested on 
     Debian Buster (10), 
     Debian Stretch (9), 
@@ -513,10 +513,10 @@ Creating the database on a remote server
 In a production instance of Evergreen, your PostgreSQL server should be
 installed on a dedicated server.
 
-PostgreSQL 9.4 and later
+PostgreSQL 9.6 and later
 ^^^^^^^^^^^^^^^^^^^^^^^^
 To create the database instance on a remote database server running PostgreSQL
-9.4 or later, simply use the `--create-database` flag on `eg_db_config`.
+9.6 or later, simply use the `--create-database` flag on `eg_db_config`.
 
 Starting Evergreen
 ------------------

diff --git a/docs/installation/server_upgrade.adoc b/docs/installation/server_upgrade.adoc
index 72b2a1a..41d8627 100644 (file)
--- a/docs/installation/server_upgrade.adoc
+++ b/docs/installation/server_upgrade.adoc
@@ -6,7 +6,7 @@ All of the steps in this chapter are to be completed from the command line.
 Software Prerequisites
 ~~~~~~~~~~~~~~~~~~~~~~
 
-  * **PostgreSQL**: The minimum supported version is 9.4.
+  * **PostgreSQL**: The minimum supported version is 9.6.
   * **Linux**: Evergreen 3.X.X has been tested on Debian Stretch (9.0),
     Debian Jessie (8.0), Ubuntu Xenial Xerus (16.04), and Ubuntu Bionic Beaver (18.04).
     If you are running an older version of these distributions, you may want