12032: Update install guide to specify minimum Postgres version of 9.3

Include instructions for using SCL to get a newer Postgres on CentOS7.

Arvados-DCO-1.1-Signed-off-by: Peter Amstutz <pamstutz@veritasgenetics.com>

diff --git a/doc/_includes/_note_python_sc.liquid b/doc/_includes/_note_python_sc.liquid
index ae273f7953c340844906f37cb172ba3997a53bda..4b081770a7bcca85ffed730de459b51863d63eca 100644 (file)
--- a/doc/_includes/_note_python_sc.liquid
+++ b/doc/_includes/_note_python_sc.liquid
@@ -8,7 +8,7 @@ SPDX-License-Identifier: CC-BY-SA-3.0
 
 {% if rh_version %} On CentOS {{rh_version}} and RHEL {{rh_version}},
 {% else %} On CentOS and RHEL,
-{% endif %} these packages require a more recent version of Python from Software Collections.  The Software Collection will be installed automatically as long as Software Collections are enabled on your system.
+{% endif %} these packages require a more recent version from Software Collections.  The Software Collection will be installed automatically as long as Software Collections are enabled on your system.
 
 To "enable Software Collections on CentOS":https://wiki.centos.org/AdditionalResources/Repositories/SCL, run:
 
@@ -17,6 +17,13 @@ To "enable Software Collections on CentOS":https://wiki.centos.org/AdditionalRes
 </code></pre>
 </notextile>
 
-To enable Software Collections on RHEL, "follow section 2.1 of Red Hat's Installation chapter":https://access.redhat.com/documentation/en-US/Red_Hat_Software_Collections/2/html/2.0_Release_Notes/chap-Installation.html.
+To enable Software Collections on RHEL:
+
+<notextile>
+<pre><code>~$ <span class="userinput">sudo yum-config-manager --enable rhel-server-rhscl-7-rpms</span>
+</code></pre>
+</notextile>
+
+"See also section 2.1 of Red Hat's Installation chapter":https://access.redhat.com/documentation/en-US/Red_Hat_Software_Collections/2/html/2.0_Release_Notes/chap-Installation.html .
 
 {% include 'notebox_end' %}

diff --git a/doc/install/install-postgresql.html.textile.liquid b/doc/install/install-postgresql.html.textile.liquid
index 08d51e4251d81abb3225429593a213ec461059d9..599730926a0f29bf17b4ef73c6aa2a0a6ee75cef 100644 (file)
--- a/doc/install/install-postgresql.html.textile.liquid
+++ b/doc/install/install-postgresql.html.textile.liquid
@@ -9,28 +9,37 @@ Copyright (C) The Arvados Authors. All rights reserved.
 SPDX-License-Identifier: CC-BY-SA-3.0
 {% endcomment %}
 
-Two Arvados Rails servers store data in a PostgreSQL database: the SSO server, and the API server.  The API server requires at least version 9.1 of PostgreSQL.  Beyond that, you have the flexibility to deploy PostgreSQL any way that the Rails servers will be able to connect to it.  Our recommended deployment strategy is:
+Two Arvados Rails servers store data in a PostgreSQL database: the SSO server, and the API server.  The API server requires at least version *9.3* of PostgreSQL.  Beyond that, you have the flexibility to deploy PostgreSQL any way that the Rails servers will be able to connect to it.  Our recommended deployment strategy is:
 
 * Install PostgreSQL on the the same host as the SSO server, and dedicate that install to hosting the SSO database.  This provides the best security for the SSO server, because the database does not have to accept any client connections over the network.  Typical load on the SSO server is light enough that deploying both it and its database on the same host does not compromise performance.
 * If you want to provide the most scalability for your Arvados cluster, install PostgreSQL for the API server on a dedicated host.  This gives you the most flexibility to avoid resource contention, and tune performance separately for the API server and its database.  If performance is less of a concern for your installation, you can install PostgreSQL on the API server host directly, as with the SSO server.
 
 Find the section for your distribution below, and follow it to install PostgreSQL on each host where you will deploy it.  Then follow the steps in the later section(s) to set up PostgreSQL for the Arvados service(s) that need it.
 
