Re: WARNING : pgstat wait timeout - Postgres 9.1

Поиск
Список
Период
Сортировка
От Mathieu Guerin
Тема Re: WARNING : pgstat wait timeout - Postgres 9.1
Дата
Msg-id CAFssqjMntVH=ZU=naRLdfoD_jF3AAa-dDF0SekptR7qWpDDc5A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: WARNING : pgstat wait timeout - Postgres 9.1  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: WARNING : pgstat wait timeout - Postgres 9.1
Список pgsql-hackers
Дерево обсуждения
Hello,

Thanks a lot for your answers.

> You should get it...
> stats_temp_directory       | pg_stat_tmp                                       | Writes temporary statistics files to the specified directory.

I don't know why i don't get it. I am in 9.1 version...

Moreover, when I mount pg_stat_tmp in a tmpfs, the warning messages decrease  the warning messages decrease from 1 each minutes to 1 each five secondes. I don't have any others logs warning but the file pg_stat.stat in the mounting point is not created... I tryed before on a test environment and it works...

If you have any ideas...
Thanks a lot.
Regards,
Math



2013/5/24 Michael Paquier <michael.paquier@gmail.com>



On Thu, May 23, 2013 at 9:31 PM, Mathieu Guerin <mathieu.guerin64@gmail.com> wrote:
What are the consequences ? Because this file will be remove if the server reboot.
Those temporary statistics are stored in global directory when server shuts down, so the risk here would be to lose a portion of this data in the case of a crash, either at PG or at OS level.
 
If we change the parameter stats_temp_directory is it necessary to reboot the server ?
No, sending SIGHUP to the server is enough.
 
When I lauch a SHOW ALL; command, the parameter stats_temp_director is not here.
You should get it...
stats_temp_directory            | pg_stat_tmp                                       | Writes temporary statistics files to the specified directory.
--
Michael

В списке pgsql-hackers по дате отправления: