@Tony You should consider putting your media on s3 or a second box running minio, it'll free up space. Backblaze is cheap, so is block storage on e.g. frantech
That's not a bad idea. The goal is to get the db off the vps on sunday. Once i have it locally, I can mess around with storage more, but i just need it off the vps so I can actually mess around with better storage options.
the db set up right now is a little wonky lol, there's like two layers of symlinks going to the media uploads. I learned more about postgres the last week than I ever wanted to know...
@Tony It may behoove you to upgrade to 16 then take the backup, then move it, then restore without worrying about database upgrades also being in the mix.
I think i have it figured out. The only think im concerned about is updating to postgres 16. I came very close to losing everything last weekend. I didn't realize you had to restore the db to the new cluster using the pg_dump/pg_basebackup file. I had one pg_dump file and then I just copied the whole cluster to a new location too just incase. Then I made a third pg_dump back up but typed in the mv command wrong when I was trying to move directories and combined the new cluster with the dump and had to delete the whole partition.
Thank god I had multiple backups of everything lmao.
After that mess I think im good on moving the db, but im not really sure how to adjust federation on pleroma fe. The new server i have set up federates horribly.
I technically could run the new instance on postgres 14, but because pleroma isn't quite compatible with new ubuntu, I had to compile it from source and got everything working on the newest packages so I kinda wanted to keep that upgrade train rolling.
nothing, just the new ubuntu 24.04 doesn't have legacy packages for older versions of postgress, elixer and other things. So you have to manually manage the versions and make it work together.
Well, that's why I went the compile route. The OTP version was giving me issues within the package manager and some of the older software versions weren't in the new ubuntu repositories. So i just compiled it so the kernel would work with new software versions and I manually imported them. (i think that's what i did, idk this whole process was new to me) but effectively that's what I did.
And that's good to know on the postgres thing. May as well be anal if all it costs is time.
regardless, i learned the value of version control lmao.
THe new ubuntu distro is also kinda locked down as far as the package manager. Which i kinda like? But it won't let you do apt install certain things and it throws a warning that it may wreck the system before you install it. Idk what OS you use, but i've been a fan of ubuntu.
I'm happy for the people who want to use obscure distros, that's what Linux is all about, but for the person who hates computers and just wants to get things done without as much Microsoft or Apple faggotry, Ubuntu is pretty much all they'll ever need, and the soy drinkers on MandarchzintaryOS (static rolling container release 14.6.2.3) can fuck off about it
@Tony everyone starts with Ubuntu. There are a handful of other normie friendly desktop distros. I would recommend you try Debian on server next time you're feeling frisky. It's a very sane choice, and what I would roll if for some reason I couldn't use alpine.
@Tony@pwm@mitchconner@UnityOstara@Hoss@vic everything steals your data these days so why not just let the whole OS do it for you from the porn you look at to your meme folder
@Tony very minimal. On my server cluster at home it boots over the network, and runs entirely in ram on a bunch of ewaste. Justwerks for a lot of stuff because it's basically the container is of choice for dockerbros et. al. which is also due to small size and minimal resource usage.
It falls flat for desktop programs because there is less developer effort behind making stuff that relies on glibc work nicely. BUT a lot of stuff even there also works if you're not using developer tools like I am. For reading email, browsing the web, and using libre office, it justwerks again.
Part of me wants to go full autist and run an arch set up for funsies. I think im at the point where i understand package managers enough to deal with it.
Well, what i realized the more i dig into pleroma/instances there's so many fucking directories and random shit that I never touch lol.
The fact postgress wants the db to live at /var/lib/postgresql/16/main and my db lives on a volume and I have to change config files to point media to the right place, then go to /var/lib/postgresqul/config files to change stuff is super annoying.
Idk. Just seems like a bunch of nonsense all around. It would be nice to have an OS with less random bullshit installed all over the place.
@Tony You will eventually get a gut feeling for where certain files "should" be. User configuration for system wide programs, those are usually in /etc/<program>/<somefile with a particular name>.{conf,yaml,toml,json,etc} Internal program data usually lives in /var/lib/<program> Software I build and install I usually put in /opt etc etc etc. The directory sprawl is sort of cultural and will get less weird the more you interact with it.