postgres init error on k3s

[caenauba]

I'm trying to get viseron working on my k3s cluster.

I'm using docker.io/roflcoopter/amd64-viseron 3.3.0

Starting the container the postgres db always runs into following problems:

[cont-init.d] 80-postgres: executing... ***************** Preparing PostgreSQL ******************* Database has not been initialized. Initializing... The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale "C". The default database encoding has accordingly been set to "SQL_ASCII". The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory /config/postgresql ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting default time zone ... Europe/Berlin creating configuration files ... ok running bootstrap script ... [cont-finish.d] executing container finish scripts... [cont-finish.d] 10-postgres: executing... Wait for Viseron to stop... error: list of process IDs must follow -p Usage: ps [options] Try 'ps --help <simple|list|output|threads|misc|all>' or 'ps --help <s|l|o|t|m|a>' for additional help text. For more details see ps(1). Viseron has stopped! Stopping PostgreSQL... pg_ctl: cannot stop server; single-user server is running (PID: 432) Waiting for PostgreSQL Server to stop... /var/run/postgresql:5432 - no response PostgreSQL Server has stopped! 2025-10-16 10:35:37.556 CEST [432] PANIC: could not open file "pg_wal/000000010000000000000001": Permission denied Aborted (core dumped) child process exited with exit code 134 initdb: removing contents of data directory "/config/postgresql" initdb: warning: could not open directory "/config/postgresql/pg_wal": Permission denied initdb: warning: could not open directory "/config/postgresql/global": Permission denied initdb: warning: could not open directory "/config/postgresql/pg_commit_ts": Permission denied initdb: warning: could not open directory "/config/postgresql/pg_dynshmem": Permission denied initdb: warning: could not open directory "/config/postgresql/pg_notify": Permission denied initdb: warning: could not open directory "/config/postgresql/pg_serial": Permission denied initdb: warning: could not open directory "/config/postgresql/pg_snapshots": Permission denied initdb: warning: could not open directory "/config/postgresql/pg_subtrans": Permission denied initdb: warning: could not open directory "/config/postgresql/pg_twophase": Permission denied initdb: warning: could not open directory "/config/postgresql/pg_multixact": Permission denied initdb: warning: could not remove file or directory "/config/postgresql/base/1/3609": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3604": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3605": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3606": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3607": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3766": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3767": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3080": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3081": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/112": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/548": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/113": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/549": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/174": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/175": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3119": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3257": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3258": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/827": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/828": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3395": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3597": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3164": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3085": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3351": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3542": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/2228": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3574": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/3575": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/5002": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/6110": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/6111": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/6112": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/6113": Permission denied initdb: warning: could not stat file or directory "/config/postgresql/base/1/6117": Permission denied initdb: warning: could not remove file or directory "/config/postgresql/base/1": Permission denied initdb: warning: could not remove file or directory "/config/postgresql/base": Directory not empty initdb: warning: could not open directory "/config/postgresql/pg_replslot": Permission denied chown: cannot read directory '/config/postgresql/pg_tblspc': No such file or directory chown: cannot read directory '/config/postgresql/pg_stat': Stale file handle initdb: warning: could not open directory "/config/postgresql/pg_stat_tmp": Permission denied initdb: warning: could not open directory "/config/postgresql/pg_logical/snapshots": Permission denied chown: cannot access '/config/postgresql/pg_logical/mappings': No such file or directory initdb: warning: could not remove file or directory "/config/postgresql/pg_logical": Directory not empty initdb: error: failed to remove contents of data directory Starting PostgreSQL... pg_ctl: could not open PID file "/config/postgresql/postmaster.pid": Permission denied [cont-finish.d] 10-postgres: exited 1. [cont-finish.d] done. [s6-finish] waiting for services. psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory Is the server running locally and accepting connections on that socket? Database has not been created. Creating... createdb: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory Is the server running locally and accepting connections on that socket? createuser: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory Is the server running locally and accepting connections on that socket? Stopping PostgreSQL... pg_ctl: could not open PID file "/config/postgresql/postmaster.pid": Permission denied

Is there anyway to configure an external postgres instance?

[roflcoopter]

Sorry you are having issues.
The init scripts should set the permissions properly, but i am unsure if k3s breaks thats somehow.

Can you show me the entire startup log, not just the Postgres step, and also your docker command/docker compose?

Edit: Sadly there is no way to configure an external DB atm, should probablyt get around to it but my time is very limited

[caenauba]

I'm using the helm chart from https://roflcoopter.github.io/viseron-helm-chart with the following values:

