Skip site navigation (1) Skip section navigation (2)

Re: what is the origin of postgreSQL time

From: Julius Tuskenis <julius(at)nsoft(dot)lt>
To:
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: what is the origin of postgreSQL time
Date: 2008-03-31 12:09:22
Message-ID: 47F0D472.8070006@nsoft.lt (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)nsoft(dot)lt
> > CC: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)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


In response to

Responses

pgsql-admin by date

Next:From: Tommy GildsethDate: 2008-03-31 12:17:31
Subject: Re: what is the origin of postgreSQL time
Previous:From: Vladimir RusinovDate: 2008-03-31 12:06:26
Subject: log_min_duration_statement log parsing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group