mattermost message retention crontab

cleanup-mm.sh

#!/bin/bash

CID="$(docker ps | grep srv-captain--mm-postgres | awk '{print $1}')"

CMD="
    delete from posts where createat < extract(epoch from (now() - interval '1 months'))::int8 * 1000;
    delete from reactions where postid not in (select id from posts);
    delete from fileinfo where postid not in (select id from posts);
"

echo "$CMD" | docker exec -i $CID psql -U mattermost mattermost