From: Tom Lane <tgl@sss.pgh.pa.us>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Steve Crawford <scrawford@pinpointresearch.com>
Cc: DM <dm.aeqa@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Urgent PST time changing tonight
Date: Tue, 10 Mar 2009 08:31:31 -0400
Message-ID: <26181.1236688291@sss.pgh.pa.us> (raw)
In-Reply-To: <dcc563d10903100237i368e2244x41e9ea5d890adcd9@mail.gmail.com>
References: <eae6a62a0903072358o15b1cefdt661627cefc05b3b0@mail.gmail.com>
<49B56A7F.6040004@pinpointresearch.com>
<dcc563d10903100237i368e2244x41e9ea5d890adcd9@mail.gmail.com>
Scott Marlowe <scott.marlowe@gmail.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, scott.marlowe@gmail.com, scrawford@pinpointresearch.com, dm.aeqa@gmail.com
Subject: Re: Urgent PST time changing tonight
In-Reply-To: <26181.1236688291@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox