On 9/17/14 9:07 AM, Matthew Kelly wrote:
> Here is where I think the timezone and PostGIS cases are fundamentally different:
> I can pretty easily make sure that all my servers run in the same timezone. That's just good practice. I'm also
goingto install the same version of PostGIS everywhere in a cluster. I'll build PostGIS and its dependencies from the
exactsame source files, regardless of when I build the machine.
I wrote time zone *database*, not time zone. The time zone database is
(in some configurations) part of glibc.
I also wrote PostGIS dependent libraries, not PostGIS itself. If you
are comparing RHEL 5 and 6, as you wrote elsewhere, then some of those
will most likely be different. (Heck, glibc could be different. Is
glibc never allowed to fix insufficiencies in its floating-point
implementation, for example?)
Also, there is nothing that guarantees that the PostGIS version will be
the same on both sides.