From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Julius Tuskenis <julius(at)nsoft(dot)lt> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: what is the origin of postgreSQL time |
Date: | 2008-03-31 14:23:54 |
Message-ID: | 27356.1206973434@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Julius Tuskenis <julius(at)nsoft(dot)lt> writes:
> I have problem with postgreSQL current_timestramp. Where does it get its
> value, because it doesnt match system time. The problem appeared after
> this saturday-sunday night and is connected somehow with the daylight
> saving. Now "date" on the server returns good value, but the SELECT
> current_timestmap is 1 hour late.
> Postgresql 8.1.4
^^^^^
I haven't checked the timezone history, but 8.1.4 was quite a few
timezone updates ago. Would a DST switch have happened this weekend
under old law where you live? If so, you need to update to a more
modern set of timezone files. Look under (probably, I don't know
gentoo) /usr/share/postgresql/timezone/
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Julius Tuskenis | 2008-03-31 15:39:58 | Re: what is the origin of postgreSQL time |
Previous Message | Vladimir Rusinov | 2008-03-31 13:05:41 | Re: log_min_duration_statement log parsing |