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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
