You can set timezone = 'UTC' in your postgresql.conf, don't need to change it for the entire system. And personally I wouldn't really consider that "breaking",

You can set timezone = 'UTC' in your postgresql.conf, don't need to change it for the entire system. And personally I wouldn't really consider that "breaking", that seems far too strong. Although it can obviously a caveat. (Personally I do prefer to set the system time to UTC though, so it doesn't matter if the server is in Singapore, Germany, or the US – it's always the same. Also makes migrating things to different machines or moving VPSes to a different data centre a lot easier.)