[osmosis-dev] osmosis loading, apidb and time zones

[Paul Norman]

From: Brett Henderson [mailto:brett at bretth.com] 
Sent: Friday, July 19, 2013 6:20 PM
Subject: Re: [osmosis-dev] osmosis loading, apidb and time zones

> I'm not sure how to diagnose this one. Perhaps trace queries against the 
> database server and see what Osmosis is passing in?

Probably easiest. I suspect postgres getting passed the wrong data.

> I'm also not sure why the schema doesn't use "timestamp with time zone". 
> It should make things a lot easier and allow all components to do 
> automatic timezone conversion as necessary. I seem to recall having 
> similar issues on the main OSM servers. I can't remember what the final 
> fix was there, but usually I aim to have everything running in UTC to 
> avoid these issues. 

My understanding from #postgres is that you want to want to avoid one of with or without, I'm just not sure which.