Re: could not rename temporary statistics file "/run/shm/pgstat.tmp" to "/run/shm/pgstat.stat": No such file or directory

From: Tomáš Vondra <tv(at)fuzzy(dot)cz>
To: basti <mailinglist(at)unix-solution(dot)de>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: could not rename temporary statistics file "/run/shm/pgstat.tmp" to "/run/shm/pgstat.stat": No such file or directory
Date: 2014-04-22 10:02:23
Message-ID: v61vkp171t36n87faq3ky2s8.1398160943005@email.android.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Seems you're using /run/shm and /var/run/shm by mistake.

Tomas

basti <mailinglist(at)unix-solution(dot)de>napsal/a:

>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"?
>
>Regards,
>Basti
>
>
>
>
>
>--
>Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-general

Responses

Browse pgsql-general by date

  From Date Subject
Next Message basti 2014-04-22 10:26:25 Re: could not rename temporary statistics file "/run/shm/pgstat.tmp" to "/run/shm/pgstat.stat": No such file or directory
Previous Message basti 2014-04-22 09:39:36 could not rename temporary statistics file "/run/shm/pgstat.tmp" to "/run/shm/pgstat.stat": No such file or directory