PostgreSQL

Description / name	Input element
Container Registry
Container Configuration Root Path
Timezone
User ID
Group ID
PostgreSQL Host Port
PostgreSQL /var/lib/postgresql/data Path

The World's Most Advanced Open Source Relational Database on FreeBSD.

Requires ocijail with annotation support (≥ 0.6.0)

This image needs the jail permission allow.sysvipc, applied via OCI annotations. FreeBSD quarterly ships ocijail 0.4.0, which has no annotation support — the container starts but the permission is silently dropped, so the app can crash or misbehave. Point your pkg repos at the latest branch (ocijail ≥ 0.6.0) and run with the annotation flag shown below. See the ocijail guide.


Port	`5432`
Registry	`ghcr.io/daemonless/postgres`
Daemonless	daemonless/postgres
Source	www.postgresql.org/
Website	www.postgresql.org

Version Tags

Tag	Description	Best For
`14` / `14-pkg`	FreeBSD Quarterly. Uses stable, tested packages.	Production stability.
`14-pkg-latest`	FreeBSD Latest. Rolling package updates.	Staying current.
`15` / `15-pkg`	FreeBSD Quarterly. Uses stable, tested packages.	Production stability.
`15-pkg-latest`	FreeBSD Latest. Rolling package updates.	Staying current.
`16` / `16-pkg`	FreeBSD Quarterly. Uses stable, tested packages.	Production stability.
`16-pkg-latest`	FreeBSD Latest. Rolling package updates.	Staying current.
`17` / `17-pkg`	FreeBSD Quarterly. Uses stable, tested packages.	Production stability.
`17-pkg-latest`	FreeBSD Latest. Rolling package updates.	Staying current.
`18` / `18-pkg` / `latest` / `pkg`	FreeBSD Quarterly. Uses stable, tested packages.	Most users — recommended.
`18-pkg-latest` / `pkg-latest`	FreeBSD Latest. Rolling package updates.	Staying current.

Before deploying, ensure your host environment is ready. See the Quick Start Guide for host setup instructions, including the security model for host vs. container privileges.

Deployment

Podman AppJail

Compose CLI Ansible

services:
  postgres:
    image: "ghcr.io/daemonless/postgres:latest"
    container_name: postgres
    environment:
      - POSTGRES_USER=postgres  # Database superuser name (default: postgres)
      - POSTGRES_PASSWORD=postgres  # Database superuser password
      - POSTGRES_DB=postgres  # Default database to create (default: same as user)
      - PUID=1000
      - PGID=1000
      - TZ=UTC
      - POSTGRES_INITDB_ARGS=  # Additional arguments for initdb
      - POSTGRES_HOST_AUTH_METHOD=  # Authentication method (default: scram-sha-256)
    volumes:
      - "/path/to/containers/postgres:/var/lib/postgresql/data"
    ports:
      - "5432:5432"
    annotations:
      org.freebsd.jail.allow.sysvipc: "true"
    restart: unless-stopped

podman run -d --name postgres \
  -p 5432:5432 \
  --annotation 'org.freebsd.jail.allow.sysvipc=true' \
  -e POSTGRES_USER=postgres \
  -e POSTGRES_PASSWORD=postgres \
  -e POSTGRES_DB=postgres \
  -e PUID=1000 \
  -e PGID=1000 \
  -e TZ=UTC \
  -e POSTGRES_INITDB_ARGS= \
  -e POSTGRES_HOST_AUTH_METHOD= \
  -v /path/to/containers/postgres:/var/lib/postgresql/data \
  ghcr.io/daemonless/postgres:latest

- name: Deploy postgres
  containers.podman.podman_container:
    name: postgres
    image: "ghcr.io/daemonless/postgres:latest"
    state: started
    restart_policy: always
    env:
      POSTGRES_USER: "postgres"
      POSTGRES_PASSWORD: "postgres"
      POSTGRES_DB: "postgres"
      PUID: "1000"
      PGID: "1000"
      TZ: "UTC"
      POSTGRES_INITDB_ARGS: ""
      POSTGRES_HOST_AUTH_METHOD: ""
    ports:
      - "5432:5432"
    volumes:
      - "/path/to/containers/postgres:/var/lib/postgresql/data"
    annotation:
      org.freebsd.jail.allow.sysvipc: "true"

Director CLI

# .env

DIRECTOR_PROJECT=postgres
POSTGRES_USER=postgres
POSTGRES_PASSWORD=postgres
POSTGRES_DB=postgres
PUID=1000
PGID=1000
TZ=UTC
POSTGRES_INITDB_ARGS=
POSTGRES_HOST_AUTH_METHOD=

# appjail-director.yml

options:
  - virtualnet: ':<random> default'
  - nat:
services:
  postgres:
    name: postgres
    options:
      - container: 'boot args:--pull'
      - expose: '5432:5432 proto:tcp'
    oci:
      user: root
      environment:
        - POSTGRES_USER: !ENV '${POSTGRES_USER}'
        - POSTGRES_PASSWORD: !ENV '${POSTGRES_PASSWORD}'
        - POSTGRES_DB: !ENV '${POSTGRES_DB}'
        - PUID: !ENV '${PUID}'
        - PGID: !ENV '${PGID}'
        - TZ: !ENV '${TZ}'
        - POSTGRES_INITDB_ARGS: !ENV '${POSTGRES_INITDB_ARGS}'
        - POSTGRES_HOST_AUTH_METHOD: !ENV '${POSTGRES_HOST_AUTH_METHOD}'
    volumes:
      - POSTGRES_DATA_PATH: /var/lib/postgresql/data
volumes:
  POSTGRES_DATA_PATH:
    device: '/path/to/containers/postgres'

# Makejail

ARG tag=latest

OPTION overwrite=force
OPTION from=ghcr.io/daemonless/postgres:${tag}
SET allow.sysvipc=1

appjail oci run -Pd \
  -o overwrite=force \
  -o container="args:--pull" \
  -o virtualnet=":<random> default" \
  -o nat \
  -o expose="5432:5432 proto:tcp" \
  -e POSTGRES_USER=postgres \
  -e POSTGRES_PASSWORD=postgres \
  -e POSTGRES_DB=postgres \
  -e PUID=1000 \
  -e PGID=1000 \
  -e TZ=UTC \
  -e POSTGRES_INITDB_ARGS= \
  -e POSTGRES_HOST_AUTH_METHOD= \
  -o fstab="/path/to/containers/postgres /var/lib/postgresql/data <pseudofs>" \
  ghcr.io/daemonless/postgres:latest postgres

Interactive Configuration

Parameters

Environment Variables

Variable	Default	Description
`POSTGRES_USER`	`postgres`	Database superuser name (default: postgres)
`POSTGRES_PASSWORD`	`postgres`	Database superuser password
`POSTGRES_DB`	`postgres`	Default database to create (default: same as user)
`PUID`	`1000`
`PGID`	`1000`
`TZ`	`UTC`
`POSTGRES_INITDB_ARGS`	``	Additional arguments for initdb
`POSTGRES_HOST_AUTH_METHOD`	``	Authentication method (default: scram-sha-256)

Volumes

Path	Description
`/var/lib/postgresql/data`	Database data directory

Ports

Port	Protocol	Description
`5432`	TCP	PostgreSQL port

Implementation Details

Architectures: amd64
User: bsd (UID/GID set via PUID/PGID). Defaults to 1000:1000.
Base: Built on ghcr.io/daemonless/base (FreeBSD 15.1).
sysvipc: Requires --annotation 'org.freebsd.jail.allow.sysvipc=true' (ocijail 0.5.0+)

Need help? Join our Discord community.