Je suis bloqué car j’arrive pas à me connecter à hwhost-1 pour ajouter les 40-80G de SSD nécessaires au nettoyage de la BDD synapse
Dans le tmux ouvert sur sans-nuage connecté à postgre, il faut (voir history et https://github.com/YunoHost-Apps/synapse_ynh/issues/478 )
\c synapse
CREATE TEMPORARY TABLE unreffed(id BIGINT PRIMARY KEY);
COPY unreffed FROM '/home/admin_ghentz/unreferenced.csv' WITH (FORMAT 'csv');
DELETE FROM state_groups_state WHERE state_group IN (SELECT id FROM unreffed);
DELETE FROM state_group_edges WHERE state_group IN (SELECT id FROM unreffed);
DELETE FROM state_groups WHERE id IN (SELECT id FROM unreffed);
REINDEX (verbose) DATABASE synapse;
VACUUM;
VACUUM FULL;