YES synapse was working one day…
But I had a similar problem 2 month ago… than i did a reinstall an it worked again for a while…
now what shell i do ?
i don´t want to lose all my configurations all the time by a reinstall
root@my:~# dpkg -l | grep postg
ii postgresql 9.6+181+deb9u2 all object-relational SQL database (supported versi
ii postgresql-9.6 9.6.13-0+deb9u1 armhf object-relational SQL database, version 9.6 ser
ii postgresql-client-9.6 9.6.13-0+deb9u1 armhf front-end programs for PostgreSQL 9.6
ii postgresql-client-com 181+deb9u2 all manager for multiple PostgreSQL client versions
ii postgresql-common 181+deb9u2 all PostgreSQL database-cluster manager
ii postgresql-contrib 9.6+181+deb9u2 all additional facilities for PostgreSQL (supported
ii postgresql-contrib-9. 9.6.13-0+deb9u1 armhf additional facilities for PostgreSQL
ii postgresql-server-dev 9.6.13-0+deb9u1 armhf development files for PostgreSQL 9.6 server-sid
ii postgresql-server-dev 181+deb9u2 all extension build tool for multiple PostgreSQL ve
root@my:~# su '--command=pg_dump matrix_synapse' postgres | head -n 20
could not change directory to "/root": Permission denied
pg_dump: [archiver (db)] connection to database "matrix_synapse" failed: 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"?
root@my:~# systemctl status postgresql
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Mon 2019-05-06 12:14:30 UTC; 6 days ago
Main PID: 2108 (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.