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(at)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(at)srv1:/home/postgresql_data/postgresql/9.1/main/pg_log$ touch
> /run/shm/pgstat.tmp
> postgres(at)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(at)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(at)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(dot)klaver(at)aklaver(dot)com