Hi,
As I wrote elsewhere, I updated and the automatic migration from 9.4 to 9.6 failed. I got information to migrate by hand, which I did, but now it seems partially failing :
- When I try to see the service status :
systemctl status postgresql.service ● postgresql.service - PostgreSQL RDBMS Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled) Active: active (exited) since Wed 2018-05-23 19:54:53 CEST; 14h ago Main PID: 455 (code=exited, status=0/SUCCESS) Tasks: 0 (limit: 4915) CGroup: /system.slice/postgresql.service Warning: Journal has been rotated since unit was started. Log output is incomplete or unavailable.
- When I try to use psql :
psql
psql: n’a pas pu se connecter au serveur : Aucun fichier ou dossier de ce type
Le serveur est-il actif localement et accepte-t-il les connexions sur la
socket Unix « /var/run/postgresql/.s.PGSQL.5432 » ?
- the folder /etc/postgresql/ is empty
- and of course, installing any app using postgresql fail (with the error above, probably because they use the psql command)
Can I remove/purge postgresql9.6 and reinstall it ? Where do I find a list of packages I should reinstall ? Does anyone know how to solve the issue ? Thanks in advance !