title: DOCKER container with postgres, WARNING: could not open statistics file "pg_stat_tmp/global.stat": Operation not permitted
body: <p>I have a DOCKER container built from a few different images using a .yml, Dockerfile(s), etc.  Everything builds and runs fine so far, except for this one issue that I am seeing mentioned in the title:</p>
  <pre><code>index-db_1   | 2021-02-22 23:18:33.388 UTC [31] WARNING:  could not open statistics file &quot;pg_stat_tmp/global.stat&quot;: Operation not permitted
  </code></pre>
  <p>That Database Index is mapped to a Folder on the host in the root of the Docker Package, and everything else seems to work fine as far as the database is concerned.  I am using a Mac, but if I list permission from CLI for the DB folder I get:</p>
  <pre><code>-rw-------@  1 sscotti  staff      3 Feb 22 11:01 PG_VERSION
  drwx------@  6 sscotti  staff    192 Feb 22 11:54 base
  drwx------@ 60 sscotti  staff   1920 Feb 22 16:00 global
  drwx------@  2 sscotti  staff     64 Feb 22 11:01 pg_commit_ts
  drwx------@  2 sscotti  staff     64 Feb 22 11:01 pg_dynshmem
  -rw-------@  1 sscotti  staff   4782 Feb 22 11:02 pg_hba.conf
  -rw-------@  1 sscotti  staff   1636 Feb 22 11:01 pg_ident.conf
  drwx------@  5 sscotti  staff    160 Feb 22 17:46 pg_logical
  drwx------@  4 sscotti  staff    128 Feb 22 11:01 pg_multixact
  drwx------@  2 sscotti  staff     64 Feb 22 11:01 pg_notify
  drwx------@  2 sscotti  staff     64 Feb 22 11:01 pg_replslot
  drwx------@  2 sscotti  staff     64 Feb 22 11:01 pg_serial
  drwx------@  2 sscotti  staff     64 Feb 22 11:01 pg_snapshots
  drwx------@  2 sscotti  staff     64 Feb 22 16:00 pg_stat
  drwx------@  5 sscotti  staff    160 Feb 22 17:50 pg_stat_tmp
  drwx------@  3 sscotti  staff     96 Feb 22 11:01 pg_subtrans
  drwx------@  2 sscotti  staff     64 Feb 22 11:01 pg_tblspc
  drwx------@  2 sscotti  staff     64 Feb 22 11:01 pg_twophase
  drwx------@  4 sscotti  staff    128 Feb 22 11:01 pg_wal
  drwx------@  3 sscotti  staff     96 Feb 22 11:01 pg_xact
  -rw-------@  1 sscotti  staff     88 Feb 22 11:01 postgresql.auto.conf
  -rw-------@  1 sscotti  staff  28073 Feb 22 11:01 postgresql.conf
  -rw-------@  1 sscotti  staff     36 Feb 22 16:00 postmaster.opts
  -rw-------   1 sscotti  staff     94 Feb 22 16:00 postmaster.pid
  </code></pre>
  <p>pg_stat folder is actually empty.</p>
  <p>and pg_stat_temp has:</p>
  <pre><code>-rw-------  1 sscotti  staff   1952 Feb 22 17:54 db_0.stat
  -rw-------  1 sscotti  staff  20360 Feb 22 17:54 db_13395.stat
  -rw-------  1 sscotti  staff   1151 Feb 22 17:54 global.stat
  </code></pre>
  <p>The .yml file has this:</p>
  <pre><code>  index-db:
        image: postgres
        restart: unless-stopped
        volumes:
            - ./OrthancIndex:/var/lib/postgresql/data
  </code></pre>
  <p>Is that something that can just be ignored given that it is a Docker container.</p>
  <p><strong>Adding a comment about the same setup on UBUNTU.</strong></p>
  <p><strong>Database Folder:</strong></p>
  <p>drwx------  19 systemd-coredump root           4096 Jun 30 13:12 OrthancIndex</p>
  <p><strong>Database:</strong></p>
  <pre><code>drwx------ 6 systemd-coredump systemd-coredump  4096 Jun 11 13:00 base
  drwx------ 2 systemd-coredump systemd-coredump  4096 Jun 30 13:12 global
  drwx------ 2 systemd-coredump systemd-coredump  4096 Mar 12 16:12 pg_commit_ts
  drwx------ 2 systemd-coredump systemd-coredump  4096 Mar 12 16:12 pg_dynshmem
  -rw------- 1 systemd-coredump systemd-coredump  4782 Mar 12 16:12 pg_hba.conf
  -rw------- 1 systemd-coredump systemd-coredump  1636 Mar 12 16:12 pg_ident.conf
  drwx------ 4 systemd-coredump systemd-coredump  4096 Jul  1 13:27 pg_logical
  drwx------ 4 systemd-coredump systemd-coredump  4096 Mar 12 16:12 pg_multixact
  drwx------ 2 systemd-coredump systemd-coredump  4096 Mar 12 16:12 pg_notify
  drwx------ 2 systemd-coredump systemd-coredump  4096 Mar 12 16:12 pg_replslot
  drwx------ 2 systemd-coredump systemd-coredump  4096 Mar 12 16:12 pg_serial
  drwx------ 2 systemd-coredump systemd-coredump  4096 Mar 12 16:12 pg_snapshots
  drwx------ 2 systemd-coredump systemd-coredump  4096 Jun 30 13:12 pg_stat
  drwx------ 2 systemd-coredump systemd-coredump  4096 Jul  1 13:29 pg_stat_tmp
  drwx------ 2 systemd-coredump systemd-coredump  4096 Jun 24 21:04 pg_subtrans
  drwx------ 2 systemd-coredump systemd-coredump  4096 Mar 12 16:12 pg_tblspc
  drwx------ 2 systemd-coredump systemd-coredump  4096 Mar 12 16:12 pg_twophase
  -rw------- 1 systemd-coredump systemd-coredump     3 Mar 12 16:12 PG_VERSION
  drwx------ 3 systemd-coredump systemd-coredump  4096 Jul  1 12:37 pg_wal
  drwx------ 2 systemd-coredump systemd-coredump  4096 Mar 12 16:12 pg_xact
  -rw------- 1 systemd-coredump systemd-coredump    88 Mar 12 16:12 postgresql.auto.conf
  -rw------- 1 systemd-coredump systemd-coredump 28073 Mar 12 16:12 postgresql.conf
  -rw------- 1 systemd-coredump systemd-coredump    36 Jun 30 13:12 postmaster.opts
  -rw------- 1 systemd-coredump systemd-coredump    94 Jun 30 13:12 postmaster.pid
  </code></pre>
  <p><strong>pg_stat_temp</strong></p>
  <pre><code>-rw------- 1 systemd-coredump systemd-coredump  2660 Jul  1 13:30 db_0.stat
  -rw------- 1 systemd-coredump systemd-coredump 31157 Jul  1 13:30 db_13395.stat
  -rw------- 1 systemd-coredump systemd-coredump  1151 Jul  1 13:30 global.stat
  </code></pre>
  <p><strong>I actually get the same error on UBUNTU:</strong></p>
  <pre><code>postgres_index-db_1   | 2021-07-01 18:06:45.140 UTC [266] WARNING:  could not open statistics file &quot;pg_stat_tmp/global.stat&quot;: Operation not permitted
  postgres_index-db_1   | 2021-07-01 18:13:45.583 UTC [273] WARNING:  could not open statistics file &quot;pg_stat_tmp/global.stat&quot;: Operation not permitted
  postgres_index-db2_1  | 2021-07-01 18:19:43.716 UTC [282] WARNING:  could not open statistics file &quot;pg_stat_tmp/global.stat&quot;: Operation not permitted
  postgres_index-db2_1  | 2021-07-01 18:21:43.749 UTC [284] WARNING:  could not open statistics file &quot;pg_stat_tmp/global.stat&quot;: Operation not permitted
  </code></pre>
  <p>Although here the user and group are systemd-coredump.</p>