-
Notifications
You must be signed in to change notification settings - Fork 55
Description
I was trying to convert my HomeAssistant Installation (together with one TimeScaleDB for Operation & another TimescaleDB for LTSS) from Compose to Quadlets for Podman 5.5.2 on Fedora Linux 42 AMD64.
I also changed (renamed) the Path for the bind-mount where Data is Stored.
Unfortunately after the Migration, even after trying a chmod -R 777 /path/to/my/db/data/on/host
, the Container crashes immediately during Startup. Within 30 Seconds essentially.
Seeing that the Normal/Default Logs didn't show anything useful at all, I basically set the most verbose Debug Level I could find in postgresql.conf
.
Verbose Log
Even the Verbose Log doesn't appear to show anything abnormal:
2025-07-21 16:32:38.777 UTC [1] LOG: 00000: starting PostgreSQL 16.9 (Ubuntu 16.9-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
2025-07-21 16:32:38.777 UTC [1] LOCATION: PostmasterMain, postmaster.c:1186
2025-07-21 16:32:38.777 UTC [1] LOG: 00000: listening on IPv4 address "0.0.0.0", port 5432
2025-07-21 16:32:38.777 UTC [1] LOCATION: StreamServerPort, pqcomm.c:564
2025-07-21 16:32:38.777 UTC [1] LOG: 00000: listening on IPv6 address "::", port 5432
2025-07-21 16:32:38.777 UTC [1] LOCATION: StreamServerPort, pqcomm.c:564
2025-07-21 16:32:38.780 UTC [1] LOG: 00000: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-07-21 16:32:38.780 UTC [1] LOCATION: StreamServerPort, pqcomm.c:560
2025-07-21 16:32:38.785 UTC [29] DEBUG: 00000: checkpointer updated shared memory configuration values
2025-07-21 16:32:38.785 UTC [29] LOCATION: UpdateSharedMemoryConfig, checkpointer.c:1333
2025-07-21 16:32:38.785 UTC [31] LOG: 00000: database system was shut down at 2025-07-21 16:31:05 UTC
2025-07-21 16:32:38.785 UTC [31] LOCATION: StartupXLOG, xlog.c:5078
2025-07-21 16:32:38.786 UTC [31] DEBUG: 00000: checkpoint record is at 117/CA5A53E0
2025-07-21 16:32:38.786 UTC [31] LOCATION: InitWalRecovery, xlogrecovery.c:799
2025-07-21 16:32:38.786 UTC [31] DEBUG: 00000: redo record is at 117/CA5A53E0; shutdown true
2025-07-21 16:32:38.786 UTC [31] LOCATION: InitWalRecovery, xlogrecovery.c:857
2025-07-21 16:32:38.786 UTC [31] DEBUG: 00000: next transaction ID: 3736664; next OID: 179009
2025-07-21 16:32:38.786 UTC [31] LOCATION: InitWalRecovery, xlogrecovery.c:861
2025-07-21 16:32:38.786 UTC [31] DEBUG: 00000: next MultiXactId: 1; next MultiXactOffset: 0
2025-07-21 16:32:38.786 UTC [31] LOCATION: InitWalRecovery, xlogrecovery.c:865
2025-07-21 16:32:38.786 UTC [31] DEBUG: 00000: oldest unfrozen transaction ID: 723, in database 5
2025-07-21 16:32:38.786 UTC [31] LOCATION: InitWalRecovery, xlogrecovery.c:868
2025-07-21 16:32:38.786 UTC [31] DEBUG: 00000: oldest MultiXactId: 1, in database 16384
2025-07-21 16:32:38.786 UTC [31] LOCATION: InitWalRecovery, xlogrecovery.c:871
2025-07-21 16:32:38.786 UTC [31] DEBUG: 00000: commit timestamp Xid oldest/newest: 0/0
2025-07-21 16:32:38.786 UTC [31] LOCATION: InitWalRecovery, xlogrecovery.c:874
2025-07-21 16:32:38.786 UTC [31] DEBUG: 00000: transaction ID wrap limit is 2147484370, limited by database with OID 5
2025-07-21 16:32:38.786 UTC [31] LOCATION: SetTransactionIdLimit, varsup.c:427
2025-07-21 16:32:38.786 UTC [31] DEBUG: 00000: MultiXactId wrap limit is 2147483648, limited by database with OID 16384
2025-07-21 16:32:38.786 UTC [31] LOCATION: SetMultiXactIdLimit, multixact.c:2282
2025-07-21 16:32:38.786 UTC [31] DEBUG: 00000: starting up replication slots
2025-07-21 16:32:38.786 UTC [31] LOCATION: StartupReplicationSlots, slot.c:1646
2025-07-21 16:32:38.786 UTC [31] DEBUG: 00000: xmin required by slots: data 0, catalog 0
2025-07-21 16:32:38.786 UTC [31] LOCATION: ProcArraySetReplicationSlotXmin, procarray.c:3906
2025-07-21 16:32:38.786 UTC [31] DEBUG: 00000: starting up replication origin progress state
2025-07-21 16:32:38.786 UTC [31] LOCATION: StartupReplicationOrigin, origin.c:722
2025-07-21 16:32:38.786 UTC [31] DEBUG: 00000: reading stats file "pg_stat/pgstat.stat"
2025-07-21 16:32:38.786 UTC [31] LOCATION: pgstat_read_statsfile, pgstat.c:1507
2025-07-21 16:32:38.786 UTC [31] DEBUG: 00000: removing permanent stats file "pg_stat/pgstat.stat"
2025-07-21 16:32:38.786 UTC [31] LOCATION: pgstat_read_statsfile, pgstat.c:1678
2025-07-21 16:32:38.786 UTC [31] DEBUG: 00000: MultiXactId wrap limit is 2147483648, limited by database with OID 16384
2025-07-21 16:32:38.786 UTC [31] LOCATION: SetMultiXactIdLimit, multixact.c:2282
2025-07-21 16:32:38.786 UTC [31] DEBUG: 00000: MultiXact member stop limit is now 4294914944 based on MultiXact 1
2025-07-21 16:32:38.786 UTC [31] LOCATION: SetOffsetVacuumLimit, multixact.c:2646
2025-07-21 16:32:38.788 UTC [31] DEBUG: 00000: shmem_exit(0): 4 before_shmem_exit callbacks to make
2025-07-21 16:32:38.788 UTC [31] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:38.788 UTC [31] DEBUG: 00000: shmem_exit(0): 6 on_shmem_exit callbacks to make
2025-07-21 16:32:38.788 UTC [31] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:38.788 UTC [31] DEBUG: 00000: proc_exit(0): 1 callbacks to make
2025-07-21 16:32:38.788 UTC [31] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:38.788 UTC [31] DEBUG: 00000: exit(0)
2025-07-21 16:32:38.788 UTC [31] LOCATION: proc_exit, ipc.c:154
2025-07-21 16:32:38.788 UTC [31] DEBUG: 00000: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2025-07-21 16:32:38.788 UTC [31] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:38.788 UTC [31] DEBUG: 00000: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2025-07-21 16:32:38.788 UTC [31] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:38.788 UTC [31] DEBUG: 00000: proc_exit(-1): 0 callbacks to make
2025-07-21 16:32:38.788 UTC [31] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:38.791 UTC [1] DEBUG: 00000: reaping dead processes
2025-07-21 16:32:38.791 UTC [1] LOCATION: process_pm_child_exit, postmaster.c:2989
2025-07-21 16:32:38.791 UTC [1] DEBUG: 00000: starting background worker process "TimescaleDB Background Worker Launcher"
2025-07-21 16:32:38.791 UTC [1] LOCATION: do_start_bgworker, postmaster.c:5723
2025-07-21 16:32:38.792 UTC [33] DEBUG: 00000: autovacuum launcher started
2025-07-21 16:32:38.792 UTC [33] LOCATION: AutoVacLauncherMain, autovacuum.c:453
2025-07-21 16:32:38.792 UTC [1] DEBUG: 00000: starting background worker process "logical replication launcher"
2025-07-21 16:32:38.792 UTC [1] LOCATION: do_start_bgworker, postmaster.c:5723
2025-07-21 16:32:38.792 UTC [33] DEBUG: 00000: InitPostgres
2025-07-21 16:32:38.792 UTC [33] LOCATION: InitPostgres, postinit.c:733
2025-07-21 16:32:38.792 UTC [33] DEBUG: 00000: my backend ID is 1
2025-07-21 16:32:38.792 UTC [33] LOCATION: SharedInvalBackendInit, sinvaladt.c:332
2025-07-21 16:32:38.792 UTC [33] DEBUG: 00000: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.792 UTC [33] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.792 UTC [1] LOG: 00000: database system is ready to accept connections
2025-07-21 16:32:38.792 UTC [1] LOCATION: process_pm_child_exit, postmaster.c:3110
2025-07-21 16:32:38.792 UTC [34] DEBUG: 00000: find_in_dynamic_libpath: trying "/usr/lib/postgresql/16/lib/timescaledb"
2025-07-21 16:32:38.792 UTC [34] LOCATION: find_in_dynamic_libpath, dfmgr.c:610
2025-07-21 16:32:38.792 UTC [34] DEBUG: 00000: find_in_dynamic_libpath: trying "/usr/lib/postgresql/16/lib/timescaledb.so"
2025-07-21 16:32:38.792 UTC [34] LOCATION: find_in_dynamic_libpath, dfmgr.c:610
2025-07-21 16:32:38.792 UTC [35] DEBUG: 00000: logical replication launcher started
2025-07-21 16:32:38.792 UTC [35] LOCATION: ApplyLauncherMain, launcher.c:1101
2025-07-21 16:32:38.792 UTC [35] DEBUG: 00000: InitPostgres
2025-07-21 16:32:38.792 UTC [35] LOCATION: InitPostgres, postinit.c:733
2025-07-21 16:32:38.792 UTC [35] DEBUG: 00000: my backend ID is 2
2025-07-21 16:32:38.792 UTC [35] LOCATION: SharedInvalBackendInit, sinvaladt.c:332
2025-07-21 16:32:38.793 UTC [33] DEBUG: 00000: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.793 UTC [33] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.793 UTC [35] DEBUG: 00000: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.793 UTC [35] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.793 UTC [35] DEBUG: 00000: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.793 UTC [35] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.793 UTC [35] DEBUG: 00000: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.793 UTC [35] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.793 UTC [35] DEBUG: 00000: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.793 UTC [35] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.793 UTC [35] DEBUG: 00000: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.793 UTC [35] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.793 UTC [35] DEBUG: 00000: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.793 UTC [35] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.793 UTC [34] DEBUG: 00000: TimescaleDB background worker launcher started
2025-07-21 16:32:38.793 UTC [34] LOCATION: ts_bgw_cluster_launcher_main, bgw_launcher.c:830
2025-07-21 16:32:38.794 UTC [34] DEBUG: 00000: InitPostgres
2025-07-21 16:32:38.794 UTC [34] LOCATION: InitPostgres, postinit.c:733
2025-07-21 16:32:38.794 UTC [34] DEBUG: 00000: my backend ID is 3
2025-07-21 16:32:38.794 UTC [34] LOCATION: SharedInvalBackendInit, sinvaladt.c:332
2025-07-21 16:32:38.794 UTC [34] DEBUG: 00000: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.794 UTC [34] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.794 UTC [34] DEBUG: 00000: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.794 UTC [34] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.794 UTC [34] LOG: 00000: TimescaleDB background worker launcher connected to shared catalogs
2025-07-21 16:32:38.794 UTC [34] LOCATION: ts_bgw_cluster_launcher_main, bgw_launcher.c:851
2025-07-21 16:32:38.794 UTC [34] DEBUG: 00000: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.794 UTC [34] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.794 UTC [34] DEBUG: 00000: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.794 UTC [34] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.794 UTC [34] DEBUG: 00000: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.794 UTC [34] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.794 UTC [34] DEBUG: 00000: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.794 UTC [34] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.794 UTC [1] DEBUG: 00000: postmaster received pmsignal signal
2025-07-21 16:32:38.794 UTC [1] LOCATION: process_pm_pmsignal, postmaster.c:5086
2025-07-21 16:32:38.794 UTC [1] DEBUG: 00000: registering background worker "TimescaleDB Background Worker Scheduler for database 16384"
2025-07-21 16:32:38.794 UTC [1] LOCATION: BackgroundWorkerStateChange, bgworker.c:409
2025-07-21 16:32:38.794 UTC [1] DEBUG: 00000: starting background worker process "TimescaleDB Background Worker Scheduler for database 16384"
2025-07-21 16:32:38.794 UTC [1] LOCATION: do_start_bgworker, postmaster.c:5723
2025-07-21 16:32:38.794 UTC [1] DEBUG: 00000: postmaster received pmsignal signal
2025-07-21 16:32:38.794 UTC [1] LOCATION: process_pm_pmsignal, postmaster.c:5086
2025-07-21 16:32:38.795 UTC [1] DEBUG: 00000: registering background worker "TimescaleDB Background Worker Scheduler for database 5"
2025-07-21 16:32:38.795 UTC [1] LOCATION: BackgroundWorkerStateChange, bgworker.c:409
2025-07-21 16:32:38.795 UTC [1] DEBUG: 00000: starting background worker process "TimescaleDB Background Worker Scheduler for database 5"
2025-07-21 16:32:38.795 UTC [1] LOCATION: do_start_bgworker, postmaster.c:5723
2025-07-21 16:32:38.795 UTC [36] DEBUG: 00000: find_in_dynamic_libpath: trying "/usr/lib/postgresql/16/lib/timescaledb"
2025-07-21 16:32:38.795 UTC [36] LOCATION: find_in_dynamic_libpath, dfmgr.c:610
2025-07-21 16:32:38.795 UTC [36] DEBUG: 00000: find_in_dynamic_libpath: trying "/usr/lib/postgresql/16/lib/timescaledb.so"
2025-07-21 16:32:38.795 UTC [36] LOCATION: find_in_dynamic_libpath, dfmgr.c:610
2025-07-21 16:32:38.795 UTC [36] DEBUG: 00000: InitPostgres
2025-07-21 16:32:38.795 UTC [36] LOCATION: InitPostgres, postinit.c:733
2025-07-21 16:32:38.795 UTC [36] DEBUG: 00000: my backend ID is 4
2025-07-21 16:32:38.795 UTC [36] LOCATION: SharedInvalBackendInit, sinvaladt.c:332
2025-07-21 16:32:38.795 UTC [36] DEBUG: 00000: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.795 UTC [36] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.795 UTC [37] DEBUG: 00000: find_in_dynamic_libpath: trying "/usr/lib/postgresql/16/lib/timescaledb"
2025-07-21 16:32:38.795 UTC [37] LOCATION: find_in_dynamic_libpath, dfmgr.c:610
2025-07-21 16:32:38.796 UTC [37] DEBUG: 00000: find_in_dynamic_libpath: trying "/usr/lib/postgresql/16/lib/timescaledb.so"
2025-07-21 16:32:38.796 UTC [37] LOCATION: find_in_dynamic_libpath, dfmgr.c:610
2025-07-21 16:32:38.796 UTC [37] DEBUG: 00000: InitPostgres
2025-07-21 16:32:38.796 UTC [37] LOCATION: InitPostgres, postinit.c:733
2025-07-21 16:32:38.796 UTC [37] DEBUG: 00000: my backend ID is 5
2025-07-21 16:32:38.796 UTC [37] LOCATION: SharedInvalBackendInit, sinvaladt.c:332
2025-07-21 16:32:38.796 UTC [37] DEBUG: 00000: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.796 UTC [37] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.799 UTC [36] DEBUG: 00000: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.799 UTC [36] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.799 UTC [36] DEBUG: 00000: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.799 UTC [36] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.799 UTC [36] DEBUG: 00000: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.799 UTC [36] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.799 UTC [36] DEBUG: 00000: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.799 UTC [36] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.799 UTC [37] DEBUG: 00000: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.799 UTC [37] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.799 UTC [37] DEBUG: 00000: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.799 UTC [37] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.799 UTC [37] DEBUG: 00000: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.799 UTC [37] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.799 UTC [37] DEBUG: 00000: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.799 UTC [37] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.801 UTC [36] DEBUG: 00000: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.801 UTC [36] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:38.801 UTC [37] DEBUG: 00000: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:38.801 UTC [37] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:43.797 UTC [33] DEBUG: 00000: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:43.797 UTC [33] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:43.797 UTC [33] DEBUG: 00000: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:43.797 UTC [33] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:43.797 UTC [1] DEBUG: 00000: postmaster received pmsignal signal
2025-07-21 16:32:43.797 UTC [1] LOCATION: process_pm_pmsignal, postmaster.c:5086
2025-07-21 16:32:43.799 UTC [38] DEBUG: 00000: InitPostgres
2025-07-21 16:32:43.799 UTC [38] LOCATION: InitPostgres, postinit.c:733
2025-07-21 16:32:43.799 UTC [38] DEBUG: 00000: my backend ID is 6
2025-07-21 16:32:43.799 UTC [38] LOCATION: SharedInvalBackendInit, sinvaladt.c:332
2025-07-21 16:32:43.800 UTC [38] DEBUG: 00000: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:43.800 UTC [38] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:43.801 UTC [38] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: autovacuum: processing database "homeassistant"
2025-07-21 16:32:43.801 UTC [38] LOCATION: AutoVacWorkerMain, autovacuum.c:1716
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:43.801 UTC [38] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_statistic: vac: 0 (threshold 165), ins: 0 (threshold 1115), anl: 0 (threshold 108)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_type: vac: 0 (threshold 251), ins: 0 (threshold 1201), anl: 0 (threshold 150)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_authid: vac: 0 (threshold 53), ins: 0 (threshold 1003), anl: 0 (threshold 52)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_subscription: vac: 0 (threshold 50), ins: 0 (threshold 1000), anl: 0 (threshold 50)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_attribute: vac: 0 (threshold 826), ins: 0 (threshold 1776), anl: 0 (threshold 438)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_proc: vac: 0 (threshold 919), ins: 0 (threshold 1869), anl: 0 (threshold 485)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_class: vac: 0 (threshold 167), ins: 0 (threshold 1117), anl: 0 (threshold 108)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_attrdef: vac: 0 (threshold 55), ins: 0 (threshold 1005), anl: 0 (threshold 52)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_constraint: vac: 0 (threshold 90), ins: 0 (threshold 1040), anl: 0 (threshold 70)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_index: vac: 0 (threshold 100), ins: 0 (threshold 1050), anl: 0 (threshold 75)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_operator: vac: 0 (threshold 242), ins: 0 (threshold 1192), anl: 0 (threshold 146)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_opclass: vac: 0 (threshold 85), ins: 0 (threshold 1035), anl: 0 (threshold 68)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_am: vac: 0 (threshold 51), ins: 0 (threshold 1001), anl: 0 (threshold 51)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_amop: vac: 0 (threshold 239), ins: 0 (threshold 1189), anl: 0 (threshold 144)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_amproc: vac: 0 (threshold 189), ins: 0 (threshold 1139), anl: 0 (threshold 120)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_aggregate: vac: 0 (threshold 98), ins: 0 (threshold 1048), anl: 0 (threshold 74)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_trigger: vac: 0 (threshold 75), ins: 0 (threshold 1025), anl: 0 (threshold 62)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_cast: vac: 0 (threshold 97), ins: 0 (threshold 1047), anl: 0 (threshold 73)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_namespace: vac: 0 (threshold 53), ins: 0 (threshold 1003), anl: 0 (threshold 51)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_depend: vac: 0 (threshold 1699), ins: 0 (threshold 2649), anl: 0 (threshold 874)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_database: vac: 0 (threshold 51), ins: 0 (threshold 1001), anl: 0 (threshold 50)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_tablespace: vac: 0 (threshold 50), ins: 0 (threshold 1000), anl: 0 (threshold 50)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_extension: vac: 0 (threshold 51), ins: 0 (threshold 1001), anl: 0 (threshold 50)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_sequence: vac: 0 (threshold 54), ins: 0 (threshold 1004), anl: 0 (threshold 52)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: pg_publication: vac: 0 (threshold 50), ins: 0 (threshold 1000), anl: 0 (threshold 50)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: bgw_job: vac: 0 (threshold 50), ins: 0 (threshold 1000), anl: 0 (threshold 50)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: bgw_job_stat: vac: 2 (threshold 50), ins: 0 (threshold 1000), anl: 2 (threshold 50)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: statistics: vac: 5 (threshold 226662), ins: 5 (threshold 227612), anl: 0 (threshold 113356)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.801 UTC [38] DEBUG: 00000: migration_changes: vac: 0 (threshold 51), ins: 0 (threshold 1001), anl: 0 (threshold 51)
2025-07-21 16:32:43.801 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: event_data: vac: 0 (threshold 535), ins: 0 (threshold 1485), anl: 0 (threshold 293)
2025-07-21 16:32:43.802 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: event_types: vac: 0 (threshold 54), ins: 0 (threshold 1004), anl: 0 (threshold 52)
2025-07-21 16:32:43.802 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: states: vac: 287 (threshold 112816832), ins: 1701 (threshold 112817784), anl: 1981 (threshold 56408440)
2025-07-21 16:32:43.802 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: state_attributes: vac: 0 (threshold 4255), ins: 2 (threshold 5205), anl: 2 (threshold 2152)
2025-07-21 16:32:43.802 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: states_meta: vac: 0 (threshold 228), ins: 0 (threshold 1178), anl: 0 (threshold 139)
2025-07-21 16:32:43.802 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: recorder_runs: vac: 5 (threshold 73), ins: 5 (threshold 1023), anl: 10 (threshold 61)
2025-07-21 16:32:43.802 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: schema_changes: vac: 0 (threshold 50), ins: 0 (threshold 1000), anl: 0 (threshold 50)
2025-07-21 16:32:43.802 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: statistics_meta: vac: 0 (threshold 77), ins: 0 (threshold 1027), anl: 0 (threshold 63)
2025-07-21 16:32:43.802 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: statistics_short_term: vac: 5 (threshold 2257460), ins: 979 (threshold 2258410), anl: 974 (threshold 1128755)
2025-07-21 16:32:43.802 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: events: vac: 5 (threshold 16058), ins: 233 (threshold 17008), anl: 228 (threshold 8054)
2025-07-21 16:32:43.802 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: statistics_runs: vac: 0 (threshold 20017), ins: 8 (threshold 20967), anl: 8 (threshold 10034)
2025-07-21 16:32:43.802 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: pg_toast_2619: vac: 0 (threshold 56), ins: 0 (threshold 1006), anl: 0 (threshold 53)
2025-07-21 16:32:43.802 UTC [38] LOCATION: relation_needs_vacanalyze, autovacuum.c:3196
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2025-07-21 16:32:43.802 UTC [38] LOCATION: ShowTransactionStateRec, xact.c:5510
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: shmem_exit(0): 4 before_shmem_exit callbacks to make
2025-07-21 16:32:43.802 UTC [38] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: shmem_exit(0): 7 on_shmem_exit callbacks to make
2025-07-21 16:32:43.802 UTC [38] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: proc_exit(0): 1 callbacks to make
2025-07-21 16:32:43.802 UTC [38] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: exit(0)
2025-07-21 16:32:43.802 UTC [38] LOCATION: proc_exit, ipc.c:154
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2025-07-21 16:32:43.802 UTC [38] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2025-07-21 16:32:43.802 UTC [38] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:43.802 UTC [38] DEBUG: 00000: proc_exit(-1): 0 callbacks to make
2025-07-21 16:32:43.802 UTC [38] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:43.804 UTC [1] DEBUG: 00000: reaping dead processes
2025-07-21 16:32:43.804 UTC [1] LOCATION: process_pm_child_exit, postmaster.c:2989
2025-07-21 16:32:43.804 UTC [1] DEBUG: 00000: server process (PID 38) exited with exit code 0
2025-07-21 16:32:43.804 UTC [1] LOCATION: LogChildExit, postmaster.c:3661
2025-07-21 16:32:46.900 UTC [1] DEBUG: 00000: postmaster received shutdown request signal
2025-07-21 16:32:46.900 UTC [1] LOCATION: process_pm_shutdown_request, postmaster.c:2821
2025-07-21 16:32:46.900 UTC [1] LOG: 00000: received fast shutdown request
2025-07-21 16:32:46.900 UTC [1] LOCATION: process_pm_shutdown_request, postmaster.c:2898
2025-07-21 16:32:46.901 UTC [1] LOG: 00000: aborting any active transactions
2025-07-21 16:32:46.901 UTC [1] LOCATION: process_pm_shutdown_request, postmaster.c:2916
2025-07-21 16:32:46.901 UTC [1] DEBUG: 00000: sending signal 15 to process 37
2025-07-21 16:32:46.901 UTC [1] LOCATION: SignalSomeChildren, postmaster.c:4072
2025-07-21 16:32:46.901 UTC [1] DEBUG: 00000: sending signal 15 to process 36
2025-07-21 16:32:46.901 UTC [1] LOCATION: SignalSomeChildren, postmaster.c:4072
2025-07-21 16:32:46.901 UTC [1] DEBUG: 00000: sending signal 15 to process 35
2025-07-21 16:32:46.901 UTC [1] LOCATION: SignalSomeChildren, postmaster.c:4072
2025-07-21 16:32:46.901 UTC [1] DEBUG: 00000: sending signal 15 to process 34
2025-07-21 16:32:46.901 UTC [1] LOCATION: SignalSomeChildren, postmaster.c:4072
2025-07-21 16:32:46.901 UTC [35] DEBUG: 00000: logical replication launcher shutting down
2025-07-21 16:32:46.901 UTC [35] LOCATION: ProcessInterrupts, postgres.c:3313
2025-07-21 16:32:46.901 UTC [35] DEBUG: 00000: shmem_exit(1): 5 before_shmem_exit callbacks to make
2025-07-21 16:32:46.901 UTC [35] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:46.901 UTC [33] DEBUG: 00000: autovacuum launcher shutting down
2025-07-21 16:32:46.901 UTC [33] LOCATION: AutoVacLauncherShutdown, autovacuum.c:856
2025-07-21 16:32:46.901 UTC [33] DEBUG: 00000: shmem_exit(0): 4 before_shmem_exit callbacks to make
2025-07-21 16:32:46.901 UTC [33] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:46.901 UTC [35] DEBUG: 00000: shmem_exit(1): 6 on_shmem_exit callbacks to make
2025-07-21 16:32:46.901 UTC [35] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:46.901 UTC [30] DEBUG: 00000: shmem_exit(0): 4 before_shmem_exit callbacks to make
2025-07-21 16:32:46.901 UTC [30] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:46.901 UTC [35] DEBUG: 00000: proc_exit(1): 1 callbacks to make
2025-07-21 16:32:46.901 UTC [35] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:46.901 UTC [33] DEBUG: 00000: shmem_exit(0): 6 on_shmem_exit callbacks to make
2025-07-21 16:32:46.901 UTC [33] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:46.901 UTC [35] DEBUG: 00000: exit(1)
2025-07-21 16:32:46.901 UTC [35] LOCATION: proc_exit, ipc.c:154
2025-07-21 16:32:46.901 UTC [35] DEBUG: 00000: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2025-07-21 16:32:46.901 UTC [35] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:46.901 UTC [35] DEBUG: 00000: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2025-07-21 16:32:46.901 UTC [35] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:46.901 UTC [35] DEBUG: 00000: proc_exit(-1): 0 callbacks to make
2025-07-21 16:32:46.901 UTC [35] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:46.901 UTC [30] DEBUG: 00000: shmem_exit(0): 5 on_shmem_exit callbacks to make
2025-07-21 16:32:46.901 UTC [30] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:46.901 UTC [33] DEBUG: 00000: proc_exit(0): 1 callbacks to make
2025-07-21 16:32:46.901 UTC [33] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:46.901 UTC [30] DEBUG: 00000: proc_exit(0): 1 callbacks to make
2025-07-21 16:32:46.901 UTC [30] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:46.901 UTC [30] DEBUG: 00000: exit(0)
2025-07-21 16:32:46.901 UTC [30] LOCATION: proc_exit, ipc.c:154
2025-07-21 16:32:46.901 UTC [33] DEBUG: 00000: exit(0)
2025-07-21 16:32:46.901 UTC [33] LOCATION: proc_exit, ipc.c:154
2025-07-21 16:32:46.901 UTC [33] DEBUG: 00000: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2025-07-21 16:32:46.901 UTC [33] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:46.901 UTC [30] DEBUG: 00000: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2025-07-21 16:32:46.901 UTC [30] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:46.901 UTC [33] DEBUG: 00000: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2025-07-21 16:32:46.901 UTC [33] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:46.901 UTC [30] DEBUG: 00000: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2025-07-21 16:32:46.901 UTC [30] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:46.901 UTC [33] DEBUG: 00000: proc_exit(-1): 0 callbacks to make
2025-07-21 16:32:46.901 UTC [33] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:46.901 UTC [30] DEBUG: 00000: proc_exit(-1): 0 callbacks to make
2025-07-21 16:32:46.901 UTC [30] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:46.901 UTC [36] FATAL: 57P01: terminating background worker "TimescaleDB Background Worker Scheduler" due to administrator command
2025-07-21 16:32:46.901 UTC [36] LOCATION: ProcessInterrupts, postgres.c:3323
2025-07-21 16:32:46.901 UTC [37] FATAL: 57P01: terminating background worker "TimescaleDB Background Worker Scheduler" due to administrator command
2025-07-21 16:32:46.901 UTC [37] LOCATION: ProcessInterrupts, postgres.c:3323
2025-07-21 16:32:46.903 UTC [32] DEBUG: 00000: shmem_exit(0): 4 before_shmem_exit callbacks to make
2025-07-21 16:32:46.903 UTC [32] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:46.903 UTC [32] DEBUG: 00000: shmem_exit(0): 5 on_shmem_exit callbacks to make
2025-07-21 16:32:46.903 UTC [32] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:46.903 UTC [32] DEBUG: 00000: proc_exit(0): 1 callbacks to make
2025-07-21 16:32:46.903 UTC [32] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:46.903 UTC [32] DEBUG: 00000: exit(0)
2025-07-21 16:32:46.903 UTC [32] LOCATION: proc_exit, ipc.c:154
2025-07-21 16:32:46.903 UTC [32] DEBUG: 00000: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2025-07-21 16:32:46.903 UTC [32] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:46.903 UTC [32] DEBUG: 00000: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2025-07-21 16:32:46.903 UTC [32] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:46.903 UTC [32] DEBUG: 00000: proc_exit(-1): 0 callbacks to make
2025-07-21 16:32:46.903 UTC [32] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:46.904 UTC [1] DEBUG: 00000: reaping dead processes
2025-07-21 16:32:46.904 UTC [1] LOCATION: process_pm_child_exit, postmaster.c:2989
2025-07-21 16:32:46.904 UTC [1] LOG: 00000: background worker "logical replication launcher" (PID 35) exited with exit code 1
2025-07-21 16:32:46.904 UTC [1] LOCATION: LogChildExit, postmaster.c:3661
2025-07-21 16:32:46.905 UTC [1] DEBUG: 00000: reaping dead processes
2025-07-21 16:32:46.905 UTC [1] LOCATION: process_pm_child_exit, postmaster.c:2989
2025-07-21 16:32:46.905 UTC [34] FATAL: 57P01: terminating background worker "TimescaleDB Background Worker Launcher" due to administrator command
2025-07-21 16:32:46.905 UTC [34] LOCATION: ProcessInterrupts, postgres.c:3323
2025-07-21 16:32:46.905 UTC [34] DEBUG: 00000: shmem_exit(1): 5 before_shmem_exit callbacks to make
2025-07-21 16:32:46.905 UTC [34] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:46.906 UTC [34] DEBUG: 00000: shmem_exit(1): 6 on_shmem_exit callbacks to make
2025-07-21 16:32:46.906 UTC [34] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:46.906 UTC [1] DEBUG: 00000: postmaster received pmsignal signal
2025-07-21 16:32:46.906 UTC [1] LOCATION: process_pm_pmsignal, postmaster.c:5086
2025-07-21 16:32:46.906 UTC [34] DEBUG: 00000: proc_exit(1): 1 callbacks to make
2025-07-21 16:32:46.906 UTC [34] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:46.906 UTC [34] DEBUG: 00000: exit(1)
2025-07-21 16:32:46.906 UTC [34] LOCATION: proc_exit, ipc.c:154
2025-07-21 16:32:46.906 UTC [34] DEBUG: 00000: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2025-07-21 16:32:46.906 UTC [34] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:46.906 UTC [34] DEBUG: 00000: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2025-07-21 16:32:46.906 UTC [34] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:46.906 UTC [34] DEBUG: 00000: proc_exit(-1): 0 callbacks to make
2025-07-21 16:32:46.906 UTC [34] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:46.906 UTC [1] DEBUG: 00000: reaping dead processes
2025-07-21 16:32:46.906 UTC [1] LOCATION: process_pm_child_exit, postmaster.c:2989
2025-07-21 16:32:46.906 UTC [1] DEBUG: 00000: unregistering background worker "TimescaleDB Background Worker Scheduler for database 5"
2025-07-21 16:32:46.906 UTC [1] LOCATION: ForgetBackgroundWorker, bgworker.c:450
2025-07-21 16:32:46.906 UTC [1] LOG: 00000: background worker "TimescaleDB Background Worker Scheduler" (PID 37) exited with exit code 1
2025-07-21 16:32:46.906 UTC [1] LOCATION: LogChildExit, postmaster.c:3661
2025-07-21 16:32:46.907 UTC [1] DEBUG: 00000: reaping dead processes
2025-07-21 16:32:46.907 UTC [1] LOCATION: process_pm_child_exit, postmaster.c:2989
2025-07-21 16:32:46.907 UTC [1] DEBUG: 00000: unregistering background worker "TimescaleDB Background Worker Scheduler for database 16384"
2025-07-21 16:32:46.907 UTC [1] LOCATION: ForgetBackgroundWorker, bgworker.c:450
2025-07-21 16:32:46.907 UTC [1] LOG: 00000: background worker "TimescaleDB Background Worker Scheduler" (PID 36) exited with exit code 1
2025-07-21 16:32:46.907 UTC [1] LOCATION: LogChildExit, postmaster.c:3661
2025-07-21 16:32:46.907 UTC [1] DEBUG: 00000: reaping dead processes
2025-07-21 16:32:46.907 UTC [1] LOCATION: process_pm_child_exit, postmaster.c:2989
2025-07-21 16:32:46.907 UTC [1] LOG: 00000: background worker "TimescaleDB Background Worker Launcher" (PID 34) exited with exit code 1
2025-07-21 16:32:46.907 UTC [1] LOCATION: LogChildExit, postmaster.c:3661
2025-07-21 16:32:46.908 UTC [29] LOG: 00000: shutting down
2025-07-21 16:32:46.908 UTC [29] LOCATION: ShutdownXLOG, xlog.c:6216
2025-07-21 16:32:46.909 UTC [29] LOG: 00000: checkpoint starting: shutdown immediate
2025-07-21 16:32:46.909 UTC [29] LOCATION: LogCheckpointStart, xlog.c:6266
2025-07-21 16:32:46.909 UTC [29] DEBUG: 00000: performing replication slot checkpoint
2025-07-21 16:32:46.909 UTC [29] LOCATION: CheckPointReplicationSlots, slot.c:1610
2025-07-21 16:32:46.920 UTC [29] DEBUG: 00000: checkpoint sync: number=1 file=pg_xact/0003 time=0.679 ms
2025-07-21 16:32:46.920 UTC [29] LOCATION: ProcessSyncRequests, sync.c:434
2025-07-21 16:32:46.920 UTC [29] DEBUG: 00000: checkpoint sync: number=2 file=pg_multixact/offsets/0000 time=0.747 ms
2025-07-21 16:32:46.920 UTC [29] LOCATION: ProcessSyncRequests, sync.c:434
2025-07-21 16:32:46.922 UTC [29] DEBUG: 00000: attempting to remove WAL segments older than log file 0000000000000117000000C9
2025-07-21 16:32:46.922 UTC [29] LOCATION: RemoveOldXlogFiles, xlog.c:3562
2025-07-21 16:32:46.922 UTC [29] DEBUG: 00000: SlruScanDirectory invoking callback on pg_subtrans/0039
2025-07-21 16:32:46.922 UTC [29] LOCATION: SlruScanDirectory, slru.c:1575
2025-07-21 16:32:46.922 UTC [29] LOG: 00000: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.007 s, sync=0.002 s, total=0.015 s; sync files=2, longest=0.001 s, average=0.001 s; distance=0 kB, estimate=0 kB; lsn=117/CA5A5458, redo lsn=117/CA5A5458
2025-07-21 16:32:46.922 UTC [29] LOCATION: LogCheckpointEnd, xlog.c:6355
2025-07-21 16:32:46.922 UTC [29] DEBUG: 00000: shmem_exit(0): 5 before_shmem_exit callbacks to make
2025-07-21 16:32:46.922 UTC [29] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:46.922 UTC [29] DEBUG: 00000: writing stats file "pg_stat/pgstat.stat"
2025-07-21 16:32:46.922 UTC [29] LOCATION: pgstat_write_statsfile, pgstat.c:1327
2025-07-21 16:32:46.923 UTC [29] DEBUG: 00000: shmem_exit(0): 5 on_shmem_exit callbacks to make
2025-07-21 16:32:46.923 UTC [29] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:46.923 UTC [29] DEBUG: 00000: proc_exit(0): 1 callbacks to make
2025-07-21 16:32:46.923 UTC [29] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:46.923 UTC [29] DEBUG: 00000: exit(0)
2025-07-21 16:32:46.923 UTC [29] LOCATION: proc_exit, ipc.c:154
2025-07-21 16:32:46.923 UTC [29] DEBUG: 00000: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2025-07-21 16:32:46.923 UTC [29] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:46.923 UTC [29] DEBUG: 00000: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2025-07-21 16:32:46.923 UTC [29] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:46.923 UTC [29] DEBUG: 00000: proc_exit(-1): 0 callbacks to make
2025-07-21 16:32:46.923 UTC [29] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:46.926 UTC [1] DEBUG: 00000: reaping dead processes
2025-07-21 16:32:46.926 UTC [1] LOCATION: process_pm_child_exit, postmaster.c:2989
2025-07-21 16:32:46.926 UTC [1] DEBUG: 00000: shmem_exit(0): 0 before_shmem_exit callbacks to make
2025-07-21 16:32:46.926 UTC [1] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:46.926 UTC [1] DEBUG: 00000: shmem_exit(0): 5 on_shmem_exit callbacks to make
2025-07-21 16:32:46.926 UTC [1] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:46.926 UTC [1] DEBUG: 00000: cleaning up orphaned dynamic shared memory with ID 4144971144
2025-07-21 16:32:46.926 UTC [1] LOCATION: dsm_postmaster_shutdown, dsm.c:370
2025-07-21 16:32:46.926 UTC [1] DEBUG: 00000: cleaning up dynamic shared memory control segment with ID 1812061442
2025-07-21 16:32:46.926 UTC [1] LOCATION: dsm_postmaster_shutdown, dsm.c:379
2025-07-21 16:32:46.939 UTC [1] DEBUG: 00000: proc_exit(0): 2 callbacks to make
2025-07-21 16:32:46.939 UTC [1] LOCATION: proc_exit_prepare, ipc.c:200
2025-07-21 16:32:46.939 UTC [1] LOG: 00000: database system is shut down
2025-07-21 16:32:46.939 UTC [1] LOCATION: UnlinkLockFiles, miscinit.c:1192
2025-07-21 16:32:46.939 UTC [1] DEBUG: 00000: exit(0)
2025-07-21 16:32:46.939 UTC [1] LOCATION: proc_exit, ipc.c:154
2025-07-21 16:32:46.939 UTC [1] DEBUG: 00000: shmem_exit(-1): 0 before_shmem_exit callbacks to make
2025-07-21 16:32:46.939 UTC [1] LOCATION: shmem_exit, ipc.c:240
2025-07-21 16:32:46.939 UTC [1] DEBUG: 00000: shmem_exit(-1): 0 on_shmem_exit callbacks to make
2025-07-21 16:32:46.939 UTC [1] LOCATION: shmem_exit, ipc.c:273
2025-07-21 16:32:46.939 UTC [1] DEBUG: 00000: proc_exit(-1): 0 callbacks to make
2025-07-21 16:32:46.939 UTC [1] LOCATION: proc_exit_prepare, ipc.c:200
Normal Log
Jul 21 18:54:24 HOST podman[760767]: 2025-07-21 18:54:24.435198314 +0200 CEST m=+0.116662196 container died 132bfe2d6b6d329f2b5b845644d69730af3d2b037a864633056f5a24051f400a (image=docker.MYDOMAIN.TLD/timescale/timescaledb-ha:pg16-all, name=homeassistant-timescaledb-operation, com.timescaledb.image.vectorscale.version=0.8.0, org.opencontainers.image.created=2025-07-15T08:23:27+00:00, com.timescaledb.image.install_method=docker-ha, com.timescaledb.image.pgBackRest.version=2.55.1, com.timescaledb.image.timescaledb.version=2.21.0, PODMAN_SYSTEMD_UNIT=homeassistant-timescaledb-operation.service, com.timescaledb.image.timescaledb_toolkit.version=1.21.0, com.timescaledb.image.vectorscale.available_versions=0.2.0,0.3.0,0.4.0,0.5.0,0.5.1,0.6.0,0.7.0,0.7.1,0.8.0, org.opencontainers.image.source=https://github.com/timescale/timescaledb-docker-ha, com.timescaledb.image.patroni.version=4.0.5, com.timescaledb.image.timescaledb.available_versions=2.12.2,2.13.0,2.13.1,2.14.0,2.14.1,2.14.2,2.15.0,2.15.1,2.15.2,2.15.3,2.16.0,2.16.1,2.17.0,2.17.1,2.17.2,2.18.0,2.18.1,2.18.2,2.19.0,2.19.1,2.19.2,2.19.3,2.20.0,2.20.1,2.20.2,2.20.3,2.21.0, org.opencontainers.image.revision=refs/heads/master, com.timescaledb.image.postgis.version=3.5.3, com.timescaledb.image.postgresql.available_versions=13.21,14.18,15.13,16.9, com.timescaledb.image.timescaledb_toolkit.available_versions=1.18.0,1.19.0,1.21.0, com.timescaledb.image.ai.version=0.11.0, org.opencontainers.image.vendor=Timescale, com.timescaledb.image.postgresql.version=16.9)
Jul 21 18:54:24 HOST podman[760767]: 2025-07-21 18:54:24.515706222 +0200 CEST m=+0.197170103 container remove 132bfe2d6b6d329f2b5b845644d69730af3d2b037a864633056f5a24051f400a (image=docker.MYDOMAIN.TLD/timescale/timescaledb-ha:pg16-all, name=homeassistant-timescaledb-operation, PODMAN_SYSTEMD_UNIT=homeassistant-timescaledb-operation.service, com.timescaledb.image.timescaledb_toolkit.version=1.21.0, org.opencontainers.image.created=2025-07-15T08:23:27+00:00, org.opencontainers.image.vendor=Timescale, com.timescaledb.image.pgBackRest.version=2.55.1, com.timescaledb.image.postgis.version=3.5.3, com.timescaledb.image.timescaledb_toolkit.available_versions=1.18.0,1.19.0,1.21.0, com.timescaledb.image.postgresql.version=16.9, org.opencontainers.image.revision=refs/heads/master, org.opencontainers.image.source=https://github.com/timescale/timescaledb-docker-ha, com.timescaledb.image.install_method=docker-ha, com.timescaledb.image.postgresql.available_versions=13.21,14.18,15.13,16.9, com.timescaledb.image.timescaledb.available_versions=2.12.2,2.13.0,2.13.1,2.14.0,2.14.1,2.14.2,2.15.0,2.15.1,2.15.2,2.15.3,2.16.0,2.16.1,2.17.0,2.17.1,2.17.2,2.18.0,2.18.1,2.18.2,2.19.0,2.19.1,2.19.2,2.19.3,2.20.0,2.20.1,2.20.2,2.20.3,2.21.0, com.timescaledb.image.vectorscale.version=0.8.0, com.timescaledb.image.timescaledb.version=2.21.0, com.timescaledb.image.ai.version=0.11.0, com.timescaledb.image.vectorscale.available_versions=0.2.0,0.3.0,0.4.0,0.5.0,0.5.1,0.6.0,0.7.0,0.7.1,0.8.0, com.timescaledb.image.patroni.version=4.0.5)
Jul 21 18:54:24 HOST homeassistant-timescaledb-operation[760767]: 132bfe2d6b6d329f2b5b845644d69730af3d2b037a864633056f5a24051f400a
Jul 21 18:54:24 HOST systemd[954]: Stopped homeassistant-timescaledb-operation.service - HomeAssistant TimescaleDB Operation Database.
░░ Subject: A stop job for unit UNIT has finished
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ A stop job for unit UNIT has finished.
░░
░░ The job identifier is 412777 and the job result is done.
Jul 21 18:54:24 HOST systemd[954]: homeassistant-timescaledb-operation.service: Consumed 548ms CPU time, 142.5M memory peak.
░░ Subject: Resources consumed by unit runtime
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ The unit UNIT completed and consumed the indicated resources.
Jul 21 18:54:24 HOST systemd[954]: Starting homeassistant-timescaledb-operation.service - HomeAssistant TimescaleDB Operation Database...
░░ Subject: A start job for unit UNIT has begun execution
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ A start job for unit UNIT has begun execution.
░░
░░ The job identifier is 412777.
Jul 21 18:54:24 HOST podman[760801]: 2025-07-21 18:54:24.665581679 +0200 CEST m=+0.079179885 container create d253eab7c2a63c50c00aca5be6a3572ccbbef08e07a5353be1d62761ef9675a9 (image=docker.MYDOMAIN.TLD/timescale/timescaledb-ha:pg16-all, name=homeassistant-timescaledb-operation, org.opencontainers.image.vendor=Timescale, com.timescaledb.image.pgBackRest.version=2.55.1, PODMAN_SYSTEMD_UNIT=homeassistant-timescaledb-operation.service, com.timescaledb.image.vectorscale.available_versions=0.2.0,0.3.0,0.4.0,0.5.0,0.5.1,0.6.0,0.7.0,0.7.1,0.8.0, com.timescaledb.image.postgresql.available_versions=13.21,14.18,15.13,16.9, com.timescaledb.image.timescaledb.available_versions=2.12.2,2.13.0,2.13.1,2.14.0,2.14.1,2.14.2,2.15.0,2.15.1,2.15.2,2.15.3,2.16.0,2.16.1,2.17.0,2.17.1,2.17.2,2.18.0,2.18.1,2.18.2,2.19.0,2.19.1,2.19.2,2.19.3,2.20.0,2.20.1,2.20.2,2.20.3,2.21.0, com.timescaledb.image.postgis.version=3.5.3, org.opencontainers.image.revision=refs/heads/master, com.timescaledb.image.timescaledb_toolkit.version=1.21.0, com.timescaledb.image.patroni.version=4.0.5, com.timescaledb.image.timescaledb.version=2.21.0, com.timescaledb.image.ai.version=0.11.0, com.timescaledb.image.vectorscale.version=0.8.0, org.opencontainers.image.source=https://github.com/timescale/timescaledb-docker-ha, com.timescaledb.image.timescaledb_toolkit.available_versions=1.18.0,1.19.0,1.21.0, com.timescaledb.image.postgresql.version=16.9, com.timescaledb.image.install_method=docker-ha, org.opencontainers.image.created=2025-07-15T08:23:27+00:00)
Jul 21 18:54:24 HOST podman[760801]: 2025-07-21 18:54:24.609706055 +0200 CEST m=+0.023304265 image pull 090a60fcf465bd416ba919de5143e5e4ea8f024f2e279241e3db613a0be0a668 timescale/timescaledb-ha:pg16-all
Jul 21 18:54:24 HOST podman[760801]: 2025-07-21 18:54:24.730686757 +0200 CEST m=+0.144284967 container init d253eab7c2a63c50c00aca5be6a3572ccbbef08e07a5353be1d62761ef9675a9 (image=docker.MYDOMAIN.TLD/timescale/timescaledb-ha:pg16-all, name=homeassistant-timescaledb-operation, com.timescaledb.image.ai.version=0.11.0, PODMAN_SYSTEMD_UNIT=homeassistant-timescaledb-operation.service, org.opencontainers.image.revision=refs/heads/master, com.timescaledb.image.postgresql.available_versions=13.21,14.18,15.13,16.9, org.opencontainers.image.created=2025-07-15T08:23:27+00:00, com.timescaledb.image.postgis.version=3.5.3, com.timescaledb.image.vectorscale.version=0.8.0, com.timescaledb.image.patroni.version=4.0.5, com.timescaledb.image.timescaledb.available_versions=2.12.2,2.13.0,2.13.1,2.14.0,2.14.1,2.14.2,2.15.0,2.15.1,2.15.2,2.15.3,2.16.0,2.16.1,2.17.0,2.17.1,2.17.2,2.18.0,2.18.1,2.18.2,2.19.0,2.19.1,2.19.2,2.19.3,2.20.0,2.20.1,2.20.2,2.20.3,2.21.0, com.timescaledb.image.install_method=docker-ha, com.timescaledb.image.pgBackRest.version=2.55.1, com.timescaledb.image.timescaledb_toolkit.version=1.21.0, com.timescaledb.image.timescaledb_toolkit.available_versions=1.18.0,1.19.0,1.21.0, com.timescaledb.image.postgresql.version=16.9, com.timescaledb.image.timescaledb.version=2.21.0, com.timescaledb.image.vectorscale.available_versions=0.2.0,0.3.0,0.4.0,0.5.0,0.5.1,0.6.0,0.7.0,0.7.1,0.8.0, org.opencontainers.image.source=https://github.com/timescale/timescaledb-docker-ha, org.opencontainers.image.vendor=Timescale)
Jul 21 18:54:24 HOST podman[760801]: 2025-07-21 18:54:24.735384655 +0200 CEST m=+0.148982866 container start d253eab7c2a63c50c00aca5be6a3572ccbbef08e07a5353be1d62761ef9675a9 (image=docker.MYDOMAIN.TLD/timescale/timescaledb-ha:pg16-all, name=homeassistant-timescaledb-operation, com.timescaledb.image.timescaledb.version=2.21.0, org.opencontainers.image.created=2025-07-15T08:23:27+00:00, com.timescaledb.image.postgresql.available_versions=13.21,14.18,15.13,16.9, com.timescaledb.image.postgresql.version=16.9, com.timescaledb.image.vectorscale.version=0.8.0, org.opencontainers.image.vendor=Timescale, com.timescaledb.image.patroni.version=4.0.5, com.timescaledb.image.timescaledb.available_versions=2.12.2,2.13.0,2.13.1,2.14.0,2.14.1,2.14.2,2.15.0,2.15.1,2.15.2,2.15.3,2.16.0,2.16.1,2.17.0,2.17.1,2.17.2,2.18.0,2.18.1,2.18.2,2.19.0,2.19.1,2.19.2,2.19.3,2.20.0,2.20.1,2.20.2,2.20.3,2.21.0, com.timescaledb.image.pgBackRest.version=2.55.1, PODMAN_SYSTEMD_UNIT=homeassistant-timescaledb-operation.service, org.opencontainers.image.revision=refs/heads/master, org.opencontainers.image.source=https://github.com/timescale/timescaledb-docker-ha, com.timescaledb.image.timescaledb_toolkit.version=1.21.0, com.timescaledb.image.timescaledb_toolkit.available_versions=1.18.0,1.19.0,1.21.0, com.timescaledb.image.install_method=docker-ha, com.timescaledb.image.ai.version=0.11.0, com.timescaledb.image.postgis.version=3.5.3, com.timescaledb.image.vectorscale.available_versions=0.2.0,0.3.0,0.4.0,0.5.0,0.5.1,0.6.0,0.7.0,0.7.1,0.8.0)
Jul 21 18:54:24 HOST systemd[954]: Started homeassistant-timescaledb-operation.service - HomeAssistant TimescaleDB Operation Database.
░░ Subject: A start job for unit UNIT has finished successfully
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ A start job for unit UNIT has finished successfully.
░░
░░ The job identifier is 412777.
Jul 21 18:54:24 HOST homeassistant-timescaledb-operation[760801]: d253eab7c2a63c50c00aca5be6a3572ccbbef08e07a5353be1d62761ef9675a9
Jul 21 18:54:24 HOST homeassistant-timescaledb-operation[760826]:
Jul 21 18:54:24 HOST homeassistant-timescaledb-operation[760826]: PostgreSQL Database directory appears to contain a database; Skipping initialization
Jul 21 18:54:24 HOST homeassistant-timescaledb-operation[760826]:
Jul 21 18:54:24 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:24.963 UTC [1] LOG: starting PostgreSQL 16.9 (Ubuntu 16.9-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
Jul 21 18:54:24 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:24.963 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
Jul 21 18:54:24 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:24.963 UTC [1] LOG: listening on IPv6 address "::", port 5432
Jul 21 18:54:24 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:24.965 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
Jul 21 18:54:24 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:24.970 UTC [28] LOG: database system was shut down at 2025-07-21 16:54:24 UTC
Jul 21 18:54:24 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:24.977 UTC [1] LOG: database system is ready to accept connections
Jul 21 18:54:24 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:24.979 UTC [31] LOG: TimescaleDB background worker launcher connected to shared catalogs
Jul 21 18:54:31 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:31.892 UTC [1] LOG: received fast shutdown request
Jul 21 18:54:31 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:31.893 UTC [1] LOG: aborting any active transactions
Jul 21 18:54:31 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:31.893 UTC [34] FATAL: terminating background worker "TimescaleDB Background Worker Scheduler" due to administrator command
Jul 21 18:54:31 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:31.893 UTC [33] FATAL: terminating background worker "TimescaleDB Background Worker Scheduler" due to administrator command
Jul 21 18:54:31 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:31.893 UTC [31] FATAL: terminating background worker "TimescaleDB Background Worker Launcher" due to administrator command
Jul 21 18:54:31 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:31.896 UTC [1] LOG: background worker "logical replication launcher" (PID 32) exited with exit code 1
Jul 21 18:54:31 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:31.896 UTC [1] LOG: background worker "TimescaleDB Background Worker Scheduler" (PID 33) exited with exit code 1
Jul 21 18:54:31 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:31.896 UTC [1] LOG: background worker "TimescaleDB Background Worker Scheduler" (PID 34) exited with exit code 1
Jul 21 18:54:31 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:31.897 UTC [1] LOG: background worker "TimescaleDB Background Worker Launcher" (PID 31) exited with exit code 1
Jul 21 18:54:31 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:31.898 UTC [26] LOG: shutting down
Jul 21 18:54:31 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:31.899 UTC [26] LOG: checkpoint starting: shutdown immediate
Jul 21 18:54:31 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:31.910 UTC [26] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.007 s, sync=0.002 s, total=0.013 s; sync files=2, longest=0.001 s, average=0.001 s; distance=0 kB, estimate=0 kB; lsn=117/CA5A63D0, redo lsn=117/CA5A63D0
Jul 21 18:54:31 HOST homeassistant-timescaledb-operation[760826]: 2025-07-21 16:54:31.922 UTC [1] LOG: database system is shut down
Jul 21 18:54:32 HOST systemd[954]: homeassistant-timescaledb-operation.service: Consumed 471ms CPU time, 128.4M memory peak.
░░ Subject: Resources consumed by unit runtime
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ The unit UNIT completed and consumed the indicated resources.
Container Configuration & Remarks
I even tried to take the Container outside of the Podman Pod and just run it on its own, since it was causing all sort of Issues (HomeAssistant Server was crashing due to not being able to contact the Database).
I thought actually that the TimescaleDB-HA Container was also crashing due to Systemd doing some weird Stuff, but I'd say that it's doing everything by itself.
Quadlet File for homeassistant-timescaledb-operation.container
:
[Unit]
Description=HomeAssistant TimescaleDB Operation Database
# Requires=homeassistant-caddy.service
# After=homeassistant-caddy.service
[Container]
ContainerName=homeassistant-timescaledb-operation
# Pod=homeassistant.pod
# StartWithPod=true
Environment=POSTGRES_PORT=5432
Environment=PGPORT=5432
HealthCmd=["pg_isready","-d","homeassistant","-U","homeassistant","-p","5432"]
HealthInterval=30s
HealthRetries=3
HealthTimeout=20s
Image=timescale/timescaledb-ha:pg16-all
Pull=missing
User=root
ShmSize=4096mb
Volume=/home/podman/containers/db/homeassistant/timescaledb-operation:/home/postgres/pgdata/data:rw,z
Volume=/home/podman/containers/secrets/homeassistant/timescaledb-operation/TIMESCALEDB_DB:/run/secrets/POSTGRES_DB:ro,z
Volume=/home/podman/containers/secrets/homeassistant/timescaledb-operation/TIMESCALEDB_USER:/run/secrets/POSTGRES_USER:ro,z
Volume=/home/podman/containers/secrets/homeassistant/timescaledb-operation/TIMESCALEDB_PASSWORD:/run/secrets/POSTGRES_PASSWORD:ro,z
# Network=container:homeassistant-caddy
[Service]
Restart=always
I cannot really see anything wrong in dmesg
or /var/log/audit/audit.log
. There's plenty of Free RAM / Memory on the Host (I also just moved it from another Host to this one to exclude a potential RAM as well as Disk IOWait Issue). Plenty of free INodes available. I wouldn't say "plenty" of Disk Space available, but still 20% out of the 1TB Virtual Disk, so approx. 200GB Free.
Bind Mount Folder for the Database is approx. 215 GB.
Any Idea about what is going on ?