Thread: Re: could not rename temporary statistics file "/run/shm/pgstat.tmp" to "/run/shm/pgstat.stat": No such file or directory
Re: could not rename temporary statistics file "/run/shm/pgstat.tmp" to "/run/shm/pgstat.stat": No such file or directory
From
Tomáš Vondra
Date:
Seems you're using /run/shm and /var/run/shm by mistake. Tomas basti <mailinglist@unix-solution.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@postgresql.org) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-general
Re: could not rename temporary statistics file "/run/shm/pgstat.tmp" to "/run/shm/pgstat.stat": No such file or directory
From
basti
Date:
/run/shm and /var/run/shm would be the same. On my system I found no symlink to each other but there is the same content. Basti On 22.04.2014 12:02, Tomáš Vondra wrote: > Seems you're using /run/shm and /var/run/shm by mistake. > > Tomas > > basti <mailinglist@unix-solution.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@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >
Re: could not rename temporary statistics file "/run/shm/pgstat.tmp" to "/run/shm/pgstat.stat": No such file or directory
From
basti
Date:
/run/shm and /var/run/shm would be the same. On my system I found no symlink to each other but there is the same content. Basti On 22.04.2014 12:02, Tomáš Vondra wrote: > Seems you're using /run/shm and /var/run/shm by mistake. > > Tomas > > basti <mailinglist@unix-solution.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@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >