Installation Question?

[AndiZu99]

Hi folks,

I am really loving this and am looking to integrate it into my existing system. I have a server running n8n with Postgres, Qdrant and Ollama3 running via Docker. This works very well and I don’t want to mess it up! My question is… Firstly, can I safely install this on the same server without affecting everything else. (I assume I can?) and secondly, can I just add this my existing install? Ie: can I add planka to my existing docker-compose.yml and .env the the shit it down and up it again to install planka?

I’m fairly new to all of this so any help you can give would be much appreciated!

Great work btw!

[hwelch-fle]

I have had success just adding Planka to an existing Postgres server. You just need to create a user and a database for it:

psql -v ON_ERROR_STOP=0 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL
    DO \$\$
    BEGIN
        IF NOT EXISTS (SELECT FROM pg_catalog.pg_user WHERE usename = '$PLANKA_DB_USER') THEN
            CREATE USER "$PLANKA_DB_USER";
        END IF;
        ALTER USER "$PLANKA_DB_USER" WITH PASSWORD '$PLANKA_DB_PASS';
    END
    \$\$;
    CREATE DATABASE "$PLANKA_DB_NAME";
    GRANT ALL PRIVILEGES ON DATABASE "$PLANKA_DB_NAME" TO "$PLANKA_DB_USER";
EOSQL

I use that in my 00_init_dbs.sh startup script for Postgres, but you can just do it in raw SQL or through your interface of choice then use the connection string and user info in your Planka compose:

  planka:
    image: ghcr.io/plankanban/planka:latest
    container_name: planka
    hostname: planka
    command: >
      bash -c
        "for i in `seq 1 30`; do
          ./start.sh &&
          s=$$? && break || s=$$?;
          echo \"Tried $$i times. Waiting 5 seconds...\";
          sleep 5;
        done; (exit $$s)"
    restart: unless-stopped
    volumes:
      - user-avatars:/app/public/user-avatars
      - project-background-images:/app/public/project-background-images
      - attachments:/app/private/attachments
    ports:
      - 1337:1337
    environment:
      - BASE_URL=${PLANKA_BASE_URL}
      - DATABASE_URL=postgresql://${PLANKA_DB_USER}:${PLANKA_DB_PASS}@{POSTGRES_URL}/${PLANKA_DB_NAME}
      - SECRET_KEY=${PLANKA_SECRET_KEY}
      - TRUST_PROX=1

Raw SQL:

CREATE USER "planka" WITH PASSWORD "plankapass_CHANGE_ME";
CREATE DATABASE "planka";
GRANT ALL PRIVILEGES ON DATABASE "planka" TO "planka";