Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 2F4D92E002C for ; Mon, 31 Mar 2008 09:04:21 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 59222-05 for ; Mon, 31 Mar 2008 09:04:13 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from blu139-omc1-s22.blu139.hotmail.com (blu139-omc1-s22.blu139.hotmail.com [65.55.175.162]) by developer.postgresql.org (Postfix) with ESMTP id 154FA2E0032 for ; Mon, 31 Mar 2008 09:04:19 -0300 (ADT) Received: from BLU110-W46 ([65.55.162.183]) by blu139-omc1-s22.blu139.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Mon, 31 Mar 2008 05:04:16 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_54a9edf4-4def-49a2-b1ed-572c0b45b77c_" X-Originating-IP: [59.160.193.34] From: Vishal Arora To: Julius Tuskenis CC: Subject: Re: what is the origin of postgreSQL time Date: Mon, 31 Mar 2008 17:34:16 +0530 Importance: Normal In-Reply-To: <47F0BA81.6080405@nsoft.lt> References: <47F0A958.2040608@nsoft.lt> <47F0ACCC.7070403@proventis.net> <47F0BA81.6080405@nsoft.lt> MIME-Version: 1.0 X-OriginalArrivalTime: 31 Mar 2008 12:04:16.0677 (UTC) FILETIME=[57D6ED50:01C89327] X-Archive-Number: 200803/272 X-Sequence-Number: 28755 --_54a9edf4-4def-49a2-b1ed-572c0b45b77c_ Content-Type: text/plain; charset="iso-8859-4" Content-Transfer-Encoding: 8bit Have you checked timezone parameter in postgresql.conf file? - Vishal > Date: Mon, 31 Mar 2008 13:18:41 +0300> From: julius@nsoft.lt> CC: pgsql-admin@postgresql.org> Subject: Re: [ADMIN] what is the origin of postgreSQL time> > If I use select current_timestamp AT TIME ZONE 'EEST' I get good time > (EEST - I'm in Lithuania). But how do I make postgreSQL use system time > by default? The thing is we have 8 servers working and none of them is > affected by this issue. Only one refuses to switch to summer time.> > Julius Tuskenis> > Thomas Markus rašė:> > beware of timezone dst offset. try> > select current_timestamp AT TIME ZONE 'MEST'> >> > thomas> >> > Julius Tuskenis schrieb:> >> Hello,> >>> >> 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> >> OS: Gentoo Linux> >>> >> > ------------------------------------------------------------------------> >> >> > > > > -- > Julius Tuskenis> Programuotojas> UAB nSoft> mob. +37068233050> > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)> To make changes to your subscription:> http://www.postgresql.org/mailpref/pgsql-admin _________________________________________________________________ Education: Are exams worrying you all the day long? Write to MSN education experts for help. http://education.in.msn.com/ --_54a9edf4-4def-49a2-b1ed-572c0b45b77c_ Content-Type: text/html; charset="iso-8859-4" Content-Transfer-Encoding: 8bit  
Have you checked timezone parameter in postgresql.conf file?
 
- Vishal






> Date: Mon, 31 Mar 2008 13:18:41 +0300
> From: julius@nsoft.lt
> CC: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] what is the origin of postgreSQL time
>
> If I use select current_timestamp AT TIME ZONE 'EEST' I get good time
> (EEST - I'm in Lithuania). But how do I make postgreSQL use system time
> by default? The thing is we have 8 servers working and none of them is
> affected by this issue. Only one refuses to switch to summer time.
>
> Julius Tuskenis
>
> Thomas Markus rašė:
> > beware of timezone dst offset. try
> > select current_timestamp AT TIME ZONE 'MEST'
> >
> > thomas
> >
> > Julius Tuskenis schrieb:
> >> Hello,
> >>
> >> 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
> >> OS: Gentoo Linux
> >>
> >
> > ------------------------------------------------------------------------
> >
> >
> >
>
>
> --
> Julius Tuskenis
> Programuotojas
> UAB nSoft
> mob. +37068233050
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin



Windows Live Messenger : Get connected, share yourself, make a difference the way you chat. Check it out! --_54a9edf4-4def-49a2-b1ed-572c0b45b77c_--