[OSM-dev] Fwd: Streaming Replication

[Brett Henderson]

On 14 October 2012 13:59, Brett Henderson <brett at bretth.com> wrote:

> On 14 October 2012 09:46, sly (sylvain letuffe) <liste at letuffe.org>wrote:note : I have a strange issue with all objects's timestamp, they seam
> to be
>
>> shifted by -1 hour
>>
>
> Really?  I might have to look into this this evening (currently 2pm
> Melbourne time).  I previously had a few issues with timezones (BST to UTC
> confusion), but I thought they were limited to the information in state
> files, not the data itself.
>

I've taken a look at it.  The process was running in the default server
timezone which is BST.  I've restarted the process explicitly setting the
timezone to UTC and it has fixed the problem.

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.

Anyway, the dates look right to me now.  A large number of replication
files will now have incorrect timestamps in them.  At some point I probably
should delete all existing replication data and start again from scratch.

Brett
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20121014/595305f0/attachment.html>