hey! How do i keep only last 3 months’ data and purge the rest? Via admin console? Thanks.

What data? What problem are you solving?

Thank you for your reply. We are trying to see how we can reduce the db size on our stage environment.

You’d have to restore the whole database, so what’s the point? And if you deleted a bunch of data then it wouldn’t be useful as a test of what’s on production? But there is a PostDestroyer and you could do a User.where(something).destroy_all, but that doesn’t seem very useful What do you think you…

yes, i just want last one month’s data. I dont need the rest.

[图片] Jay Pfaffman: Maybe you just want to generate some bogus data? I think there is a rake task for that Yes, there’s a task: [图片] Set up a staging server ./launcher enter app ALLOW_DEV_POPULATE=1 bundle install ALLOW_DEV_POPULATE=1 rake dev:populate

如何清除超过3个月的旧数据？

支持

Canapin (Coin-coin le Canapin) 2025 年3 月 2 日 10:05 6

是的，有一个任务：

话题		回复	浏览量
Purge/clean/delete deleted topics from database Support	4	340	2025 年7 月 5 日
Permanent deletion: Is there a database command? Support	4	589	2023 年7 月 15 日
How to remove admin logs Support	13	2562	2023 年11 月 14 日
Delete deleted-posts permanently in bulk? Support	58	5979	2021 年12 月 9 日
Specify custom purge interval for «scheduler_stats» tables Feature	2	783	2017 年4 月 28 日

如何清除超过3个月的旧数据？

相关话题