Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 3C9C62E002E for ; Mon, 31 Mar 2008 09:17:33 -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 61816-09 for ; Mon, 31 Mar 2008 09:17:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pat.uio.no (pat.uio.no [129.240.10.15]) by developer.postgresql.org (Postfix) with ESMTP id B1A092E002C for ; Mon, 31 Mar 2008 09:17:32 -0300 (ADT) Received: from mail-mx3.uio.no ([129.240.10.44]) by pat.uio.no with esmtp (Exim 4.67) (envelope-from ) id 1JgIx9-00059R-FY; Mon, 31 Mar 2008 14:17:31 +0200 Received: from inhaca.uio.no ([129.240.202.141]) by mail-mx3.uio.no with esmtp (Exim 4.67) (envelope-from ) id 1JgIx9-0004Kb-Ak; Mon, 31 Mar 2008 14:17:31 +0200 Message-ID: <47F0D65B.7090908@usit.uio.no> Date: Mon, 31 Mar 2008 14:17:31 +0200 From: Tommy Gildseth User-Agent: Thunderbird 2.0.0.12 (X11/20080213) MIME-Version: 1.0 To: Julius Tuskenis CC: pgsql-admin@postgresql.org Subject: Re: what is the origin of postgreSQL time References: <47F0A958.2040608@nsoft.lt> <47F0ACCC.7070403@proventis.net> <47F0BA81.6080405@nsoft.lt> <47F0D472.8070006@nsoft.lt> In-Reply-To: <47F0D472.8070006@nsoft.lt> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-UiO-Spam-info: not spam, SpamAssassin (score=-5.0, required=5.0, autolearn=disabled, UIO_MAIL_IS_INTERNAL=-5) X-UiO-Scanned: 02476D3B0D649DF6DC97B31168BF0002DDA381F9 X-UiO-SR-test: 995AA6AD68F463B405C430BA28D479FAB491AF41 X-UiO-SPAM-Test: remote_host: 129.240.202.141 spam_score: -49 maxlevel 200 minaction 2 bait 0 mail/h: 1 total 657 max/h 38 blacklist 0 greylist 0 ratelimit 0 X-Archive-Number: 200803/275 X-Sequence-Number: 28758 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?