[OSM-dev] Fwd: Streaming Replication

[Matt Amos]

On Sun, 2012-10-14 at 22:39 +1100, Brett Henderson wrote:
> The timestamp columns in the database are set to "timestamp without
> time zone" which presumably means the timezones of dates aren't
> automatically converted to the correct timezone upon querying.  I'm a
> bit confused though because I believe PostgreSQL itself is running in
> the BST timezone.  I'd like to investigate further but I don't have
> time at the moment.

bare timestamps are stored in the database in UTC always [1]. as far as
i know, there's no way to decorate the column with this information, so
postgres doesn't have it to do any conversions. it seems likely that
somewhere along the stack of software doing the query something is
adding timezone information by defaulting to the current timezone, and
it shouldn't be doing that.

cheers,

matt

[1]
https://github.com/openstreetmap/openstreetmap-website/blob/master/app/models/node.rb#L290