Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 75671B5DBDA
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Thu, 30 Jun 2011 15:02:04 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 73026-07
	for <pgsql-hackers-postgresql.org@mail.postgresql.org>;
	Thu, 30 Jun 2011 18:01:57 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smtp-1.01.com (smtp-1.01.com [38.102.63.180])
	by mail.postgresql.org (Postfix) with ESMTP id 8341FB5DBE4
	for <pgsql-hackers@postgresql.org>;
	Thu, 30 Jun 2011 15:01:57 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by smtp-1.01.com (Postfix) with ESMTP id 6D969E3E47
	for <pgsql-hackers@postgresql.org>;
	Thu, 30 Jun 2011 13:01:56 -0500 (CDT)
Received: from smtp-1.01.com ([127.0.0.1])
	by localhost (smtp-1.01.com [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id v8IBHMg5uJAw for <pgsql-hackers@postgresql.org>;
	Thu, 30 Jun 2011 13:01:56 -0500 (CDT)
Received: by smtp-1.01.com (Postfix, from userid 99)
	id 14EF8E19BA; Thu, 30 Jun 2011 13:01:55 -0500 (CDT)
Received: from Sidney-Stratton.local (70-36-143-92.dsl.dynamic.sonic.net
	[70.36.143.92]) by smtp-1.01.com (Postfix) with ESMTPSA id ADDDFE340E
	for <pgsql-hackers@postgresql.org>;
	Thu, 30 Jun 2011 13:01:54 -0500 (CDT)
Message-ID: <4E0CBA11.2080402@agliodbs.com>
Date: Thu, 30 Jun 2011 11:01:53 -0700
From: Josh Berkus <josh@agliodbs.com>
Organization: PostgreSQL Experts Inc.
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US;
	rv:1.9.2.15) Gecko/20110303 Lightning/1.0b2 Thunderbird/3.1.9
MIME-Version: 1.0
To: pgsql-hackers@postgresql.org
Subject: Re: time-delayed standbys
References: <BANLkTi==TTzHDqWzwJDjmOf__8YuA7L1jw@mail.gmail.com>
	<BANLkTi=QScpDTkUw3iw6JaO15uUvx_P4qg@mail.gmail.com>
	<BANLkTimarB9eLhHpW73ja2oGvCaWNQuD6g@mail.gmail.com>
	<BANLkTi=hR3vGUDX-SQf=nFcL9ycmrQ6Fcg@mail.gmail.com>
	<BANLkTikPdjn98yjSR-VYywyjMe64wdrdDQ@mail.gmail.com>
	<26007.1303309175@sss.pgh.pa.us>
	<BANLkTikqGottQvyBzrXsARkaWMB2OEMGEA@mail.gmail.com>
	<27149.1303312506@sss.pgh.pa.us>
	<BANLkTin=22tyhK5zaNm7Nt-Q+MHcsNHdLg@mail.gmail.com>
	<BANLkTikFhVOhmf_XKERe=MkU3Ht_K7posQ@mail.gmail.com>
	<BANLkTi=COgk+8cieWxhM7YN9guYXOrDb_g@mail.gmail.com>
	<BANLkTingeD+XrxN-gDv0pzUMHrPcHWSF+A@mail.gmail.com>
	<BANLkTim8rKuUbDP=TxWmtfvZk8C1vmgmsw@mail.gmail.com>
	<BANLkTi=ufQk9i2Ria1U-c0VDUMUNxKjPgg@mail.gmail.com>
	<BANLkTi=33oiYV36cM_nOW7_Pi3t4E=P32g@mail.gmail.com>
	<BANLkTinSWseoHAYp7u+-3RHjQekd=5M2oA@mail.gmail.com>
	<BANLkTimGRb-cytLnibp1oxiUTkW=otrckg@mail.gmail.com>
	<4E0CB47E.7070909@agliodbs.com>
	<4E0C714D020000250003ED89@gw.wicourts.gov>
In-Reply-To: <4E0C714D020000250003ED89@gw.wicourts.gov>
X-Enigmail-Version: 1.1.1
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201106/2372
X-Sequence-Number: 191085

Kevin,

> I think doing anything in PostgreSQL around this beyond allowing
> DBAs to trust their server clocks is insane.  The arguments for
> using and trusting ntpd is pretty much identical to the arguments
> for using and trusting the OS file systems.

Oh, you don't want to implement our own NTP?  Coward!

;-)

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com