From: | Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz> |
---|---|
To: | PostgreSQL Admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | could not open temporary statistics file |
Date: | 2022-05-09 22:19:44 |
Message-ID: | 20220510001944.Horde.N8LRZQN7EM2ujr0tObCgw79@webmail.gelassene-pferde.biz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)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
--
S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH
Signal (Safer than WhatsApp): +49 1578 7723737
Threema (Safer than WhatsApp): A76MKH3J
Handy: +49 1578 772 37 37
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2022-05-10 02:45:17 | help me understand logs |
Previous Message | yanliang lei | 2022-05-09 16:58:31 | Re:Re: PostgreSQL14.2 can not start because of huge_page_size is equal to 1048576 |