aidboxdb

aidboxdb

AidboxDB is a specialized version of the open-source PostgreSQL database, tailored for use as the data storage backend for Aidbox. It serves various purposes, including initializing and operating as a master database for Aidbox, functioning as a streaming replica, optimizing FHIR search queries, and supporting backup and maintenance functionalities.

Add the helm repository

helm repo add aidbox https://aidbox.github.io/helm-charts

Installation with the PostgreSQL default credentials

helm upgrade --install aidboxdb aidbox/aidboxdb \
  --namespace postgres --create-namespace

It will install the AidboxDB with default credentials in the postgres namespace, creating that namespace if it doesn't already exist.

Installation using custom PostgreSQL config and/or environment variables

Create values YAML like

config: |-
  max_wal_size = '4GB'
  shared_buffers = '2GB'

env:
  POSTGRES_USER: superuser
  POSTGRES_PASSWORD: strongpassword

and apply it

helm upgrade --install aidboxdb aidbox/aidboxdb \
  --namespace postgres --create-namespace \
  --values /path/to/values.yaml

Database backup

AidboxDB image contains WAL-G. For more information see documentation

Values

Key	Type	Default	Description
config	string	"max_wal_size = '4GB'\nshared_buffers = '2GB'"	PostgreSQL config
env	object	{"PGDATA":"/data/pg","POSTGRES_DB":"postgres","POSTGRES_PASSWORD":"postgres","POSTGRES_USER":"postgres"}	AidboxDB environment variables
fullnameOverride	string	""
image.pullPolicy	string	"IfNotPresent"
image.repository	string	"healthsamurai/aidboxdb"
image.tag	string	""	Overrides the image tag whose default is the chart appVersion. Has one-to-one mapping to the PostgreSQL version.
imagePullSecrets	list	[]
nameOverride	string	""
podSecurityContext	object	{}
resources	object	{}
securityContext	object	{}
storage.className	string	""	Storage className to use
storage.size	string	"300Gi"	Storage volume size request
volumeMounts	list	[]	Additional volume mounts
volumes	list	[]	Additional volumes