Home

plex-postgresql Wiki

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

Rust migration complete. The SQL translator and all PG backend modules are now implemented in Rust.

1,075+ tests (525 Rust + ~550 C across 25 suites) with GitHub Actions CI
Rust SQL translator: full AST-based SQLite-to-PostgreSQL translation via sqlparser-rs
Rust PG modules: pg_config, pg_logging, pg_mem_telemetry, shim_alloc, pg_query_cache, pg_statement, pg_client
Log level cleanup: informational pool messages demoted to INFO, reducing production log noise
Duplicate stmt fix: SQLSTATE 42P05 detection, DEALLOCATE ALL at connection init (v0.9.40)
Stale stmt recovery: prepared statement cache auto-invalidated after PG restart via SQLSTATE 26000 (v0.9.39)
Exec retry: sqlite3_exec with connection recovery and retry logic (v0.9.38)
Pool auto-grow: pool automatically grows when threads exceed configured size (v0.9.36)
Single-row streaming mode for all READ queries (PQsetSingleRowMode) (v0.9.28)