Update to 3.0 b broke postgresql


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: 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 !

1 Like

I think you can try to apt-get install --reinstall postgresql to start with :wink:

That failed… as far as I can tell (psql command won’t work after reinstall)

I think apt-get purge on all 9.6 packages and reinstall them worked… As far as I can tell it seems to work. How can I test ?