Yes... Thank you. It worked for me.
But I still don't know why it happened and how to avoid it happening again.
:(
Any body has any idea?
>From: "Alxander A. Kapralov" <sasha@province.ru>
>To: omid omoomi <oomoomi@hotmail.com>
>Subject: Re: [GENERAL] Time zone problem
>Date: Wed, 10 Jul 2002 13:57:01 +0400
>
>omid omoomi �����:
>
>>
>>Hi all,
>>Currently, my system is working under:
>>PostgreSQL 7.1.3 on i386-unknown-freebsd4.4, compiled by GCC 2.95.3
>>
>>Since both the OS and PG showed me the same local time, every thing was
>>working fine until a few days ago(dont know exactly when and why!)
>>when the PG time zone seems to be some how missed(better say set to UTC),
>>and I think it is the real cause. May be it is because of any lately
>>automatic summer/winter time conversions by the system & ...
>>
>>At the moment, this is what I get from the OS and PG in a same time:
>>
>>omid=# \! date
>>Wed Jul 10 13:16:15 IRST 2002
>>
>>omid=# select now();
>> now
>>------------------------
>>2002-07-10 08:46:15+00
>
>try to restart postgres it mast be help ....
>
>>
>>I want to have both the OS and the PG with the same time zone of Iran
>>time. Any idea about why it has happen like this?
>>
>>TIA
>>Omid Omoomi
>>
>>PS) I don't think the "SET time zone" command could help me because I want
>>the time zone to be permanent for all the connections.
>>
>>
>>_________________________________________________________________
>>MSN Photos is the easiest way to share and print your photos:
>>http://photos.msn.com/support/worldwide.aspx
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 2: you can get off all lists at once with the unregister command
>> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com