timezone in postgresql.conf was set to MST. Setting it to MDT gave this error: LOG: unrecognized time zone name: "MDT" FATAL: invalid value for parameter "timezone": "MDT" http://www.postgresql.org/docs/7.4/interactive/datetime-keywords.html#DATETIME-TIMEZONE-TABLE (MDT is listed there) Anyhow, I commented out "timezone" and the time is correct now. --- CSN <cool_screen_name90001@yahoo.com> wrote: > How do I update pg's date? It doesn't appear to have > been updated with DST. I was under the impression > that > changing the system's date/time (date -s "...") > would > cause pg to use that. > > > [root@domain data]# date > Sun Apr 11 00:39:07 MDT 2004 > [root@domain data]# > [root@domain data]# psql -U admin database1 > Welcome to psql 7.4.1, the PostgreSQL interactive > terminal. > > database1=> select now(); > now > ------------------------------- > 2004-04-10 23:39:14.048634-07 > (1 row) > > database1=> select current_time; > timetz > -------------------- > 23:39:46.202589-07 > (1 row) > > database1=> select current_date; > date > ------------ > 2004-04-10 > (1 row) > > database1=> select current_timestamp; > timestamptz > ------------------------------ > 2004-04-10 23:40:10.53221-07 > (1 row) > > database1=> > > > __________________________________ > Do you Yahoo!? > Yahoo! Tax Center - File online by April 15th > http://taxes.yahoo.com/filing.html > __________________________________ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
