Home

plex-postgresql Wiki

Run Plex Media Server with PostgreSQL instead of SQLite. Zero Plex modifications required.

278 unit tests (220 SQL + 41 shadow elimination + 17 connection isolation) with GitHub Actions CI
Exec retry: sqlite3_exec now has the same connection recovery and retry logic as sqlite3_step (Issue #8, v0.9.38)
Pool auto-grow: pool automatically grows when threads exceed configured size, prevents lockout (Issue #9, v0.9.36)
Docker chown fix: removed slow chown -R from standalone entrypoint (PR #7, v0.9.35)
PostgreSQL restart recovery: Plex fully recovers after PG restart, no Plex restart needed (v0.9.34)
Blobs UNIQUE index added, fixes ON CONFLICT upsert errors (v0.9.34)
Docker reliability: fresh-install crash fix, claim flow fix, migration fixes (v0.9.33)
Shadow SQLite elimination: decltype, column metadata from PostgreSQL (v0.9.32)
Single-row streaming mode for all READ queries (PQsetSingleRowMode) (v0.9.28)