Install PostgreSQL 9.4+

Arvados requires at least version 9.4 of PostgreSQL. We recommend using version 10 or newer.

AWS
CentOS 7
Debian or Ubuntu

AWS

When deploying on AWS, Arvados can use an Aurora RDS PostgreSQL database. Aurora Serverless is not recommended.

CentOS 7

Note:

On CentOS 7 and RHEL 7, 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, run:

~$ sudo yum install centos-release-scl scl-utils

To enable Software Collections on RHEL:

~$ sudo yum-config-manager --enable rhel-server-rhscl-7-rpms

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
```

Debian or Ubuntu

Debian 10 (Buster) and Ubuntu 16.04 (Xenial) and later versions include a sufficiently recent version of Postgres.

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
```

Previous: Configure container shell access Next: Install Ruby and Bundler