Use of existing mariaDB or PostgreSQL servers?

[tincanfury]

I already have a mariaDB and PostgreSQL server running and was wondering if there's any reason I couldn't use one of them with Yamtrack?

thanks!

[SinTan1729]

It should be fine. I use it with an existing postgres cluster. To be safe, create a separate user for yamtrack, create a database under that user, and provide the details to yamtrack. It should work as expected.

[ryan-winkler]

@tincanfury Any luck with this? curious to know how you got on!

[tincanfury]

Yes! I've been running this way for some time now without any issues.
Below is my Portainer stack, should also work as a compose.yml file(?). You have to manually add the user and db to your postgres db.
Now I need to see if I can easily rename from "yamtracke" to "floppy" =D

#https://github.com/FuzzyGrim/Yamtrack/wiki/Media-Import-Configuration#private-profile-import-oauth
services:
  floppy:
    #image: ghcr.io/dannyvfilms/yamtrack:26.7.9
    image: ghcr.io/dannyvfilms/floppy:v26.8.13
    #https://github.com/dannyvfilms/Floppy/tags
    container_name: floppy
    restart: unless-stopped
    depends_on:
      - floppy-redis
    environment:
      - PUID=1000
      - PGID=1000
      - SECRET=<hidden>
      - REDIS_URL=redis://floppy-redis:6379
      - TZ=America/New_York
      - ADMIN_ENABLED=True
      - DEMO_ACCOUNT_ENABLED=False
      - REGISTRATION=False
      - DB_HOST=postgres-vchord
      - DB_NAME=yamtracke
      - DB_USER=yamtracke
      - DB_PASSWORD=yamtracke
      - DB_PORT=5432
      - TRAKT_API=<hidden>
      - TRAKT_API_SECRET=<hidden>
    ports:
      - "7889:8000"
    networks:
      - floppy
      - postgres-vchord
    external_links:
      - postgres-vchord:postgres-vchord
    deploy:
      resources:
        # Hard limits - container cannot exceed these
        limits:
          cpus: '1.0'        # Maximum 1 CPU cores
          memory: 500M          # Maximum 0.5GB RAM

  floppy-redis:
    container_name: floppy-redis
    image: docker.io/valkey/valkey:8-bookworm@sha256:ff21bc0f8194dc9c105b769aeabf9585fea6a8ed649c0781caeac5cb3c247884
    healthcheck:
      test: redis-cli ping || exit 1
    environment:
      TZ: America/New_York #change Time Zone if needed
    restart: always
    volumes:
      - floppy_redis_data:/data
    networks:
      - floppy
    deploy:
      resources:
        # Hard limits - container cannot exceed these
        limits:
          cpus: '1.0'        # Maximum 1 CPU cores
          memory: 500M          # Maximum 0.5GB RAM
volumes:
  floppy_redis_data:

networks:
  postgres-vchord:
    name: postgres-vchord
  floppy: