44a9221a9d
* chore(release): 1.4.0 * chore(release): 1.4.1 * chore(release): 1.5.0 * chore(release): 1.6.0 * chore(release): 1.7.0 * feat: support for postgresql * test(pgsql): disable root certificate verification * test(ci): temporarily change CI for local repo * fix: don't use SQLite idiom when using PgSQL * feat(db): add flag to toggle TLS for Postgres * feat(postgres and migrations): added migrations for postgres & imporved ssl for postgres config #186 * fix: restored workflow actions * fix: access order * fix: added pushover sound migration tto initial migration * fix: added option to log queries * fix: issue with session migration * chore: relocate pushover sound migration * feat: added logging option to other datasources * chore: small tweaks for the datasource. Added docs for db setup * chore: cleanup logs * fix: added default dates to postgres migration * fix: removed psql specific relation checks * chore: added some debug sanity checks * chore: added some more debug sanity checks * chore: added some more additional debug sanity checks * chore: added some more+ additional debug sanity checks * chore: mild log cleanup * chore: more log cleanup * chore: finish log cleanup * fix: added not null to migration so typeorm doesn't delete ids * chore: cleanup extra psql code * fix: remove eager load * docs: added documentation for migration to postgres * docs: added database option to bug template * feat: created docker-compose postgres file * fix: updated ts schema to align with change to migration * fix: switch timestamp to include timezone * fix: fixed indentation in psql docker-compose * fix: changed version to 0.1.0 to remove ui notification * style: fixed prettier in docker-compose.pastgres.yaml * chore: restored CHANGELOG.md * chore: revverted ts commit * fix: update pnpm lock with pg package * chore(pnpm-lock.yaml): updated pnpm-lock * docs: update docs to add psql set up info * refactor: clean up code from cr comments * feat: migrate blacklist * fix: fix issue with cypress tests * docs: update psql docs * fix: fix psql issue in user page; fix tiny psql error when selecting by empty list * fix: incorrect current date function * fix: null contraint with mediaAddedAt; fix psql col type * refactor: removed unnecessary import * feat: add postgres migration for streaming region --------- Co-authored-by: Fallenbagel <98979876+Fallenbagel@users.noreply.github.com> Co-authored-by: semantic-release-bot <semantic-release-bot@martynus.net> Co-authored-by: zackhow <zackhow@gmail.com> Co-authored-by: Ryan Algar <me@ralgar.dev> Co-authored-by: Ryan Algar <59636191+ralgar@users.noreply.github.com>
39 lines
1.1 KiB
YAML
39 lines
1.1 KiB
YAML
---
|
|
version: '3.8'
|
|
services:
|
|
jellyseerr:
|
|
build:
|
|
context: .
|
|
dockerfile: Dockerfile.local
|
|
ports:
|
|
- '5055:5055'
|
|
environment:
|
|
DB_TYPE: 'postgres' # Which DB engine to use. The default is "sqlite". To use postgres, this needs to be set to "postgres"
|
|
DB_HOST: 'postgres' # The host (url) of the database
|
|
DB_PORT: '5432' # The port to connect to
|
|
DB_USER: 'jellyseerr' # Username used to connect to the database
|
|
DB_PASS: 'jellyseerr' # Password of the user used to connect to the database
|
|
DB_NAME: 'jellyseerr' # The name of the database to connect to
|
|
DB_LOG_QUERIES: 'false' # Whether to log the DB queries for debugging
|
|
DB_USE_SSL: 'false' # Whether to enable ssl for database connection
|
|
volumes:
|
|
- .:/app:rw,cached
|
|
- /app/node_modules
|
|
- /app/.next
|
|
depends_on:
|
|
- postgres
|
|
links:
|
|
- postgres
|
|
postgres:
|
|
image: postgres
|
|
environment:
|
|
POSTGRES_USER: jellyseerr
|
|
POSTGRES_PASSWORD: jellyseerr
|
|
POSTGRES_DB: jellyseerr
|
|
ports:
|
|
- '5432:5432'
|
|
volumes:
|
|
- postgres:/var/lib/postgresql/data
|
|
volumes:
|
|
postgres:
|