Post APoAhHOnSW3dmbx3kO by Jain@blob.cat
(DIR) More posts by Jain@blob.cat
(DIR) Post #APoAZBnwNJtI7Dr3FA by Jain@blob.cat
2022-11-20T21:59:09.841197Z
1 likes, 0 repeats
maybe its not a great idea to dump the db directly from one server to the other over ssh... its still dumping... well the db is quite big and i didnt check the size of the indexes...i guess around 150GB of 3 years fedi history
(DIR) Post #APoAhGnvfaZDwGhcHY by anna@witches.live
2022-11-20T22:00:07Z
1 likes, 0 repeats
@Jain w.l's is about 30 gigs and has been around about that long
(DIR) Post #APoAhHOnSW3dmbx3kO by Jain@blob.cat
2022-11-20T22:00:42.365721Z
0 likes, 0 repeats
@anna do you delete old content?
(DIR) Post #APoAwamhfM3mFZR3GS by anna@witches.live
2022-11-20T22:01:16Z
1 likes, 0 repeats
@Jain nope. still got a bunch of bofa.lol accounts :blobrofl:
(DIR) Post #APoAwbE01rtVcECqoK by Jain@blob.cat
2022-11-20T22:03:27.731779Z
0 likes, 0 repeats
@anna but how? i mean you should also have a constant stream of new posts... i can understand if your db grows slower but it should grow
(DIR) Post #APoBtOUL1hl7CQsrpY by anna@witches.live
2022-11-20T22:05:53Z
1 likes, 0 repeats
@Jain it grows but its about 30gb right nowi think last night's shrunk a little because i found some people that blocked us that i made mutual, but other than that it grows
(DIR) Post #APoC3eApZ03Sk6eGiu by Jain@blob.cat
2022-11-20T22:15:56.076466Z
0 likes, 0 repeats
@anna nice, i do have a big bunch of inactive users and im pretty sure that they are the reason for its grow
(DIR) Post #APoCexWQacftStXg0m by midgephoto@photog.social
2022-11-20T22:18:01Z
0 likes, 0 repeats
@Jain maybe rsync in preparation, then just new and different stuff needs to move at the last? Not that I know much.
(DIR) Post #APoCeyOJMHmCA0ki00 by Jain@blob.cat
2022-11-20T22:22:39.912316Z
0 likes, 0 repeats
@midgephoto yeah... theoretically i could replicate all changes on one server to the other server until the final move but im not a postgres professional so i think i might just not do that
(DIR) Post #APoClNEntN3sxUMDnU by Jain@blob.cat
2022-11-20T22:23:51.283865Z
0 likes, 0 repeats
@midgephoto @ivesen :blobcatthis: