On Mon, Jun 4, 2012 at 8:49 PM, Christopher Browne <cbbro...@gmail.com> wrote: >> What if the two servers are in different time zones? > > NTP shouldn't have any problem; it uses UTC underneath. As does > PostgreSQL, underneath.
As an aside, this is not strictly speaking true. NTP doesn't "use UTC" -- afaik it doesn't know about time zones at all. Likewise Postgres's underlying representation is not UTC either. They both use the number of seconds that have passed since the epoch. That's simply a number, not a time at all, and the number is the same regardless of what time zone you're in. -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
