Bonjour, Bonjour,
Depuis quelques temps Postgresql ne démarre pas sur ma briq Lime1
Voici le log que j’ai trouvé :
# yunohost service log postgresql
/var/log/postgresql/postgresql-9.6-main.log:
journalctl:
- -- Logs begin at Sun 2020-10-18 19:56:12 UTC, end at Mon 2020-10-19 09:06:08 UTC. --
- Oct 19 09:04:47 systemd[1]: Starting PostgreSQL Cluster 11-main...
- -- Subject: A start job for unit postgresql@11-main.service has begun execution
- -- Defined-By: systemd
- -- Support: https://www.debian.org/support
- --
- -- A start job for unit postgresql@11-main.service has begun execution.
- --
- -- The job identifier is 22794.
- Oct 19 09:04:48 postgresql@11-main[11386]: Error: Could not open logfile /var/log/postgresql/postgresql-11-main.log
- Oct 19 09:04:48 postgresql@11-main[11386]: Error: /usr/lib/postgresql/11/bin/pg_ctl /usr/lib/postgresql/11/bin/pg_ctl start -D /var/lib/postgresql/11/main -l /var/log/postgresql/postgresql-11-main.log -s -o -c config_file="/etc/postgresql/11/main/postgresql.conf" exited with status 1:
- Oct 19 09:04:48 systemd[1]: postgresql@11-main.service: Can't open PID file /run/postgresql/11-main.pid (yet?) after start: No such file or directory
- Oct 19 09:04:48 systemd[1]: postgresql@11-main.service: Failed with result 'protocol'.
- -- Subject: Unit failed
- -- Defined-By: systemd
- -- Support: https://www.debian.org/support
- --
- -- The unit postgresql@11-main.service has entered the 'failed' state with result 'protocol'.
- Oct 19 09:04:48 systemd[1]: Failed to start PostgreSQL Cluster 11-main.
- -- Subject: A start job for unit postgresql@11-main.service has failed
- -- Defined-By: systemd
- -- Support: https://www.debian.org/support
- --
- -- A start job for unit postgresql@11-main.service has finished with a failure.
- --
- -- The job identifier is 22794 and the job result is failed.
Le plus surprenant est qu’il est fait référence à postgresql@11-main mais en même temps à /var/log/postgresql/postgresql-9.6-main.log
N’y aurait-il pas un conflit de version?
Quel serait le moyen de remédier à ce problème ?
Merci pour votre coup de main !