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



--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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
>



--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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

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/

Yes, it is undefined (#timezone = unknown) just like in other servers.

Julius

Vishal Arora rašė:
>
> 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!
> <http://get.live.com/messenger/overview%20>


--
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

How about database specific config settings?
SELECT datname, datconfig FROM pg_database;


--
Tommy Gildseth


Julius Tuskenis wrote:
> Yes, it is undefined (#timezone = unknown) just like in other servers.
>
> Julius
>
> Vishal Arora rašė:
>>
>> Have you checked timezone parameter in postgresql.conf file?

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin