From: | "Maria L(dot) Wilson" <Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | "Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS AND APPLICATIONS, INC]" <m(dot)l(dot)wilson(at)nasa(dot)gov>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: log timestamp since daylight saving time |
Date: | 2011-03-15 18:45:07 |
Message-ID: | 4D7FB3B3.7010805@nasa.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
it also looks like the view pg_timezone_names is empty in the problem
installation. What loads this view?
psql (8.4.5)
Type "help" for help.
postgres=# select * from pg_timezone_names;
name | abbrev | utc_offset | is_dst
------+--------+------------+--------
(0 rows)
postgres=#
On 3/15/11 2:18 PM, Scott Marlowe wrote:
> On Tue, Mar 15, 2011 at 12:17 PM, Scott Marlowe<scott(dot)marlowe(at)gmail(dot)com> wrote:
>> On Tue, Mar 15, 2011 at 12:12 PM, Maria L. Wilson
>> <Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov> wrote:
>>> when you say updating postgres - do you mean the server software? How do
>>> you update the tz data?
>> Yes updating the pg software. The OS has tzdata as well, and you can
>> update that. But postgresql includes its own tzdata so I'm guessing
>> that updating pg would fix it.
>>
>>> I'm just a little concerned why only 2 of our machines (they are all
>>> supposed to be the same) are having this problem.
>> Are they all running the same pg version?
> Also are all the machines set to the same time zone?
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-03-15 19:50:34 | Re: log timestamp since daylight saving time |
Previous Message | Maria L. Wilson | 2011-03-15 18:21:59 | Re: log timestamp since daylight saving time |