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

• 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

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

        Thank you for the link and the Redis pointers. I should double check that my Nextcloud setup is using Redis, it might well be misconfigured.

        source
      • sj_zero ⁨1⁩ ⁨year⁩ ago

        If you do end up using postgresql, over time the database could end up getting fragmented and that can lead to increased latency, so routine pg_repacks imo are a worthwhile thing to schedule.
• 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