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个月的旧数据？

支持

pfaffman (Jay Pfaffman) 2025 年2 月 14 日 00:35 2

什么数据？您正在解决什么问题？

话题		回复	浏览量
Purge/clean/delete deleted topics from database Support	4	335	2025 年7 月 5 日
Permanent deletion: Is there a database command? Support	4	587	2023 年7 月 15 日
How to remove admin logs Support	15	2549	2023 年11 月 15 日
Delete deleted-posts permanently in bulk? Support	59	5902	2022 年1 月 8 日
Specify custom purge interval for «scheduler_stats» tables Feature	2	782	2017 年4 月 28 日

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

相关话题