I got peertube install with Yunhost, and then while configurating my peertube (first tweaking) I’m in front of a little issue that has been solve by chocobuzz here :
DELETE FROM actor WHERE "preferredUsername" = '...' and "serverId" is null;
but how to enter the database ? I’m really new and don’t want to destroy the stuff in there ^^’
Thank you !
Coucou !
j’ai une instance peertube installée avec Yunohost, et en configurant celle là, (mes débuts de réglage), je me trouve face à un problème résolu ici par chocobuzz lui-même
DELETE FROM actor WHERE "preferredUsername" = '...' and "serverId" is null;
mais comment entrer dans la database sans créer de soucis particuliers ?
However, that runs as user postgres which is equivalent with running as DB root user. If you want surgical strike Peertube’s DB user name is peertube, password is obtainable with
sudo yunohost app setting peertube db_pwd
Then you can use it as psql --username=peertube -W --dbname=peertube --command="<some sql>", and when prompted for password paste what previous command shown. User peertube should only be entitled to peertube DB so if you make any mistake only that app is affected.
Also, I’d strongly recommend making app backup before running random SQL from the internet, just in case things go horribly wrong.