Postgres

postgres.txt

# List users
SELECT * FROM pg_catalog.pg_user;

# Create user
CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass';

# Create db owned by user
CREATE DATABASE "sonarr-main" OWNER sonarr;
CREATE DATABASE "sonarr-log" OWNER sonarr;

# Migrate to postgres from sqlite
docker run --rm -v /absolute/path/to/prowlarr.db:/prowlarr.db:ro --network=host ghcr.io/roxedus/pgloader --with "quote identifiers" --with "data only" /prowlarr.db "postgresql://qstick:qstick@localhost/prowlarr-main"