Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 48BF26322BB for ; Mon, 9 Mar 2009 16:18:40 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 80655-07 for ; Mon, 9 Mar 2009 16:18:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f176.google.com (mail-gx0-f176.google.com [209.85.217.176]) by mail.postgresql.org (Postfix) with ESMTP id 91BD6634E93 for ; Mon, 9 Mar 2009 16:18:34 -0300 (ADT) Received: by gxk24 with SMTP id 24so3633807gxk.19 for ; Mon, 09 Mar 2009 12:18:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=0Foqa30xsQ0wDgYwOSbdW6ZBnOrNXGP6GdO1euKilqk=; b=lE12mIIUnX7M99yc00ZPpOcLsNJaBS3+NtUnJ6N5d9lg0nCFgK/sW9i83x8DsXLkhb e4evrmODXKMuQRYJ69LRnXji1XcRe6RrZsoot1Vtp7QEPeza0Cspc+62pq+98Ch77iE3 3dlI6QC0+jQf9j9OuPpzt0qP0yQ1FwGfeYOTA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=Skdqq7LUvL9qs5e5LVf1vsRbkHcK6ALQkrlAUdIYq2li7WJsZD6MDXypc+18wfUtgY 2jEq1JdQR7qidnr1xXVexDOtqPpI6Hqj9uRI5cDexkGphDYzEMGe8KUQi2YvB+RgmvLb UK4OT2+ReM6U083h4mrfwJip/0Rk6kJVuYOCs= MIME-Version: 1.0 Received: by 10.150.144.9 with SMTP id r9mr11324959ybd.91.1236626313108; Mon, 09 Mar 2009 12:18:33 -0700 (PDT) In-Reply-To: <49B56A7F.6040004@pinpointresearch.com> References: <49B56A7F.6040004@pinpointresearch.com> Date: Mon, 9 Mar 2009 13:18:33 -0600 Message-ID: Subject: Re: Urgent PST time changing tonight From: Scott Marlowe To: Steve Crawford Cc: DM , pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/114 X-Sequence-Number: 31614 On Mon, Mar 9, 2009 at 1:14 PM, Steve Crawford wrote: > Then there are the scripts that calculate dates externally for feeding into > your database-backed processes (for fun, try "-d yesterday" and "-d > tomorrow" in most versions of the "date" command in the vicinity of DST > changes). I ran into an issue with this a while back. We were running fairly modern distros at work, but older ones in production, and a script I'd written and tested on my workstation failed miserably if you ran it between midnight and 2/3am the sunday of the time shift on the production machines.