Conversation

Notices

1. Embed this notice
   ins0mniak ~Hate Account~ (ins0mniak@fsebugoutzone.org)'s status on Sunday, 02-Mar-2025 07:14:49 JST ins0mniak ~Hate Account~

   • lainy
   • Oneesan succubus
   • ✙ dcc :pedomustdie: :phear_slackware:
   • Phantasm
   • Tiberius J. Nougat
   • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
   • Sovereign Analysis
   • Vivi Nella Verita
   @verita84 @dcc @phnt @nyanide @lain @lord_nougat @Sovereign @lain I wanted to buy additional storage from frantech but alas its rarely availible
   • Embed this notice
     Phantasm (phnt@fluffytail.org)'s status on Sunday, 02-Mar-2025 07:14:44 JST Phantasm

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Sovereign Analysis
     • Vivi Nella Verita
     @ins0mniak @dcc @nyanide @lain @lord_nougat @Sovereign @lain @verita84 Don't fucking bother. You'll be micro-optimizing Postgres for eternity. The slabs have shittier IOPS than my old 80G IDE hard drive and using lvmcache to offset the shitty performance only helps you so much.
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
     ins0mniak ~Hate Account~ (ins0mniak@fsebugoutzone.org)'s status on Sunday, 02-Mar-2025 07:59:21 JST ins0mniak ~Hate Account~

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Phantasm
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Sovereign Analysis
     • Vivi Nella Verita
     @phnt @Sovereign @dcc @lain @lain @lord_nougat @nyanide @verita84 Yeah I got a more professional vps a while back.
     
     faster, lots more storage. I was planning to migrate mj12 anyway so you know, I'm not super worked up if I cant get mj12 back online.
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
     Sovereign Analysis (sovereign@pleroma.postawakening.com)'s status on Saturday, 15-Mar-2025 07:17:50 JST Sovereign Analysis

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Phantasm
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Vivi Nella Verita
     @phnt @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84 So I heard 2.9.1. is coming out later today? Would it be safe to upgrade now. I held off last time because of this thread lol.
     Phantasm likes this.
   • Embed this notice
     Phantasm (phnt@fluffytail.org)'s status on Saturday, 15-Mar-2025 07:17:50 JST Phantasm

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Sovereign Analysis
     • Vivi Nella Verita
     @Sovereign @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84 It's been out for a couple days already:
     https://git.pleroma.social/pleroma/pleroma/-/releases
     https://pleroma.social/announcements/2025/03/11/pleroma-release-2.9.1/
     
     So far nothing broke that I know of, but make a DB backup just to be sure.
     lainy likes this.
   • Embed this notice
     Sovereign Analysis (sovereign@pleroma.postawakening.com)'s status on Saturday, 15-Mar-2025 07:31:45 JST Sovereign Analysis

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Phantasm
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Vivi Nella Verita
     @phnt @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84 Oh ok! Thank you! I'll check into learning how to make those hehehe. Well I guess having a VM snapshot is my way of doing that without directly doing that. Ill try to upgrading directly from 2.8.0. I assume #hashtags work and a few new features came out?
     Phantasm likes this.
   • Embed this notice
     Phantasm (phnt@fluffytail.org)'s status on Saturday, 15-Mar-2025 07:32:08 JST Phantasm

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Sovereign Analysis
     • Vivi Nella Verita

     @Sovereign @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84

     = Pleroma = == Database backup == === schema === sudo -Hu postgres pg_dump -s pleroma -S postgres -v -f /mnt/pleroma-schema.psql === data (one or the other) === sudo -Hu postgres pg_dump -a pleroma --disable-triggers -S postgres -v -f /mnt/pleroma-data.psql # Uncompressed only pg_dump -a pleroma --disable-triggers -S postgres -v -f - | nice bzip2 -z9 - >/mnt/pleroma-data.psql.bz2 # Run as postgres user == Database restore == === schema === psql -v ON_ERROR_STOP=1 -d pleroma -U postgres -a -f pleroma-schema.psql === data === psql -v ON_ERROR_STOP=1 -d pleroma -U postgres -a -f pleroma-data.psql

     Backing up the DB with the custom format pg_dump -Fc might lead to a really long restore time thanks to indexes being built in a bad way. There's probably a way to workaround that and still use the custom format, but I've never tried to find one.

     You can now in 2.9.0 follow hashtags, but it isn't exposed in Pleroma-FE anyway. Husky/Tusky might have that functionality, but I never found the need for it. If you are going from 2.8.0 to 2.9.X, there are migrations you will need to run (check 2.9.0 release article on the main site).

     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
     ✙ dcc :pedomustdie: :phear_slackware: (dcc@annihilation.social)'s status on Saturday, 15-Mar-2025 07:40:17 JST ✙ dcc :pedomustdie: :phear_slackware:

     in reply to

     • lainy
     • Oneesan succubus
     • Phantasm
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Sovereign Analysis
     • Vivi Nella Verita
     @Sovereign @phnt @ins0mniak @nyanide @lain @lord_nougat @lain @verita84 Just make a new folder by git cloning and copy whats in what you already have
   • Embed this notice
     Sovereign Analysis (sovereign@pleroma.postawakening.com)'s status on Saturday, 15-Mar-2025 07:40:18 JST Sovereign Analysis

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Phantasm
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Vivi Nella Verita
     @phnt @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84 Would step #2 from here be required or is this outdated?
   • Embed this notice
     Phantasm (phnt@fluffytail.org)'s status on Saturday, 15-Mar-2025 07:41:35 JST Phantasm

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Sovereign Analysis
     • Vivi Nella Verita
     @Sovereign @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84
     
     1. Stop Pleroma (just to be sure)
     1.5 Backup DB
     2. MIX_ENV=prod mix deps.clean mime --build (this one is not in the notes, but Pleroma yells for not doing it for this specific release)
     3. MIX_ENV=prod mix deps.get
     4. MIX_ENV=prod mix compile
     5. MIX_ENV=prod mix ecto.migrate
     6. Start Pleroma
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
     Sovereign Analysis (sovereign@pleroma.postawakening.com)'s status on Saturday, 15-Mar-2025 07:41:36 JST Sovereign Analysis

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Phantasm
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Vivi Nella Verita
     @phnt @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84 So in this order?
     
     1st: MIX_ENV=prod mix deps.get
     2nd: MIX_ENV=prod mix compile
     
     "mix ecto.migrate" is the last thing before restarting Pleroma?
   • Embed this notice
     Phantasm (phnt@fluffytail.org)'s status on Saturday, 15-Mar-2025 07:43:24 JST Phantasm

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Sovereign Analysis
     • Vivi Nella Verita

     @Sovereign @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84

     I would switch to the stable branch with git switch stable instead and run git pull origin stable after that. That should give you the newest release. From there run the normal upgrade commands I've sent above.

   • Embed this notice
     Sovereign Analysis (sovereign@pleroma.postawakening.com)'s status on Saturday, 15-Mar-2025 07:43:31 JST Sovereign Analysis

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Phantasm
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Vivi Nella Verita
     @phnt @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84 Awesome man. I appreciate the help. Writing notes and bookmarking these posts for future reference. Super helpful! <3 🙌
     Phantasm likes this.
   • Embed this notice
     Sovereign Analysis (sovereign@pleroma.postawakening.com)'s status on Saturday, 15-Mar-2025 07:53:07 JST Sovereign Analysis

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Phantasm
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Vivi Nella Verita
     @phnt @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84 Not sure how that would be done lol. Also, do you know what would cause this in the server logs? It is probably a easy settings fix in the Admin FE.
     ✙ dcc :pedomustdie: :phear_slackware: repeated this.
   • Embed this notice
     Phantasm (phnt@fluffytail.org)'s status on Saturday, 15-Mar-2025 07:53:07 JST Phantasm

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Sovereign Analysis
     • Vivi Nella Verita
     @Sovereign @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84
     
     >Not sure how that would be done lol.
     
     1. cd /opt/pleroma
     2. git switch stable (you probably are on that branch, if you followed one of the install guides)
     3. git pull origin stable (a bunch of output for every changed file should spew out)
     
     >Also, do you know what would cause this in the server logs? It is probably a easy settings fix in the Admin FE.
     
     Never saw anything like that and considering the all caps ERROR I don't even think that is coming from Pleroma.
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
     Phantasm (phnt@fluffytail.org)'s status on Saturday, 15-Mar-2025 08:00:31 JST Phantasm

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Sovereign Analysis
     • Vivi Nella Verita
     @Sovereign @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84 It's probably the restrict unauthenticated API access that's a little bit above those. (I don't know the correct name as I don't use AdminFE.)
   • Embed this notice
     Sovereign Analysis (sovereign@pleroma.postawakening.com)'s status on Saturday, 15-Mar-2025 08:00:32 JST Sovereign Analysis

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Phantasm
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Vivi Nella Verita
     @phnt @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84 I thought one of these settings might have done that error.
   • Embed this notice
     Sovereign Analysis (sovereign@pleroma.postawakening.com)'s status on Saturday, 15-Mar-2025 08:07:29 JST Sovereign Analysis

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Phantasm
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Vivi Nella Verita
     @phnt @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84 No need to stop NGINX for any of this?
   • Embed this notice
     ✙ dcc :pedomustdie: :phear_slackware: (dcc@annihilation.social)'s status on Saturday, 15-Mar-2025 08:07:29 JST ✙ dcc :pedomustdie: :phear_slackware:

     in reply to

     • lainy
     • Oneesan succubus
     • Phantasm
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Sovereign Analysis
     • Vivi Nella Verita
     @Sovereign @phnt @ins0mniak @nyanide @lain @lord_nougat @lain @verita84 No
     Phantasm likes this.
   • Embed this notice
     ins0mniak (ins0mniak@mikoshidata.cloud)'s status on Saturday, 15-Mar-2025 08:18:43 JST ins0mniak

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Phantasm
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Sovereign Analysis
     • Vivi Nella Verita
     @phnt @dcc @ins0mniak @nyanide @lain @lord_nougat @Sovereign @lain @verita84 Im putting this all in my notes. Thanks man
     Phantasm likes this.
   • Embed this notice
     Phantasm (phnt@fluffytail.org)'s status on Saturday, 15-Mar-2025 08:18:52 JST Phantasm

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Sovereign Analysis
     • Vivi Nella Verita

     @Sovereign @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84 Yeah, some of these little Pleroma administration tricks aren't documented well and most of the knowledge spreads through asking/observing others.

     In this backup DB case, the official docs just say, run pg_dump -Fc ... and restore the schema and data at once.

     Gleason made a GitLab snippet which avoids the annoying long index build problem, but at the same time, the commands he gives you actually don't work, because the disabled triggers at data import need database superuser (postgres) privileges and he runs the restore as the normal pleroma user.

     And Pete wrote a blog post about the annoying index and how to actually work around it at the bottom of the article. And that should work with the custom format, but I've never tried it, so use at your own risk.

   • Embed this notice
     lainy (lain@lain.com)'s status on Saturday, 15-Mar-2025 08:20:29 JST lainy

     in reply to

     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Phantasm
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Sovereign Analysis
     • Vivi Nella Verita
     @phnt @dcc @ins0mniak @nyanide @lord_nougat @Sovereign @lain @verita84 I always just backup by copying the actual files, it’s fast and you don’t need to rebuild everything
     ✙ dcc :pedomustdie: :phear_slackware: and Phantasm like this.
   • Embed this notice
     Sovereign Analysis (sovereign@pleroma.postawakening.com)'s status on Saturday, 15-Mar-2025 18:50:54 JST Sovereign Analysis

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Phantasm
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Vivi Nella Verita
     @lain @dcc @phnt @ins0mniak @nyanide @lord_nougat @lain @verita84 I've been doing this for stuff like my config.exs, pleroma.exs, prod.secret.exs, my static directory, etc. Are you saying this is also doable for the Postgres database?
     
     Guys, thanks so much for the help. Sadly the upgrade did not go smoothly. At first I ran all the listed commands and when I checked the version, it never upgraded lol. I used ChatGPT, told it what happened, and it was somehow able to get me squared away. I am pretty sure I'm on the newest version now.
   • Embed this notice
     Phantasm (phnt@fluffytail.org)'s status on Saturday, 15-Mar-2025 18:50:54 JST Phantasm

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Sovereign Analysis
     • Vivi Nella Verita
     @Sovereign @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84
     >Are you saying this is also doable for the Postgres database?
     
     It is, but it will probably break if you move it to a system with a different collation and collation version (a reindex might fix that). And it will definitely break if you move it to a system with a different postgres version. But if you have two systems with identical setups, this is definitely an option.
   • Embed this notice
     Sovereign Analysis (sovereign@pleroma.postawakening.com)'s status on Saturday, 15-Mar-2025 18:51:17 JST Sovereign Analysis

     in reply to

     • lainy
     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Phantasm
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Vivi Nella Verita
     @phnt @dcc @ins0mniak @nyanide @lain @lord_nougat @lain @verita84 I had to do something like the following to get it to work (documenting in case anyone has an issue like I did in the future):
     
     git status
     sudo -Hu pleroma git pull
     sudo -Hu pleroma git reset --hard
     git restore --staged .
     git restore .
     git clean -fd
     
     git fetch origin
     git reset --hard origin/stable
     Phantasm likes this.
   • Embed this notice
     lainy (lain@lain.com)'s status on Saturday, 15-Mar-2025 18:58:39 JST lainy

     in reply to

     • Oneesan succubus
     • ✙ dcc :pedomustdie: :phear_slackware:
     • Phantasm
     • Tiberius J. Nougat
     • nyanide :nyancat_rainbow::nyancat_body::nyancat_face:
     • Sovereign Analysis
     • Vivi Nella Verita
     @phnt @dcc @ins0mniak @nyanide @lord_nougat @Sovereign @lain @verita84 I did it, it works even with different cpu architectures. There are also docker images that can upgrade the database version without much fuss.
     Phantasm likes this.