Discussing internally now to just use Postgres.
What are your experiences with it? Any drawbacks compared to MySQL?
Most of the replies are dogmatic "just use UTC". I still haven't seen a strong argument that justifies the mental overhead of not keeping things local.
(As I said, a single tz app. Actually a multi-tz app with multitenancy. Tenants are geographically bound, so 1 tz per database)