after half an hour in psql i managed to fix that. 0/10, would not recommend (i should really set up periodic database backups lol)