Re: could not open temporary statistics file - Mailing list pgsql-admin

Am 10.05.22 um 00:19 schrieb Thiemo Kellner:
> Hi
>
> I am not quite sure whether I am at the right place here.
>
> I installed PostgreSQL on a DebianEdu 11 system. First, I had only 
> version 14 by the "versionless" package. It ran as far as I can 
> remember (at least I remember creating roles and databases). Then I 
> decided to install 11 to 13 too to test "simultaneously" on several 
> versions. I did so on two systems and moved /etc/postgresql to a place 
> where I could put it into subversion and symlinked.
>
> thiemo @ thiemos-toshi ~ % ll -d /etc/postg*
> lrwxrwxrwx 1 root     root       62 Mai  4 01:32 /etc/postgresql -> 
> /home/thiemo/private_documents/linux/skolelinux/etc/postgresql
>
> thiemo @ thiemos-toshi ~ % tree 
> /home/thiemo/private_documents/linux/skolelinux/etc/postgresql
> /home/thiemo/private_documents/linux/skolelinux/etc/postgresql
> ├── 11
> │   ├── main
> │   │   ├── conf.d
> │   │   ├── environment
> │   │   ├── pg_ctl.conf
> │   │   ├── pg_hba.conf
> │   │   ├── pg_ident.conf
> │   │   ├── postgresql.conf
> │   │   └── start.conf
> │   └── postgresql.conf -> main/postgresql.conf
> ├── 12
> │   ├── main
> │   │   ├── conf.d
> │   │   ├── environment
> │   │   ├── pg_ctl.conf
> │   │   ├── pg_hba.conf
> │   │   ├── pg_ident.conf
> │   │   ├── postgresql.conf
> │   │   └── start.conf
> │   └── postgresql.conf -> main/postgresql.conf
>
> I cannot remember having changed the structure of the structure of the 
> config directory, so I am puzzled to find the directory "main" within. 
> I think it is causing troubles because before I symlinked 
> postgresql.conf, trying to start ended in complaints of not finding 
> said config file. This, I will ask Debian people.
>
> Now, it sort of starts, but it keeps logging missing statistics file 
> and using stale statistics.
> postgres@thiemos-toshi:~$ /usr/lib/postgresql/11/bin/postgres -p 5431 
> -D /etc/postgresql/11/main/
> 2022-05-09 23:49:38.378 CEST [45056] LOG:  listening on IPv6 address 
> "::1", port 5431
> 2022-05-09 23:49:38.378 CEST [45056] LOG:  listening on IPv4 address 
> "127.0.0.1", port 5431
> 2022-05-09 23:49:38.379 CEST [45056] LOG:  listening on Unix socket 
> "/var/run/postgresql/.s.PGSQL.5431"
> 2022-05-09 23:49:38.398 CEST [45057] LOG:  database system was shut 
> down at 2022-05-09 18:50:09 CEST
> 2022-05-09 23:49:38.409 CEST [45056] LOG:  database system is ready to 
> accept connections
> 2022-05-09 23:49:38.413 CEST [45062] LOG:  could not open temporary 
> statistics file "/var/run/postgresql/11-main.pg_stat_tmp/global.tmp": 
> No such file or directory
> ...
> 2022-05-09 23:51:08.782 CEST [45061] LOG:  using stale statistics 
> instead of current ones because stats collector is not responding
>
> I am concerned about three things.
> - Performance problems because of the stale statistics being used
> - Filling up log unnecessarily
> - The linking of postgresql.conf will have side effects.
>
> Actually, the first one is not that much of concern as I do not burden 
> load on the server, but I wonder what this is about. What do you think?
>
> Kind regards
>
> Thiemo
>
You could try to create the directory 
/var/run/postgresql/11-main.pg_stat_tmp and change ownership to 
postgres:postgres



-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012