Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 495B813364DE for ; Mon, 2 May 2011 10:36:50 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 68375-02-2 for ; Mon, 2 May 2011 13:36:33 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-qy0-f174.google.com (mail-qy0-f174.google.com [209.85.216.174]) by mail.postgresql.org (Postfix) with ESMTP id B83041337A5D for ; Mon, 2 May 2011 10:36:32 -0300 (ADT) Received: by qyk7 with SMTP id 7so1320842qyk.19 for ; Mon, 02 May 2011 06:36:32 -0700 (PDT) Received: by 10.229.101.168 with SMTP id c40mr6239405qco.98.1304343392701; Mon, 02 May 2011 06:36:32 -0700 (PDT) Received: from AnibalVAIO (host-2-219.a2.cvc.com.py [186.0.189.219]) by mx.google.com with ESMTPS id s9sm3965612qco.36.2011.05.02.06.36.29 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 02 May 2011 06:36:31 -0700 (PDT) From: "Anibal David Acosta" To: References: In-Reply-To: Subject: Postgres TimeZone Date: Mon, 2 May 2011 09:36:28 -0400 Message-ID: <002301cc08cd$f2efa010$d8cee030$@devshock.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Outlook 14.0 Thread-Index: AcwG7DNuaXhYc4rAQNCMy1gNJM0RLAB4bXsg Content-Language: es-py X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_20=-0.001 X-Spam-Level: X-Archive-Number: 201105/7 X-Sequence-Number: 37444 Hello, I have a postgres installed on a Windows server machine. In my country we have daylight saving so my windows OS is configured to automatically change timezone but the postgres only reload the new timezone after restart. Is possible to kept the Postgres in sync with the windows time (time and timezone)? If not, can I reload the new timezone without restaring the postgres service? Thanks!. Anibal