PostgreSQL
The World's Most Advanced Open Source Relational Database on FreeBSD.
| Port | 5432 |
| Registry | ghcr.io/daemonless/postgres |
| Daemonless | daemonless/postgres |
| Source | www.postgresql.org/ |
| Website | www.postgresql.org |
Init scripts
On first start (empty data directory), files in /docker-entrypoint-initdb.d/
run in name order: *.sh (run if executable, else sourced), *.sql and
*.sql.gz. They run as bsd, not as root, and connect as
POSTGRES_USER, the superuser that owns the databases.
Prerequisites
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
Customize Paths, UID & Ports
Install and manage PostgreSQL on FreeBSD with fjord:
Or open the App Store in the fjord web UI and install PostgreSQL from the wizard. New to fjord? See the Install Guide.
Save as compose.yaml, then run podman-compose up -d.
Warning
Exposing ports in AppJail means that your service can be reached from remote hosts. If that is not your intention, do not expose the ports and communicate with the service using the jail's IPv4 address or hostname assigned by the virtual network.
Save the files above, then run appjail-director up.
Experimental
Bastille's OCI support is experimental. It requires buildah and shares the host network stack (inherit). Mount volumes with --volume HOST JAIL; without it, image-declared volumes are stored under ${bastille_volumesdir}/${jail}.
Save as bastille-compose.yml, then run bastille up.
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 |
Version Tags
Multi-arch manifests — resolve automatically to the right image for your platform.
| Tag | Description | Best For |
|---|---|---|
14 / 14-pkg-latest |
FreeBSD Latest. Rolling package updates. | Staying current. |
15 / 15-pkg-latest |
FreeBSD Latest. Rolling package updates. | Staying current. |
16 / 16-pkg-latest |
FreeBSD Latest. Rolling package updates. | Staying current. |
17 / 17-pkg-latest |
FreeBSD Latest. Rolling package updates. | Staying current. |
18 / 18-pkg-latest / latest / pkg / pkg-latest |
FreeBSD Latest. Rolling package updates. | Staying current. |
| Tag | Description | Best For |
|---|---|---|
14-amd64 / 14-pkg-latest-amd64 |
FreeBSD Latest. Rolling package updates. | Staying current. |
15-amd64 / 15-pkg-latest-amd64 |
FreeBSD Latest. Rolling package updates. | Staying current. |
16-amd64 / 16-pkg-latest-amd64 |
FreeBSD Latest. Rolling package updates. | Staying current. |
17-amd64 / 17-pkg-latest-amd64 |
FreeBSD Latest. Rolling package updates. | Staying current. |
18-amd64 / 18-pkg-latest-amd64 / latest-amd64 / pkg-amd64 / pkg-latest-amd64 |
FreeBSD Latest. Rolling package updates. | Staying current. |
| Tag | Description | Best For |
|---|---|---|
14-aarch64 / 14-pkg-latest-aarch64 |
FreeBSD Latest. Rolling package updates. | Staying current. |
15-aarch64 / 15-pkg-latest-aarch64 |
FreeBSD Latest. Rolling package updates. | Staying current. |
16-aarch64 / 16-pkg-latest-aarch64 |
FreeBSD Latest. Rolling package updates. | Staying current. |
17-aarch64 / 17-pkg-latest-aarch64 |
FreeBSD Latest. Rolling package updates. | Staying current. |
18-aarch64 / 18-pkg-latest-aarch64 / latest-aarch64 / pkg-aarch64 / pkg-latest-aarch64 |
FreeBSD Latest. Rolling package updates. | Staying current. |
Implementation Details
- Architectures: amd64, aarch64
- User:
bsd(UID/GID set via PUID/PGID). Defaults to1000: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.