💾 talkgroup backup log

I keep a reminder task to download backups. I use this topic to record it happening, and sizes.

1 Like
-rw-r--r--. 1 maiki maiki  14M Jul  2 11:20 talkgroup-2021-06-30-033613-v20210601002145.tar.gz
-rw-r--r--. 1 maiki maiki 218M Jul  2 11:25 talkgroup-2021-07-02-033135-v20210617202227.sql.gz
-rw-r--r--. 1 maiki maiki 17M Aug  1 15:05 talkgroup-2021-07-29-033124-v20210713092503.tar.gz
-rw-r--r--. 1 maiki maiki 78M Aug  4 14:00 talkgroup-2021-08-04-033548-v20210714173022.sql.gz

That seems like a dramatic decrease in size for the database… maybe there was an update that jump-started a queue to clear out old deleted topics or something… :thinking:

-rw-r--r-- 1 maiki maiki  17M Aug 31 09:51 talkgroup-2021-08-26-033604-v20210713092503.tar.gz
-rw-r--r-- 1 maiki maiki  76M Aug 31 13:03 talkgroup-2021-08-31-033603-v20210714173022.sql.gz

v1 backup is down 2MB. Fascinating! I think it is from processing popular topics, which have a lot of text, and the text reduction is what we’re seeing. :thinking:

-rw-r--r-- 1 maiki maiki  14M Oct  1 18:06 talkgroup-2021-09-30-033256-v20210824203421.tar.gz
-rw-r--r-- 1 maiki maiki  75M Oct  1 18:16 talkgroup-2021-10-01-033214-v20210824203421.sql.gz
-rw-r--r-- 1 maiki maiki  13M Nov  1 12:53 talkgroup-2021-10-28-033903-v20211019092048.tar.gz
-rw-r--r-- 1 maiki maiki  72M Nov  1 13:01 talkgroup-2021-11-01-033950-v20211019092048.sql.gz

Always neat to see how the sizes change over time. I’ll have to graph it at some point.

A recent version of Discourse now has the option to permanently delete content from the database, which is great, because now I we can fill it up with nonsense posts and experiments!


-rw-r--r-- 1 maiki maiki  12M Dec  1 11:50 talkgroup-2021-11-25-033321-v20211019092048.tar.gz
-rw-r--r-- 1 maiki maiki  72M Dec  1 11:48 talkgroup-2021-12-01-033605-v20211108023921.sql.gz
-rw-r--r-- 1 maiki maiki  13M Dec 31 10:51 talkgroup-2021-12-30-033654-v20211221164540.tar.gz
-rw-r--r-- 1 maiki maiki  72M Dec 31 10:52 talkgroup-2021-12-31-033225-v20211221164540.sql.gz
-rw-r--r-- 1 maiki maiki  18M Jan 31 14:32 talkgroup-2022-01-27-033046-v20220107014925.tar.gz
-rw-r--r-- 1 maiki maiki  74M Jan 31 14:36 talkgroup-2022-01-31-033651-v20220107014925.sql.gz
-rw-r--r-- 1 maiki maiki  20M Mar  1 08:57 talkgroup-2022-02-24-033110-v20220202225716.tar.gz
-rw-r--r-- 1 maiki maiki  74M Mar  1 08:57 talkgroup-2022-03-01-033605-v20220202225716.sql.gz
-rw-r--r-- 1 maiki maiki  22M Apr  1 09:40 talkgroup-2022-03-31-033141-v20220316150247.tar.gz
-rw-r--r-- 1 maiki maiki  74M Apr  1 09:40 talkgroup-2022-04-01-033242-v20220202225716.sql.gz