AidboxDB

This topic explains the configuration and internals of aidboxdb image

Introduction
AidboxDB image is a custom build of open source PostgreSQL database. Aidbox uses it as data storage. The image can be pulled from HealthSamurai dockerhub. 
docker run \
       -v "$(pwd)"/pgdata:/data/pg \
       -e POSTGRES_USER='postgres' \
       -e POSTGRES_PASSWORD='pass' \
       -e POSTGRES_DB='aidbox' \
       -e PGDATA="/data/pg" \
       healthsamurai/aidboxdb:14.5
The AidboxDB image use cases are:
To initialize and run a master database for Aidbox to work with
To initialize and run a streaming replica
Optimized FHIR search queries
Backup and maintenance extensions
Versioning
AidboxDB image is tagged by PostgreSQL version from which it is built. For example, if you want to use 14.5 PostgreSQL version you should pull healthsamurai/aidboxdb:14.5 image.
Supported PostgreSQL versions: 15 (beta), 14.5, 13.8​
Available versions: 14.2, 13.6, 13.2, 12.12, 12.6, 11.17, 11.11​
Extensions
List of additional availiable extensions:
​jsonknife — Jsonb extraction tool for optimizing FHIR search
​pgagent — A PostgreSQL job scheduler  
​pg_repack — Reorganize tables in PostgreSQL databases with minimal locks 
​jsquery — JSON query language with GIN indexing support
​wal2json — Is an output plugin for logical decoding
​wal-g — Archival and Restoration for databases in the Cloud
Configuration
The image is configured by supplying environment variables and command line arguments on startup. Keep in mind that you should not change the environment variables once you have initialized the database. The image expects them to be immutable.
AidboxDB environment variables
Archiving
An open-source tool wal-g is used by AidboxDB for continuous archival, backups, and restoration.
Archiving

App development guides - Previous

$to-format

Next - Storage

Database schema

Last modified 2mo ago