[Feature] Split PostgreSQL read / writes

[denysvitali]

I have searched the existing feature requests, both open and closed, to make sure this is not a duplicate request.

• Yes

The feature

It looks like Immich is built without considering the fact that an HA setup of PostgreSQL should use query routing (send writes to a write replica and reads to a read replica).

Since this is not implemented in Immich, one has to resort to solutions similar to pgdog which do not yet fully support Immich's behaviors (e.g: locks, see pgdogdev/pgdog#134).

Is there any plan to allow users to specify a PostgreSQL read and write instance so that Immich can take care of sending the queries to the right replicas?

Platform

• Server
• Web
• Mobile