Josh Berkus writes:
> echo $TZ returns nothing. We've checked several Ubuntu systems, and it
> seems that Ubuntu does not set $TZ.
You can tweak that easily by editing /etc/postgresql/8.4/main/environment.
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation
Josh Berkus writes:
>> It's not all that separate: per the Olsen database,
>>
>> Link America/Denver US/Mountain
>> Link America/Denver Navajo
> What's more my concern is that Ubuntu, Debian and Red Hat do not set
> $TZ, so we'll get this kind of behavior on most Linux systems
"Kevin Grittner" writes:
> Tom Lane wrote:
>> It's not all that separate: per the Olsen database,
>>
>> Link America/Denver US/Mountain
>> Link America/Denver Navajo
> Yeah, it gets complicated, since the State of Arizona ignores
> Daylight Saving Time adjustments. On the ot
> It's not all that separate: per the Olsen database,
>
> Link America/Denver US/Mountain
> Link America/Denver Navajo
>
> Those are all aliases for the exact same timezone behavior, and PG
> doesn't have any good way to choose which one you think is preferred.
> It looks lik
Tom Lane wrote:
> Josh Berkus writes:
>> There is actually a time zone "Navajo", which is a *separate*
>> time zone from US/Mountain. Ideas on how this happened?
>
> It's not all that separate: per the Olsen database,
>
> Link America/Denver US/Mountain
> Link America/Denver
On Thu, Mar 3, 2011 at 5:10 PM, Tom Lane wrote:
> Josh Berkus writes:
>> echo $TZ returns nothing. We've checked several Ubuntu systems, and it
>> seems that Ubuntu does not set $TZ.
>
> Red Hat doesn't either; I think this is a general habit on Linux
> distros.
If you are using glibc, this is
Josh Berkus writes:
> echo $TZ returns nothing. We've checked several Ubuntu systems, and it
> seems that Ubuntu does not set $TZ.
Red Hat doesn't either; I think this is a general habit on Linux
distros.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bug
On 3/3/11 2:31 PM, Josh Berkus wrote:
> uname -a
> Linux hemingway 2.6.32-25-server #44-Ubuntu SMP Fri Sep 17 21:13:39 UTC
> 2010 x86_64 GNU/Linux
>
> date
> Thu Mar 3 15:30:17 MST 2011
Also:
echo $TZ returns nothing. We've checked several Ubuntu systems, and it
seems that Ubuntu does not set
Josh Berkus writes:
> ls -l localtime
> lrwxrwxrwx 1 root root 31 2010-10-18 08:20 localtime ->
> /usr/share/zoneinfo/US/Mountain
> postgres=# select * from pg_settings where name = 'TimeZone';
> setting| Navajo
> There is actually a time zone "Navajo", which is a *separate* time zone
> from
uname -a
Linux hemingway 2.6.32-25-server #44-Ubuntu SMP Fri Sep 17 21:13:39 UTC
2010 x86_64 GNU/Linux
date
Thu Mar 3 15:30:17 MST 2011
ls -l localtime
lrwxrwxrwx 1 root root 31 2010-10-18 08:20 localtime ->
/usr/share/zoneinfo/US/Mountain
postgres=# select * from pg_settings where name = 'Tim
10 matches
Mail list logo
