Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id BFDEA632492 for ; Tue, 10 Mar 2009 09:31:37 -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 32729-04 for ; Tue, 10 Mar 2009 09:31:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id A0146631FE0 for ; Tue, 10 Mar 2009 09:31:35 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id n2ACVVmX026182; Tue, 10 Mar 2009 08:31:31 -0400 (EDT) To: Scott Marlowe cc: Steve Crawford , DM , pgsql-admin@postgresql.org Subject: Re: Urgent PST time changing tonight In-reply-to: References: <49B56A7F.6040004@pinpointresearch.com> Comments: In-reply-to Scott Marlowe message dated "Tue, 10 Mar 2009 03:37:49 -0600" Date: Tue, 10 Mar 2009 08:31:31 -0400 Message-ID: <26181.1236688291@sss.pgh.pa.us> From: Tom Lane 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/131 X-Sequence-Number: 31631 Scott Marlowe writes: > Note that pgsql uses its own internal TZ data. So your OS being up to > date means little if your database is not. Well, it depends. I think practically all distro-supplied versions are using --with-system-tzdata (or equivalent patches in older PG releases) so that they don't need to turn PG when updating the TZ database. You really only want to use the built-in tzdata if you're on a system that doesn't receive software updates in some fairly automated manner. But the whole discussion only applies to people who live in places where the DST laws change without reasonable advance notice. regards, tom lane