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.

Version Tags

Tag	Description	Best For
`latest`	FreeBSD Port. Installs from latest packages.	Most users. Matches Linux Docker behavior.
`pkg`	FreeBSD Port. Installs from Quarterly ports.	Stability. Uses system libraries.
`pkg-latest`	FreeBSD Port. Installs from Latest ports.	Bleeding edge system packages.

Prerequisites

Before deploying, ensure your host environment is ready. See the Quick Start Guide for host setup instructions.

Deployment

Podman Compose Podman CLI Ansible

services:
  postgres:
    image: ghcr.io/daemonless/postgres:latest
    container_name: postgres
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=postgres
      - POSTGRES_DB=postgres
      - PUID=1000
      - PGID=1000
      - TZ=UTC
    volumes:
      - /path/to/containers/postgres:/var/lib/postgresql/data
    ports:
      - 5432:5432
    restart: unless-stopped

podman run -d --name postgres \
  -p 5432:5432 \
  -e POSTGRES_USER=postgres \
  -e POSTGRES_PASSWORD=postgres \
  -e POSTGRES_DB=postgres \
  -e PUID=1000 \
  -e PGID=1000 \
  -e TZ=UTC \
  -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"
    ports:
      - "5432:5432"
    volumes:
      - "/path/to/containers/postgres:/var/lib/postgresql/data"

Access the Web UI at: http://localhost:5432

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`

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.0).

Website Source Code FreshPorts

Need help? Join our Discord community.