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.confI 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 -- 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
Attachment:
smime.p7s
Description: S/MIME Signature
