Install PostgreSQL 9.4+

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

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

The content of this documentation is licensed under the Creative Commons Attribution-Share Alike 3.0 United States licence.
Code samples in this documentation are licensed under the Apache License, Version 2.0.