Re: [COMMITTERS] pgsql: Send new protocol keepalive messages to standby servers.
Greg Stark <stark@mit.edu>
From: Greg Stark <stark@mit.edu>
To: Christopher Browne <cbbrowne@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2012-06-14T02:49:29Z
Lists: pgsql-hackers
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Send new protocol keepalive messages to standby servers.
- 64233902d22b 9.2.0 cited
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