Conversation

Notices

1. Embed this notice
   Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 16:28:48 JST Matty
   Hmm, wondering if the increase in work_mem is causing the instance to load faster, or if restarting the postgres service is. Time will well.
   • Embed this notice
     Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 16:28:30 JST Matty

     in reply to

     • Alex Gleason
     • Balrog Booger
     You have to understand, not everyone is going to run their stuff the same way. Could documentation be better? Sure. But part of the fun is breaking everything and trying again. Hell, NCD went through like two weeks of "okay everyone make accounts whoops I have to wipe the database and start over because I have no fucking clue what I'm doing".
     
     After all that, I still have no fucking idea what I'm doing but I'm taking a path to become a web developer because overcoming those obstacles is a reward in itself.
     Alex Gleason likes this.
   • Embed this notice
     Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 16:28:31 JST Matty

     in reply to

     • Alex Gleason
     • Balrog Booger

     I don’t think that there are any more links because that’s basically it, unless there is a requirement for you to make custom builds, which you can find instructions for on the Gitlab repository.

   • Embed this notice
     Balrog Booger (balrog_booger@kabuki.club)'s status on Tuesday, 29-Nov-2022 16:28:31 JST Balrog Booger

     in reply to

     • Alex Gleason

     Strictly speaking, that page has everything necessary for you to install it and get up and running, but it would definitely nice for there to be a PS: go to this.url for more info on administering and updating the instance as well as this link here to learn more about how the database works

   • Embed this notice
     Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 16:28:33 JST Matty

     in reply to

     • Alex Gleason
     • Balrog Booger
     That seems like an older version of the Soapbox installation instructions. From baseline, this is where you should start
     
     https://soapbox.pub/install/
   • Embed this notice
     Balrog Booger (balrog_booger@kabuki.club)'s status on Tuesday, 29-Nov-2022 16:28:33 JST Balrog Booger

     in reply to

     • Alex Gleason

     The instructions I followed that I’m talking about are the ones you linked to. What I’m saying is that once you’ve followed those instructions to the end, there aren’t any immediately obvious links to resources as to how to do anything else. If you’re like me, a retard-tier Linux sysadmin, once you finish those instructions, the resources to learn how to maintain and administer the instance properly are not anywhere obvious on Soapbox.pub

   • Embed this notice
     Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 16:28:34 JST Matty

     in reply to

     • Alex Gleason
     • Balrog Booger

     Remember - Soapbox is the frontend. It has little to do with Pleroma. Pleroma is the backend. Rebased is a fork, or modified version of Pleroma.

     There is a Pleroma-FE (frontend) that some retards use because they’re gay, but real chads use the Soapbox frontend.

     Do you understand the difference between the two?

   • Embed this notice
     Balrog Booger (balrog_booger@kabuki.club)'s status on Tuesday, 29-Nov-2022 16:28:34 JST Balrog Booger

     in reply to

     • Alex Gleason

     Yes, I understand that. What I’m saying is the Soapbox installation instructions should have links at least to https://docs.pleroma.social and https://docs.soapbox.pub/

     As of right now, you have to do more digging than I think is reasonable after using the installation instructions to find all that

   • Embed this notice
     Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 16:28:36 JST Matty

     in reply to

     • Alex Gleason
     • Balrog Booger

     For most backend related things you can rely on the baseline pleroma documentation. Rebased isn’t all that much different.

   • Embed this notice
     Balrog Booger (balrog_booger@kabuki.club)'s status on Tuesday, 29-Nov-2022 16:28:36 JST Balrog Booger

     in reply to

     • Alex Gleason

     This is the main one I’ve been looking at, but it took me some time to find information about updating Soapbox specifically, and it has very little info about postgres stuff. A couple links at least would be nice. I feel like I’m blind, feeling around in darkness for a lot of this info

   • Embed this notice
     Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 16:28:37 JST Matty

     in reply to

     • Alex Gleason
     • Balrog Booger

     The soapbox instructions do not implement the postgres apt repository.

     speaking of which, @alex , do you think it would be worthwhile to add the following instructions so that users can get the latest version of Postgres when installing Soapbox? Might as well, since the fediverse is growing.

     # Create the file repository configuration: sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' # Import the repository signing key: wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - # Update the package lists: sudo apt-get update # Install the latest version of PostgreSQL. # If you want a specific version, use 'postgresql-12' or similar instead of 'postgresql': sudo apt-get -y install postgresql
     Alex Gleason likes this.
   • Embed this notice
     Balrog Booger (balrog_booger@kabuki.club)'s status on Tuesday, 29-Nov-2022 16:28:37 JST Balrog Booger

     in reply to

     • Alex Gleason

     I think in general the Soapbox instructions could use some links to updating information. I’ve had to scour a few different documentation sites to learn anything at all, and I’ve helped another instance admin with the idiot-level knowledge I’ve gleamed

   • Embed this notice
     Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 16:28:38 JST Matty

     in reply to

     • Balrog Booger
     >postgres version 12
     
     wew lad. Upgrade to 15.
     
     https://www.postgresql.org/docs/current/upgrading.html
   • Embed this notice
     Balrog Booger (balrog_booger@kabuki.club)'s status on Tuesday, 29-Nov-2022 16:28:38 JST Balrog Booger

     in reply to

     It’s interesting that it’s so outdated. I just installed using the Soapbox instructions

   • Embed this notice
     Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 16:28:39 JST Matty

     in reply to

     • Balrog Booger

     What database version are you running?

     pg_lsclusters

   • Embed this notice
     Balrog Booger (balrog_booger@kabuki.club)'s status on Tuesday, 29-Nov-2022 16:28:39 JST Balrog Booger

     in reply to

     Ver Cluster Port Status Owner Data directory Log file 12 main 5432 online postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log

   • Embed this notice
     Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 16:28:41 JST Matty

     in reply to

     • Balrog Booger
     Postgres is more or less retard resistant. If it wasn't, I wouldn't be able to use it.
   • Embed this notice
     Balrog Booger (balrog_booger@kabuki.club)'s status on Tuesday, 29-Nov-2022 16:28:41 JST Balrog Booger

     in reply to

     What DB version is it? Is there an easy way to query the database directly so I know in the future?

   • Embed this notice
     Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 16:28:42 JST Matty

     in reply to

     • Balrog Booger

     No no no. Right now you probably don’t have to pgtune but I would, for future proofing at least to an extent. PG is Postgres. Vacuuming happens automatically, but if you’re experiencing specific issues, you may want to run a vacuum. You can repack your database weekly using crontab, which is what we do every Sunday to continuously optimize things. Are you familiar with crontab?

   • Embed this notice
     Balrog Booger (balrog_booger@kabuki.club)'s status on Tuesday, 29-Nov-2022 16:28:42 JST Balrog Booger

     in reply to

     Yeah, I have a few cronjobs set up for updating and such, but I haven’t done anything to the database yet because I don’t understand postgres well enough

   • Embed this notice
     Balrog Booger (balrog_booger@kabuki.club)'s status on Tuesday, 29-Nov-2022 16:28:43 JST Balrog Booger

     in reply to

     What’s the #1 tip you have when that starts to happen?

   • Embed this notice
     Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 16:28:43 JST Matty

     in reply to

     • Balrog Booger
     Increase resources. Bigger server, more cores, more RAM. However, if your instance really doesn't do all that stuff, a PGTune should be fine. Have you done that yet?
   • Embed this notice
     Balrog Booger (balrog_booger@kabuki.club)'s status on Tuesday, 29-Nov-2022 16:28:43 JST Balrog Booger

     in reply to

     No I haven’t, but I assume PG is postgres. I’ve looked up some stuff about vacuuming the database and such. Is it related to that?

   • Embed this notice
     Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 16:28:44 JST Matty

     in reply to

     • Balrog Booger
     Trust me, I know.
   • Embed this notice
     Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 16:28:45 JST Matty

     in reply to

     • Balrog Booger
     I like things to be as snappy as possible. If there are resources available, I want to utilize them. all of them.
   • Embed this notice
     Balrog Booger (balrog_booger@kabuki.club)'s status on Tuesday, 29-Nov-2022 16:28:45 JST Balrog Booger

     in reply to

     As of right now, Kabuki Club is very snappy, but it’s pretty much just me and one other guy using it regularly. When more people start to register, keeping it that way becomes a much more severe problem

   • Embed this notice
     Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 16:28:46 JST Matty

     in reply to

     • Balrog Booger
     I've learned that, at least with database tuning, you should make one change, then wait a couple days to see what happens.
   • Embed this notice
     Balrog Booger (balrog_booger@kabuki.club)'s status on Tuesday, 29-Nov-2022 16:28:46 JST Balrog Booger

     in reply to

     I haven’t even touched the instance database yet, but it’s starting to grow. I’m not looking forward to when it gets big enough where I have to

   • Embed this notice
     Matty (matty@nicecrew.digital)'s status on Tuesday, 29-Nov-2022 16:28:47 JST Matty

     in reply to

     • Balrog Booger
     We weren't having a problem, I just wanted to see if I could make Postgres use more RAM.
   • Embed this notice
     Balrog Booger (balrog_booger@kabuki.club)'s status on Tuesday, 29-Nov-2022 16:28:47 JST Balrog Booger

     in reply to

     I just meant it in a more general sense. I’ve done this 10,000 times and it’s maddening

   • Embed this notice
     Balrog Booger (balrog_booger@kabuki.club)'s status on Tuesday, 29-Nov-2022 16:28:48 JST Balrog Booger

     in reply to

     Tfw made two changes before restarting and can’t figure out which one fixed the problem

   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Tuesday, 29-Nov-2022 16:30:53 JST Alex Gleason

     in reply to

     • Balrog Booger

     @balrog_booger @matty You’re not wrong. The site/docs will get some more love eventually, but there are more pressing problems in the codebase at the moment.

   • Embed this notice
     Balrog Booger (balrog_booger@kabuki.club)'s status on Tuesday, 29-Nov-2022 16:30:54 JST Balrog Booger

     in reply to

     • Alex Gleason

     I mean, even linking to docs.pleroma.social would be a big improvement from the standpoint of the newbie. I don’t think that’s an unreasonable request. I had a good bit of Linux experience going into this, but a lot of people don’t

   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Tuesday, 29-Nov-2022 16:33:30 JST Alex Gleason

     in reply to

     • Balrog Booger

     @matty @balrog_booger I need to rebuild the website and docs so it’s easier to maintain.