Investigating myself, I stumbled over one significant change in the new container:
The owner of the hierarchy in /var/proget/database has changed in the updated container:
Old (2026.14):
root@proget:/usr/local/proget# ls -la /var/proget/database/
total 160
drwx------. 20 postgres root 4096 Nov 15 09:11 .
drwxr-xr-t. 8 root root 94 Nov 15 09:11 ..
-rw-r--r--. 1 root root 98 Jun 21 2025 .pgsqlconn
-rw-------. 1 postgres 104 3 Jun 21 2025 PG_VERSION
drwx------. 7 postgres 104 4096 Aug 20 2025 base
-rw-------. 1 postgres postgres 44 Nov 15 09:11 current_logfiles
drwx------. 2 postgres 104 16384 Nov 15 09:11 global
drwx------. 2 postgres postgres 12288 Nov 15 09:11 log
drwx------. 2 postgres 104 4096 Jun 21 2025 pg_commit_ts
drwx------. 2 postgres 104 4096 Jun 21 2025 pg_dynshmem
-rw-------. 1 postgres 104 206 Aug 29 2025 pg_hba.conf
-rw-------. 1 postgres 104 2640 Jun 21 2025 pg_ident.conf
drwx------. 4 postgres 104 4096 Nov 15 12:46 pg_logical
drwx------. 4 postgres 104 4096 Jun 21 2025 pg_multixact
drwx------. 2 postgres 104 4096 Jun 21 2025 pg_notify
drwx------. 2 postgres 104 4096 Jun 21 2025 pg_replslot
drwx------. 2 postgres 104 4096 Jun 21 2025 pg_serial
drwx------. 2 postgres 104 4096 Jun 21 2025 pg_snapshots
drwx------. 2 postgres 104 4096 Nov 15 09:11 pg_stat
drwx------. 2 postgres 104 4096 Jun 21 2025 pg_stat_tmp
drwx------. 2 postgres 104 4096 Nov 15 00:50 pg_subtrans
drwx------. 2 postgres 104 4096 Jun 21 2025 pg_tblspc
drwx------. 2 postgres 104 4096 Jun 21 2025 pg_twophase
drwx------. 4 postgres 104 4096 Nov 15 09:17 pg_wal
drwx------. 2 postgres 104 4096 Oct 5 10:51 pg_xact
-rw-------. 1 postgres 104 88 Jun 21 2025 postgresql.auto.conf
-rw-------. 1 postgres 104 30875 Jul 31 14:28 postgresql.conf
-rw-------. 1 postgres 104 64 Nov 15 09:11 postmaster.opts
-rw-------. 1 postgres postgres 100 Nov 15 09:11 postmaster.pid
New (2026.15):
root@proget:/usr/local/proget# ls -la /var/proget/database/
total 68
drwx------. 20 101 root 4096 Nov 15 11:47 .
drwxr-xr-t. 8 root root 94 Nov 15 11:47 ..
-rw-r--r--. 1 root root 98 Nov 15 11:18 .pgsqlconn
-rw-------. 1 101 103 3 Nov 15 11:18 PG_VERSION
drwx------. 6 101 103 46 Nov 15 11:18 base
-rw-------. 1 101 103 44 Nov 15 11:18 current_logfiles
drwx------. 2 101 103 4096 Nov 15 11:22 global
drwx------. 2 101 103 46 Nov 15 11:18 log
drwx------. 2 101 103 6 Nov 15 11:18 pg_commit_ts
drwx------. 2 101 103 6 Nov 15 11:18 pg_dynshmem
-rw-------. 1 101 103 206 Nov 15 11:18 pg_hba.conf
-rw-------. 1 101 103 2640 Nov 15 11:18 pg_ident.conf
drwx------. 4 101 103 68 Nov 15 11:32 pg_logical
drwx------. 4 101 103 36 Nov 15 11:18 pg_multixact
drwx------. 2 101 103 6 Nov 15 11:18 pg_notify
drwx------. 2 101 103 6 Nov 15 11:18 pg_replslot
drwx------. 2 101 103 6 Nov 15 11:18 pg_serial
drwx------. 2 101 103 6 Nov 15 11:18 pg_snapshots
drwx------. 2 101 103 25 Nov 15 11:32 pg_stat
drwx------. 2 101 103 6 Nov 15 11:18 pg_stat_tmp
drwx------. 2 101 103 18 Nov 15 11:18 pg_subtrans
drwx------. 2 101 103 6 Nov 15 11:18 pg_tblspc
drwx------. 2 101 103 6 Nov 15 11:18 pg_twophase
drwx------. 4 101 103 109 Nov 15 11:27 pg_wal
drwx------. 2 101 103 18 Nov 15 11:18 pg_xact
-rw-------. 1 101 103 88 Nov 15 11:18 postgresql.auto.conf
-rw-------. 1 101 103 31163 Nov 15 11:18 postgresql.conf
-rw-------. 1 101 103 64 Nov 15 11:18 postmaster.opts
Note: the uid:gid of the postgres user has changed from 101:103 to 994:994
Attempt to show this in a code snippet was denied for security reasons by the forum.
Apparently just mentioning the files path in /etc/ that stores these values, triggers a security alert of the forum so I had to obfuscate it a little bit:
Old:
root@proget:/usr/local/proget# grep postgres /etc/p*wd
postgres:x:101:103:PostgreSQL administrator,,,:/var/lib/postgresql:/bin/bash
New:
grep postgres /etc/p*wd
postgres:x:994:994:PostgreSQL administrator:/var/lib/postgresql:/bin/bash
And success after manually updating the owner in the container.
I just ran the following inside the container:
chown -R postgres /var/proget/database
After a container restart, it worked again.
=> I vaguely remember from the early releases with embedded postgres,
that there was some permission problem too. So: problem found - fix pending (i hope
)
Cheers
-Fritz