replicaCount: 1

image:
  repository: docker.io/roflcoopter/amd64-viseron
  pullPolicy: IfNotPresent
  # Overrides the image tag whose default is the chart appVersion.
  tag: "3.3.0"

imagePullSecrets: []
nameOverride: ""
fullnameOverride: ""

serviceAccount:
  # Specifies whether a service account should be created
  create: true
  # Automatically mount a ServiceAccount's API credentials?
  automount: true
  # Annotations to add to the service account
  annotations: {}
  # The name of the service account to use.
  # If not set and create is true, a name is generated using the fullname template
  name: ""

podAnnotations: {}
podLabels: {}

podSecurityContext: {}
  # fsGroup: 2000

securityContext: {}
  # privileged: true

service:
  type: ClusterIP
  port: 8888
  targetPort: 8888
  # nodePort: 30888

ingress:
  enabled: false
  className: ""
  annotations: {}
    # kubernetes.io/ingress.class: nginx
    # kubernetes.io/tls-acme: "true"
  hosts:
    - host: viseron.local
      paths:
        - path: /
          pathType: ImplementationSpecific
  tls: []
  #  - secretName: chart-example-tls
  #    hosts:
  #      - chart-example.local

storage:
  config:
    className: "nfs-raid-csi"
    size: 5Gi
  segments:
    className: "nfs-raid-csi"
    size: 15Gi
  snapshots:
    className: "nfs-raid-csi"
    size: 15Gi
  thumbnails:
    className: "nfs-raid-csi"
    size: 5Gi
  eventclips:
    className: "nfs-raid-csi"
    size: 5Gi

shm:
  size: 1Gi

resources: {}
  # requests:
  #   cpu: 2.5
  #   memory: 10Gi
  # limits:
  #   cpu: 2.5
  #   memory: 10Gi

livenessProbe:
  httpGet:
    path: /
    port: 8888
readinessProbe:
  httpGet:
    path: /
    port: 8888

# Additional volumes on the output Deployment definition.
volumes: []
  # - name: dev-dri
  #   hostPath:
  #     path: /dev/dri

# Additional volumeMounts on the output Deployment definition.
volumeMounts: []
  # - name: dev-dri
  #   mountPath: /dev/dri

nodeSelector: {}

tolerations: []

affinity: {}

And here's the logs

[s6-init] making user provided files available at /var/run/s6/etc...exited 0.
[s6-init] ensuring user provided files have correct perms...exited 0.
[fix-attrs.d] applying ownership & permissions fixes...
[fix-attrs.d] done.
[cont-init.d] executing container initialization scripts...
[cont-init.d] 10-adduser: executing...
************************ UID/GID *************************
User uid:    0
User gid:    0
************************** Done **************************
[cont-init.d] 10-adduser: exited 0.
[cont-init.d] 20-gid-video-device: executing...
[cont-init.d] 20-gid-video-device: exited 0.
[cont-init.d] 30-edgetpu-permission: executing...
************** Setting EdgeTPU permissions ***************
Coral Vendor IDs:
"1a6e"
"18d1"
No EdgeTPU USB device was found
No EdgeTPU PCI device was found
************************** Done **************************
[cont-init.d] 30-edgetpu-permission: exited 0.
[cont-init.d] 40-set-env-vars: executing...
************* Setting Viseron config dir *****************
Viseron config dir: /config
*********************** Done *****************************
****** Checking for hardware acceleration platforms ******
OpenCL cannot be used
VA-API cannot be used
CUDA cannot be used
PostgreSQL major version: 14
PostgreSQL bin: /usr/lib/postgresql/14/bin
PostgreSQL data dir: /config/postgresql
*********************** Done *****************************
[cont-init.d] 40-set-env-vars: exited 0.
[cont-init.d] 50-check-if-rpi: executing...
********** Checking if we are running on an RPi **********
No supported Raspberry Pi model detected
*********************** Done *****************************
[cont-init.d] 50-check-if-rpi: exited 0.
[cont-init.d] 55-check-if-jetson: executing...
****** Checking if we are running on a Jetson Board ******
Not running on any supported Jetson board
*********************** Done *****************************
[cont-init.d] 55-check-if-jetson: exited 0.
[cont-init.d] 60-ffmpeg-path: executing...
****************** Getting FFmpeg path *******************
FFmpeg path: /home/abc/bin/ffmpeg
*********************** Done *****************************
[cont-init.d] 60-ffmpeg-path: exited 0.
[cont-init.d] 70-gstreamer-path: executing...
***************** Getting GStreamer path *****************
GStreamer path: /usr/bin/gst-launch-1.0
*********************** Done *****************************
[cont-init.d] 70-gstreamer-path: exited 0.
[cont-init.d] 80-postgres: executing...
***************** Preparing PostgreSQL *******************
Database has not been initialized. Initializing...
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /config/postgresql ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Europe/Berlin
creating configuration files ... ok
running bootstrap script ... [cont-finish.d] executing container finish scripts...
[cont-finish.d] 10-postgres: executing...
Wait for Viseron to stop...
error: list of process IDs must follow -p
Usage:
 ps [options]
 Try 'ps --help <simple|list|output|threads|misc|all>'
  or 'ps --help <s|l|o|t|m|a>'
 for additional help text.
