Re: WARNING : pgstat wait timeout - Postgres 9.1

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(dot)paquier(at)gmail(dot)com>

>
>
>
> On Thu, May 23, 2013 at 9:31 PM, Mathieu Guerin <
> mathieu(dot)guerin64(at)gmail(dot)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
>