Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers. - Mailing list pgsql-hackers

From Greg Stark
Subject Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers.
Date
Msg-id CAM-w4HNg7zFjdEzX7c72kTiVfqkUiy6PPG=NZ4efUijApR5=rQ@mail.gmail.com
Whole thread Raw
In response to Re: Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers.  (Christopher Browne <cbbrowne@gmail.com>)
List pgsql-hackers
On Mon, Jun 4, 2012 at 8:49 PM, Christopher Browne <cbbrowne@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


pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Minimising windows installer password confusion
Next
From: Tom Lane
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers.