Re: pg_stat warnings keep on printing in postgres log

On Fri, 6 Aug 2021 at 08:28, Naomi's strings <nidhin(dot)lazer(at)gmail(dot)com> wrote:

>
> Hi Team,
>
> One of our customer is getting the below warning's and log statements in
> the postgres logs, the postgres version is 12.2. Because of which the log
> size is increasing quickly.
>
> Is there any solution/workaround for this ? We have tried to turn off the
> "track_activities" settings in postgres.conf file but it is not helping.
>
> Could you please also let us know, in what circumstances the stat
> collector will run ? So that we can do that activity to reproduce the issue
> in our setup.
>
>
> LOG: could not rename temporary statistics file "pg_stat_tmp/db_0.tmp" to
> "pg_stat_tmp/db_0.stat": No such file or directory
>
> WARNING: corrupted statistics file "pg_stat_tmp/global.stat"
>

I would suggest you fix the underlying problem instead of trying to make
the logs go away.

Dave

>
>