On 22 April 2014 17:13, basti <mailinglist@unix-solution.de> wrote:
> 2014-04-22 11:01:42 CEST LOG: could not open temporary statistics file
> "/run/shm/pgstat.tmp": Permission denied
>
> I don't understand what's going on there:
>
> postgres@srv1:/home/postgresql_data/postgresql/9.1/main/pg_log$ date &&
> ls -la /run/shm/
> Tue Apr 22 17:08:41 CEST 2014
> total 308
> drwxrwxrwt 2 root root 80 Apr 22 17:08 .
> drwxr-xr-x 20 root root 660 Apr 8 11:15 ..
> -rw------- 1 postgres postgres 314577 Apr 22 17:08 pgstat.stat
> -rw-r--r-- 1 root root 0 Oct 19 2012 .tmpfs
> postgres@srv1:/home/postgresql_data/postgresql/9.1/main/pg_log$ touch
> /run/shm/pgstat.tmp
Is the postgres instance that is complaining really running as user postgres?
If you happen to have multiple postgres instances, chances are that
one is running as some user other than postgres. That would explain
why it can't modify those files.
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.