feat(postgres): Option to configure Postgres for Radarr/Sonarr

[I-am-PUID-0]

Discussed in #154

^{Originally posted by dawnerd March 11, 2026}
Both of these support postgres as a database backend and since postgres is already being included I think it would make more sense to support automatically configuring these. The default sqlite implementation leads to a lot of locked database warnings and just gets slow at a certain point. I've been running other instances with Postgres as a database provider and it greatly improved performance.

See docs: https://wiki.servarr.com/radarr/postgres-setup

[ctchickenman]

You can create the required databases & edit the configs manually, but this is definitely something that should be enabled by default.

[I-am-PUID-0]