For more details see ps(1).
Viseron has stopped!
Stopping PostgreSQL...
pg_ctl: cannot stop server; single-user server is running (PID: 432)
Waiting for PostgreSQL Server to stop...
/var/run/postgresql:5432 - no response
PostgreSQL Server has stopped!
2025-10-17 10:14:18.113 CEST [432] FATAL:  could not seek to end of file "global/4061": Permission denied
2025-10-17 10:14:18.113 CEST [432] PANIC:  cannot abort transaction 1, it was already committed
Aborted (core dumped)
child process exited with exit code 134
initdb: removing contents of data directory "/config/postgresql"
initdb: warning: could not open directory "/config/postgresql/pg_wal": Permission denied
initdb: warning: could not open directory "/config/postgresql/global": Permission denied
initdb: warning: could not open directory "/config/postgresql/pg_commit_ts": Permission denied
initdb: warning: could not open directory "/config/postgresql/pg_dynshmem": Permission denied
initdb: warning: could not open directory "/config/postgresql/pg_notify": Permission denied
initdb: warning: could not open directory "/config/postgresql/pg_serial": Permission denied
initdb: warning: could not open directory "/config/postgresql/pg_snapshots": Permission denied
initdb: warning: could not open directory "/config/postgresql/pg_subtrans": Permission denied
initdb: warning: could not open directory "/config/postgresql/pg_twophase": Permission denied
initdb: warning: could not open directory "/config/postgresql/pg_multixact": Permission denied
initdb: warning: could not remove file or directory "/config/postgresql/base/1/6112": Permission denied
initdb: warning: could not stat file or directory "/config/postgresql/base/1/6113": Permission denied
initdb: warning: could not stat file or directory "/config/postgresql/base/1/6117": Permission denied
initdb: warning: could not remove file or directory "/config/postgresql/base/1": Permission denied
initdb: warning: could not remove file or directory "/config/postgresql/base": Directory not empty
initdb: warning: could not open directory "/config/postgresql/pg_replslot": Permission denied
chown: cannot read directory '/config/postgresql/pg_tblspc': No such file or directory
chown: changing ownership of '/config/postgresql/pg_stat': No such file or directory
chown: changing ownership of '/config/postgresql/pg_stat_tmp': No such file or directory
initdb: warning: could not open directory "/config/postgresql/pg_logical/snapshots": Permission denied
chown: cannot access '/config/postgresql/pg_logical/mappings': No such file or directory
initdb: warning: could not remove file or directory "/config/postgresql/pg_logical": Directory not empty
initdb: warning: could not remove file or directory "/config/postgresql/postmaster.pid": Permission denied
initdb: error: failed to remove contents of data directory
[cont-finish.d] 10-postgres: exited 1.
Starting PostgreSQL...
[cont-finish.d] done.
[s6-finish] waiting for services.
pg_ctl: could not open PID file "/config/postgresql/postmaster.pid": Permission denied
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
Database has not been created. Creating...
createdb: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
createuser: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
Stopping PostgreSQL...
pg_ctl: could not open PID file "/config/postgresql/postmaster.pid": Permission denied
*********************** Done *****************************
[cont-init.d] 80-postgres: exited 0.
[cont-init.d] done.
[services.d] starting services
s6-svscanctl: fatal: unable to control /var/run/s6/services: supervisor not listening
[s6-finish] sending all processes the TERM signal.

[roflcoopter]

Does it work any better if you try to not run as root?
https://viseron.netlify.app/docs/documentation/installation#user-and-group-identifiers

[caenauba]

Not working anyway.
Tried setting User and Group.
Setting up DB on another Machine and copying content to the datastore is also not working.
Manually executing the postgres init script inside the container does not work.

Where is the config file that configures the db connection?
Maybe I can use an external instance of postgres.