X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/03ab4eb9958846104db35b6da50749ff9212655a..HEAD:/doc/install/install-postgresql.html.textile.liquid?ds=sidebyside
diff --git a/doc/install/install-postgresql.html.textile.liquid b/doc/install/install-postgresql.html.textile.liquid
index 3498d5b9fe..56ad95635c 100644
--- a/doc/install/install-postgresql.html.textile.liquid
+++ b/doc/install/install-postgresql.html.textile.liquid
@@ -9,39 +9,57 @@ Copyright (C) The Arvados Authors. All rights reserved.
SPDX-License-Identifier: CC-BY-SA-3.0
{% endcomment %}
-Arvados requires at least version *9.4* of PostgreSQL.
+Arvados requires at least version *9.4* of PostgreSQL. We recommend using version 10 or newer.
+* "AWS":#aws
* "CentOS 7":#centos7
+* "Alma/CentOS/Red Hat/Rocky 8":#rh8
* "Debian or Ubuntu":#debian
+h3(#aws). AWS
+
+When deploying on AWS, Arvados can use an Aurora RDS PostgreSQL database. Aurora Serverless is not recommended.
+
h3(#centos7). CentOS 7
{% assign rh_version = "7" %}
{% include 'note_python_sc' %}
-# Install PostgreSQL:
- ~$ sudo yum install rh-postgresql95 rh-postgresql95-postgresql-contrib
-~$ scl enable rh-postgresql95 bash
-# Initialize the database:
- ~$ sudo postgresql-setup initdb
-# Configure the database to accept password connections:
- ~$ sudo sed -ri -e 's/^(host +all +all +(127\.0\.0\.1\/32|::1\/128) +)ident$/\1md5/' /var/lib/pgsql/data/pg_hba.conf
-# Configure the database to launch at boot:
- ~$ sudo systemctl enable rh-postgresql95-postgresql
-# Start the database:
- ~$ sudo systemctl start rh-postgresql95-postgresql
+# Install PostgreSQL
+ # yum install rh-postgresql12 rh-postgresql12-postgresql-contrib
+~$ scl enable rh-postgresql12 bash
+# Initialize the database
+ # postgresql-setup initdb
+# Configure the database to accept password connections from localhost
+ # sed -ri -e 's/^(host +all +all +(127\.0\.0\.1\/32|::1\/128) +)ident$/\1md5/' /var/lib/pgsql/data/pg_hba.conf
+# Configure the database to accept password connections from the local network (replace @10.9.8.0/24@ with your private network mask)
+ # echo 'host all all 10.9.8.0/24 md5' | tee -a /var/lib/pgsql/data/pg_hba.conf
+# Configure the database to launch at boot and start now
+ # systemctl enable --now rh-postgresql12-postgresql
-h3(#debian). Debian or Ubuntu
+h3(#rh8). Alma/CentOS/Red Hat/Rocky 8
-Debian 8 (Jessie) and Ubuntu 16.04 (Xenial) and later versions include a sufficiently recent version of Postgres.
+{% comment %}
+The default version on RH8 is PostgreSQL 10. You can install up to PostgreSQL 13.
+{% endcomment %}
-Ubuntu 14.04 (Trusty) requires an updated PostgreSQL version, see "the PostgreSQL ubuntu repository":https://www.postgresql.org/download/linux/ubuntu/
+# Install PostgreSQL
+ # dnf install postgresql-server postgresql-contrib
+# Initialize the database
+ # postgresql-setup initdb
+# Configure the database to accept password connections from localhost
+ # sed -ri -e 's/^(host +all +all +(127\.0\.0\.1\/32|::1\/128) +)ident$/\1md5/' /var/lib/pgsql/data/pg_hba.conf
+# Configure the database to accept password connections from the local network (replace @10.9.8.0/24@ with your private network mask)
+ # echo 'host all all 10.9.8.0/24 md5' | tee -a /var/lib/pgsql/data/pg_hba.conf
+# Configure the database to launch at boot and start now
+ # systemctl enable --now postgresql
-# Install PostgreSQL:
- ~$ sudo apt-get install postgresql postgresql-contrib
+h3(#debian). Debian or Ubuntu
-h2(#sso). Set up SSO server credentials and database
+Debian 10 (Buster) and Ubuntu 16.04 (Xenial) and later versions include a sufficiently recent version of Postgres.
-{% assign service_role = "arvados_sso" %}
-{% assign service_database = "arvados_sso_production" %}
-{% assign use_contrib = false %}
-{% include 'install_postgres_database' %}
+# Install PostgreSQL
+# apt-get --no-install-recommends install postgresql postgresql-contrib
+# Configure PostgreSQL to accept password connections from the local network (replace @10.9.8.0/24@ with your private network mask)
+# echo 'host all all 10.9.8.0/24 md5' | tee -a /etc/postgresql/*/main/pg_hba.conf
+# Configure the database to launch at boot and start now
+# systemctl enable --now postgresql