By default postgres should be in UTC , show timezone; if it isn't change configuration timezone = 'UTC' in postgresq.conf
Store dates always in UTC, no mather user timezone, use AT TIME ZONE '' to convert it your query.
To know a list of valid values select * from pg_timezone_names;