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(dot)klaver(at)aklaver(dot)com