-h2(#centos7). Install PostgreSQL on CentOS 7
+h2. Install PostgreSQL 9.3+
+
+The API server requires at least version *9.3* of PostgreSQL.
+
+h3(#centos7). CentOS 7
+{% assign rh_version = "7" %}
+{% include 'note_python_sc' %}
 
 # Install PostgreSQL:
-  <notextile><pre>~$ <span class="userinput">sudo yum install postgresql-server</span></pre></notextile>
+  <notextile><pre>~$ <span class="userinput">sudo yum install rh-postgresql95</span>
+~$ <span class="userinput">scl enable rh-postgresql95 bash</span></pre></notextile>
 # Initialize the database:
   <notextile><pre>~$ <span class="userinput">sudo postgresql-setup initdb</span></pre></notextile>
 # Configure the database to accept password connections:
   <notextile><pre><code>~$ <span class="userinput">sudo sed -ri -e 's/^(host +all +all +(127\.0\.0\.1\/32|::1\/128) +)ident$/\1md5/' /var/lib/pgsql/data/pg_hba.conf</span></code></pre></notextile>
 # Configure the database to launch at boot:
-  <notextile><pre>~$ <span class="userinput">sudo systemctl enable postgresql</span></pre></notextile>
+  <notextile><pre>~$ <span class="userinput">sudo systemctl enable rh-postgresql95-postgresql</span></pre></notextile>
 # Start the database:
-  <notextile><pre>~$ <span class="userinput">sudo systemctl start postgresql</span></pre></notextile>
+  <notextile><pre>~$ <span class="userinput">sudo systemctl start rh-postgresql95-postgresql</span></pre></notextile>
 # "Set up Arvados credentials and databases":#rails_setup for the services that will use this PostgreSQL install.
 
-h2(#debian). Install PostgreSQL on Debian or Ubuntu
+h3(#debian). Debian or Ubuntu
+
+Debian 8 (Jessie) and Ubuntu 14.04 (Trusty) and later versions include a sufficiently recent version of Postgres.
 
 # Install PostgreSQL:
   <notextile><pre>~$ <span class="userinput">sudo apt-get install postgresql</span></pre></notextile>

diff --git a/doc/install/install-shell-server.html.textile.liquid b/doc/install/install-shell-server.html.textile.liquid
index 135faeea97e77813ebdd3fdcfd3165b65dcff613..b8ffcc54b3d41643777ede7b9fb027f436751c3c 100644 (file)
--- a/doc/install/install-shell-server.html.textile.liquid
+++ b/doc/install/install-shell-server.html.textile.liquid
@@ -47,7 +47,7 @@ If you're not using RVM:
 
 h2. Install the Python SDK and utilities
 
-{% assign rh_version = "6" %}
+{% assign rh_version = "7" %}
 {% include 'note_python_sc' %}
 
 On Red Hat-based systems:

diff --git a/doc/install/install-workbench-app.html.textile.liquid b/doc/install/install-workbench-app.html.textile.liquid
index 316609aec6fbbfc705dfa0e2dd5d50a7ada77fea..593e8018926ad42c0f8a22d6f67fa73c3c1ba7c1 100644 (file)
--- a/doc/install/install-workbench-app.html.textile.liquid
+++ b/doc/install/install-workbench-app.html.textile.liquid
@@ -21,7 +21,7 @@ h2(#install_workbench). Install Workbench and dependencies
 
 Workbench doesn't need its own database, so it does not need to have PostgreSQL installed.
 
-{% assign rh_version = "6" %}
+{% assign rh_version = "7" %}
 {% include 'note_python_sc' %}
 
 On a Debian-based system, install the following packages: