Re: log timestamp since daylight saving time

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.marlowe@gmail.com>  wrote:
>> On Tue, Mar 15, 2011 at 12:12 PM, Maria L. Wilson
>> <Maria.L.Wilson-1@nasa.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?