3 navsection: installguide
4 title: Install PostgreSQL 9.4+
7 Copyright (C) The Arvados Authors. All rights reserved.
9 SPDX-License-Identifier: CC-BY-SA-3.0
12 Arvados requires at least version *9.4* of PostgreSQL. We recommend using version 10 or newer.
16 * "Debian or Ubuntu":#debian
20 When deploying on AWS, Arvados can use an Aurora RDS PostgreSQL database. Aurora Serverless is not recommended.
22 h3(#centos7). CentOS 7
23 {% assign rh_version = "7" %}
24 {% include 'note_python_sc' %}
27 <notextile><pre># <span class="userinput">yum install rh-postgresql12 rh-postgresql12-postgresql-contrib</span>
28 ~$ <span class="userinput">scl enable rh-postgresql12 bash</span></pre></notextile>
29 # Initialize the database
30 <notextile><pre># <span class="userinput">postgresql-setup initdb</span></pre></notextile>
31 # Configure the database to accept password connections
32 <notextile><pre><code># <span class="userinput">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>
33 # Configure the database to launch at boot and start now
34 <notextile><pre># <span class="userinput">systemctl enable --now rh-postgresql12-postgresql</span></pre></notextile>
36 h3(#debian). Debian or Ubuntu
38 Debian 10 (Buster) and Ubuntu 16.04 (Xenial) and later versions include a sufficiently recent version of Postgres.
41 <notextile><pre># <span class="userinput">apt-get --no-install-recommends install postgresql postgresql-contrib</span></pre></notextile>
42 # Configure the database to launch at boot and start now
43 <notextile><pre># <span class="userinput">systemctl enable --now postgresql</span></pre></notextile>