| From: | Greg Stark <stark(at)mit(dot)edu> |
|---|---|
| To: | Christopher Browne <cbbrowne(at)gmail(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers. |
| Date: | 2012-06-14 02:49:29 |
| Message-ID: | CAM-w4HNg7zFjdEzX7c72kTiVfqkUiy6PPG=NZ4efUijApR5=rQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
On Mon, Jun 4, 2012 at 8:49 PM, Christopher Browne <cbbrowne(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-06-14 04:14:33 | Re: Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers. |
| Previous Message | Tom Lane | 2012-06-14 02:23:52 | pgsql: Add 9.2 branch to git_changelog's list. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-06-14 04:14:33 | Re: Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers. |
| Previous Message | Craig Ringer | 2012-06-14 01:22:50 | Re: Minimising windows installer password confusion |