Database

Stackarr offers two database modes.

App defaults

Recommended for most installations. Stackarr stores its own settings and task history in SQLite, while each enabled app uses its normal database. Apps that require Postgres still use Stackarr's shared database container automatically.

Shared Postgres

Advanced mode moves Stackarr and supported services to separate logical databases in one Postgres container. This can simplify central backup and database administration for larger stacks.

The database image includes TimescaleDB and pgvector for services such as Tracearr and Immich. Plex keeps its upstream database format in either media-server mode.

Access from the host

The database listens inside Docker on port 5432 and is published to 127.0.0.1:5433 by default. It is not exposed to the LAN.

To initialize or repair the configured databases:

docker exec app /app/bin/stackarr database ensure

Use the Stackarr dashboard to view redacted connection details. Enter database credentials only through authenticated settings or setup surfaces.

Backups

When shared Postgres is active, Stackarr backups include database roles and dumps for the managed logical databases. A backup fails if a required database cannot be read, preventing a misleading partial archive.