Re: could not rename temporary statistics file "/run/shm/pgstat.tmp" to "/run/shm/pgstat.stat": No such file or directory

On 04/22/2014 08:13 AM, basti wrote:
> I use Debian 7, Postgres 9.1, Kernel 3.2.0-3-amd64
> Syslog says nothing about postgres during this time.
> SELinux is not installed/active.
>
> I also found this (2 hours later) in the postgres log:
>
> 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
> postgres@srv1:/home/postgresql_data/postgresql/9.1/main/pg_log$ date &&
> ls -la /run/shm/
> Tue Apr 22 17:08:55 CEST 2014
> total 308
> drwxrwxrwt  2 root     root        100 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 postgres postgres      0 Apr 22 17:08 pgstat.tmp
> -rw-r--r--  1 root     root          0 Oct 19  2012 .tmpfs
> postgres@srv1:/home/postgresql_data/postgresql/9.1/main/pg_log$ date &&
> ls -la /run/shm/
> Tue Apr 22 17:09:07 CEST 2014
> total 52
> drwxrwxrwt  2 root     root        80 Apr 22 17:09 .
> drwxr-xr-x 20 root     root       660 Apr  8 11:15 ..
> -rw-------  1 postgres postgres 52658 Apr 22 17:09 pgstat.stat
> -rw-r--r--  1 root     root         0 Oct 19  2012 .tmpfs
> postgres@srv1:/home/postgresql_data/postgresql/9.1/main/pg_log$


Hmm, not sure what is going on.

Some thoughts.

Is there more than one instance of Postgres on this machine and could
there be a conflict?

What happens if you point at another directory?


>
> Basti
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com