Job for postgresql@9.5-main.service failed because the control process exited with error code. See "systemctl status postgresql@9.5-main.service" and "journalctl -xe" for details.
root@VM-xxxx:/etc/postgresql/9.5/main# journalctl -xe
Oct 25 06:42:47 VM-xxxx sshd[45426]: Failed password for root from x.x.x.x port xxxx ssh2
Oct 25 06:42:47 VM-xxxx sshd[45426]: error: maximum authentication attempts exceeded for root from x.x.x.x port xxxx ssh2 [preauth]
Oct 25 06:42:47 VM-xxxx sshd[45426]: Disconnecting: Too many authentication failures [preauth]
Oct 25 06:42:47 VM-xxxx sshd[45426]: PAM 5 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=x.x.x.x user=root
Oct 25 06:42:47 VM-xxxx sshd[45426]: PAM service(sshd) ignoring max retries; 6 > 3
Job for postgresql@9.5-main.service failed because the control process exited with error code. See "systemctl status postgresql@9.5-main.service" and "journalctl -xe" for details.
2019-10-07 12:09:17 UTC [94653-2] CONTEXT: line 87 of configuration file "/etc/postgresql/9.5/main/pg_hba.conf"
2019-10-07 12:09:17 UTC [94653-3] FATAL: could not load pg_hba.conf
et le pga_hha
# Database administrative login by Unix domain socket
local all postgres peer
TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 0.0.0.0 0.0.0.0 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local replication postgres peer
#host replication postgres 127.0.0.1/32 md5
#host replication postgres ::1/128 md5
# Automatically added by Geotrek installation :
local geotrekdb geotrek md5
host geotrekdb geotrek 0.0.0.0/0 md5
host all all 0.0.0.0/0 md5
systemctl status postgresql
j'ai le retour suivant :
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Thu 2019-10-24 14:17:29 UTC; 37min ago
Main PID: 107811 (code=exited, status=0/SUCCESS)
CGroup: /system.slice/postgresql.service
Oct 24 14:17:29 VM systemd[1]: Starting PostgreSQL RDBMS...
Oct 24 14:17:29 VM systemd[1]: Started PostgreSQL RDBMS.
Si je fais :
pg_lsclusters
j'obtiens (la 2ème ligne est en rouge) :
Ver Cluster Port Status Owner Data directory Log file
9.5 main 5432 down postgres /var/lib/postgresql/9.5/main /var/log/postgresql/postgresql-9.5-main.log
J'ai vérifié les fichiers pg_hba.conf et postregsql.conf mais l'application reste indisponible.
Si je fais :
psql -l -U postgres
j'ai :
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
Si les spécialistes présents sur ce forum pouvaient m'aider, je leur en serai reconnaissant.
Merci d'avance.
Cordialement.