Install PostgreSQL 9.4+

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

• AWS
• Red Hat, AlmaLinux, and Rocky Linux
• Debian or Ubuntu

AWS

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

Red Hat, AlmaLinux, and Rocky Linux

1. Install PostgreSQL
   

   # dnf install postgresql-server postgresql-contrib

2. Initialize the database
   

   # postgresql-setup initdb

3. 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

4. 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

5. Configure the database to launch at boot and start now
   

   # systemctl enable --now postgresql

Debian or Ubuntu

All supported versions of Debian and Ubuntu include a version of PostgreSQL you can use with Arvados.

1. Install PostgreSQL
   

   # apt --no-install-recommends install postgresql postgresql-contrib

2. 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

3. Configure the database to launch at boot and start now
   

   # systemctl enable --now postgresql

---

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