Skip to content

Instantly share code, notes, and snippets.

@kkroesch

kkroesch/postgres.service

Created October 4, 2025 14:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save kkroesch/2fd20629735d7e67a19df02a75b0053e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save kkroesch/2fd20629735d7e67a19df02a75b0053e to your computer and use it in GitHub Desktop.
Download ZIP
.service-Datei für Podman-PostgreSQL (Wegen Problemen mit Quadlet-Generator auf IoT Edition)
Raw
postgres.service
[Unit]
Wants=podman-user-wait-network-online.service
After=podman-user-wait-network-online.service
Description=PostgreSQL Container
# Stellt sicher, dass der Service erst nach dem Netzwerk startet
After=network-online.target
Wants=network-online.target
RequiresMountsFor=%t/containers
RequiresMountsFor=/srv/postgres
[Service]
Restart=always
TimeoutStartSec=900
Environment=PODMAN_SYSTEMD_UNIT=%n
KillMode=mixed
ExecStop=/usr/bin/podman rm -v -f -i systemd-%N
ExecStopPost=-/usr/bin/podman rm -v -f -i systemd-%N
Delegate=yes
Type=notify
NotifyAccess=all
SyslogIdentifier=%N
ExecStart=/usr/bin/podman run --name systemd-%N --replace --rm --cgroups=split --sdnotify=conmon -d -v /srv/postgres:/var/lib/postgresql/data:Z --publish 5432:5432 --env POSTGRES_DB=analytics --env POSTGRES_PASSWORD=analytics --env POSTGRES_USER=analytics docker.io/library/postgres:16
[Install]
WantedBy=default.target
@kkroesch
Copy link
Author

kkroesch commented Oct 4, 2025

Replace 'analytics' with your DB name, user, password. It will be set only on first startup, change password afterwards:

podman exec -it postgres /bin/bash
su - postgres
psql
ALTER USER analytics WITH PASSWORD 'analytics';

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment