When Postgres has no permission why "pgstat.stat" is created by postgres? I have also try to create a file via su postgres -c "cd /run/shm/ && touch ...." /run# ls -la shm total 52 drwxrwxrwt 2 root root 100 Apr 22 16:09 . drwxr-xr-x 20 root root 660 Apr 8 11:15 .. -rw-r--r-- 1 postgres postgres 0 Apr 22 16:09 file_create_as_postgres_user -rw------- 1 postgres postgres 52658 Apr 22 16:09 pgstat.stat -rw-r--r-- 1 root root 0 Oct 19 2012 .tmpfs /run# ls -rtl | grep shm drwxrwxrwt 2 root root 80 Apr 22 16:02 shm I think these permissions are enough. Basti On 22.04.2014 15:36, Adrian Klaver wrote: > On 04/22/2014 02:39 AM, basti wrote: >> Hello, >> >> since I have enabled "stats_temp_directory = '/run/shm'" in >> /etc/postgresql/9.1/main/postgresql.conf I get the following error: >> >> 2014-04-21 02:37:29 CEST LOG: could not rename temporary statistics >> file "/run/shm/pgstat.tmp" to "/run/shm/pgstat.stat": No such file or >> directory >> >> /var/run/shm# ls -rtl >> -rw------- 1 postgres postgres 312211 Apr 22 11:31 pgstat.stat >> >> There is no "/run/shm/pgstat.tmp" file but if I create it and change the >> owner to postgres the file will be removed few minutes later. >> >> How can explain and how can I solve this "error"? > > Postgres does not have permissions on the directory. Give Postgres > permissions on the directory. > >> >> Regards, >> Basti >> >> >> >> >> > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
