Comment on I guess kind of obvious when I say it but I'm going to say it anyway (fixed a nextcloud error message)

bjoern_tantau@swg-empire.de ⁨1⁩ ⁨year⁩ ago

• morethanevil@lemmy.fedifriends.social ⁨1⁩ ⁨year⁩ ago

  Yes way faster, I switched a long time ago. If you want more extra speed add redis cache via unix sockets ☝🏻

  source

  • 4am@lemm.ee ⁨1⁩ ⁨year⁩ ago

    Looks like I’ve got a project for next weekend

    source
• tofubl@discuss.tchncs.de ⁨1⁩ ⁨year⁩ ago

  Interesting. Do you remember where you read this?

  The process seems simple enough, but it’s a scary task…

  source

  • tofubl@discuss.tchncs.de ⁨1⁩ ⁨year⁩ ago

    Okay, did the migration just now. Everything seems a little more responsive, but I wouldn’t call it way faster.

    Either way, it wasn’t very scary at all. For anybody coming after me:

    • add postgres container to compose file like so. I named mine “postgres”, added a “postgres” volume, and added it to depends_on for app and cron
    • run migration command from nextcloud app container like any other occ command and check admin settings/system for db state: ./occ db:convert-type --password $POSTGRES_PASSWORD --all-apps pgsql $POSTGRES_USER postgres $POSTGRES_DB
    • remove old “db” container and volume and all references to it from compose file and run docker compose up -d --remove-orphans

    source

    • haplo@lemmy.world ⁨1⁩ ⁨year⁩ ago

      Thank you for this. I really dislike MySQL/MariaDB and favor SQLite whenever possible, or PostgreSQL otherwise. The DB migration of my Nextcloud instance was high in my to-do list, and your instructions saved me research time.

      source

      • tofubl@discuss.tchncs.de ⁨1⁩ ⁨year⁩ ago

        Here’s a cool article I found on Nextcloud performance improvements, and connecting Redis over Unix sockets gave me a more substantial performance improvement than migrating to Postgres. Very happy I fell down this rabbit hole today.

        To note if you’re following the tutorial in the link above, and for people using the nextcloud:stable container together with the recommended cron container:

        • the redis configuration (host, port, password, …) need to be set in config/config.php, as well as config/redis.config.php
        • the cron container needs to receive the same /etc/localtime and /etc/timezone volumes the app container did, as well as the volumes_from: tmp

        source

        • -> View More Comments
  • bjoern_tantau@swg-empire.de ⁨1⁩ ⁨year⁩ ago

    Well, another guy responded before you, so that would be the last time I heard it.

    It was probably on one of the posts in this community.

    source