submitted 2 years ago by [email protected] to c/[email protected]

29 comments fedilink hide all child comments

Deleted something I shouldn't have. I learned my lesson, but I had to revert to a backup that was about 3 days old. My bad.

you are viewing a single comment's thread
view the rest of the comments

[-] [email protected] 2 points 2 years ago

I don't know the actual table definitions for lemmy, but it should look something like:

DELETE FROM activitypub
WHERE createdDate < ((SELECT CURRENT_DATE) - interval '2 weeks')

this post was submitted on 19 Jul 2023

81 points (96.6% liked)

main

1433 readers

1 users here now

Default community for midwest.social. Post questions about the instance or questions you want to ask other users here.

founded 3 years ago

MODERATORS