xenoblade Posted May 28, 2022 Share Posted May 28, 2022 (edited) root@Tower:/mnt/user/appdata/postgresql14# ls -la total 64 drwx------ 1 999 users 70 May 29 01:10 ./ drwxrwxrwx 1 nobody users 584 May 10 12:45 ../ -rw-rw-rw- 1 999 users 3 Apr 1 16:29 PG_VERSION drwxrwxrwx 1 999 users 74 Apr 1 16:29 base/ drwxrwxrwx 1 999 users 4096 May 29 01:11 global/ drwxrwxrwx 1 999 users 10 Apr 1 16:29 pg_commit_ts/ drwxrwxrwx 1 999 users 10 Apr 1 16:29 pg_dynshmem/ -rw-rw-rw- 1 999 users 4821 Apr 1 16:29 pg_hba.conf -rw-rw-rw- 1 999 users 1636 Apr 1 16:29 pg_ident.conf drwxrwxrwx 1 999 users 42 May 29 01:11 pg_logical/ drwxrwxrwx 1 999 users 48 Apr 1 16:29 pg_multixact/ drwxrwxrwx 1 999 users 10 Apr 1 16:29 pg_notify/ drwxrwxrwx 1 999 users 10 Apr 1 16:29 pg_replslot/ drwxrwxrwx 1 999 users 10 Apr 1 16:29 pg_serial/ drwxrwxrwx 1 999 users 10 Apr 1 16:29 pg_snapshots/ drwxrwxrwx 1 999 users 10 May 29 00:22 pg_stat/ drwxrwxrwx 1 999 users 22 May 29 01:12 pg_stat_tmp/ drwxrwxrwx 1 999 users 26 May 26 17:00 pg_subtrans/ drwxrwxrwx 1 999 users 10 Apr 1 16:29 pg_tblspc/ drwxrwxrwx 1 999 users 10 Apr 1 16:29 pg_twophase/ drwxrwxrwx 1 999 users 108 May 27 10:00 pg_wal/ drwxrwxrwx 1 999 users 42 Apr 26 05:52 pg_xact/ -rw-rw-rw- 1 999 users 88 Apr 1 16:29 postgresql.auto.conf -rw-rw-rw- 1 999 users 28847 Apr 1 16:29 postgresql.conf -rw-rw-rw- 1 999 users 36 May 29 01:10 postmaster.opts -rw------- 1 999 999 94 May 29 01:11 postmaster.pid i am pretty sure the permission is fine. But i always get problem unraid version is 6.10.2 2022-05-29 00:22:49.825 CST [1] LOG: starting PostgreSQL 14.3 (Debian 14.3-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit 2022-05-29 00:22:49.825 CST [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2022-05-29 00:22:49.825 CST [1] LOG: listening on IPv6 address "::", port 5432 2022-05-29 00:22:49.827 CST [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2022-05-29 00:22:49.839 CST [26] LOG: database system was shut down at 2022-05-29 00:07:49 CST 2022-05-29 00:22:49.929 CST [1] LOG: database system is ready to accept connections 2022-05-29 01:10:04.861 CST [80] ERROR: could not open file "base/16384/2704": Permission denied 2022-05-29 01:10:04.861 CST [80] STATEMENT: SELECT "class", "entity", CAST("events" AS TEXT) AS "events" FROM "oc_flow_operations" WHERE "events" <> $1 GROUP BY "class", "entity", CAST("events" AS TEXT) 2022-05-29 01:10:27.856 CST [1] LOG: received fast shutdown request 2022-05-29 01:10:27.856 CST [1] LOG: could not open file "postmaster.pid": Permission denied 2022-05-29 01:10:27.856 CST [1] LOG: aborting any active transactions 2022-05-29 01:10:27.857 CST [1] LOG: background worker "logical replication launcher" (PID 32) exited with exit code 1 2022-05-29 01:10:27.857 CST [27] LOG: shutting down 2022-05-29 01:10:27.857 CST [27] PANIC: could not open file "/var/lib/postgresql/data/global/pg_control": Permission denied 2022-05-29 01:10:27.858 CST [1] LOG: checkpointer process (PID 27) was terminated by signal 6: Aborted 2022-05-29 01:10:27.858 CST [1] LOG: terminating any other active server processes 2022-05-29 01:10:27.858 CST [31] LOG: could not open temporary statistics file "pg_stat/global.tmp": Permission denied 2022-05-29 01:10:27.858 CST [1] LOG: abnormal database system shutdown 2022-05-29 01:10:27.860 CST [1] LOG: database system is shut down the strange is When restarted, docker starts one after the other without encountering permission issues. But when i click 'START ALL' button, the all docker will be started. And got the permission problem . please help me thank you tower-diagnostics-20220529-0111.zip Edited May 28, 2022 by xenoblade Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.