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
-- 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
