+- Jellyfin Forum (https://forum.jellyfin.org)
+-- Forum: Support (https://forum.jellyfin.org/f-support)
+--- Forum: General Questions (https://forum.jellyfin.org/f-general-questions)
+--- Thread: Postgres backend? (/t-postgres-backend)
Postgres backend? - weberc2 - 2024-10-28
According to https://github.com/jellyfin/jellyfin/issues/42#event-4573056324, support for multiple databases was merged back in 2021, but I can't find any information about configuring Jellyfin for Postgres which (as far as I can tell) is the main obstacle for running Jellyfin in a true high-availability configuration? Does anyone have more information about this? Am I missing something in the configuration docs?
RE: Postgres backend? - TheDreadPirate - 2024-10-28
That may have been an initial effort, but only recently has there been significant progress on migrating Jellyfin's database to EFCore to allow for external database applications.
https://github.com/jellyfin/jellyfin/pull/12798
Due to how big this change would be, 10.11 in 6 months is the earliest it could be introduced. But, like with everything FOSS, there is no guarantee or specific version/date for when it will actually be implemented.
RE: Postgres backend? - weberc2 - 2024-10-28
Thanks for the information! Any idea if this is sufficient for high availability, or are there other things to sort out (e.g., sticky sessions, race conditions in filesystem state, or hard-coded single-process assumptions in the application)?
RE: Postgres backend? - TheDreadPirate - 2024-10-28
I don't think HA will be a thing. Since Jellyfin is designed to be a home media server, so HA is "out of scope". Having said that, HA is out of scope for Jellyfin itself. Moving Jellyfin's DB externally, and using a load balancing reverse proxy, you could achieve similar functionality. As long as a user's session "sticks" to one of the Jellyfin instances.