Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 440129FB8E5
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 19 Jun 2007 04:43:04 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 96674-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 19 Jun 2007 04:42:57 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from py-out-1112.google.com (py-out-1112.google.com
 [64.233.166.180])
	by postgresql.org (Postfix) with ESMTP id 02DA59FB7E5
	for <pgsql-performance@postgresql.org>;
	Tue, 19 Jun 2007 04:42:59 -0300 (ADT)
Received: by py-out-1112.google.com with SMTP id p76so745251pyb
	for <pgsql-performance@postgresql.org>;
	Tue, 19 Jun 2007 00:42:58 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	b=DZlBIwLut/oOOjejsea7YaCsr+kCWgpNoUbB/xNi0/Xmt8CNrSGZlqPsi+++mg/Ht51xxH25ORp1Ua2oWN6TEjyZs+d+9kcpJLtbc4yeRnWNw70g12HFrBbu5rM5E/Ty8iUbSz/hn53WmEodImUn350H0S0JZQvlyRamfRDi7sM=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=opm1FW48MJ0dGiYiIy4gVFz8hct8ykjwX9/ahvivd7U1DX5W0+ydn19KnmWeT1pzkzGlmYs/O20H+O5BuzD+pkxm+oqIqgSvYesAfJzrh9dBO1sz1wBe+gh8djljbSm0S1juV5TIFNWhw7bNvi49jxxHArBEvDDjco7x6rNu3+g=
Received: by 10.65.214.19 with SMTP id r19mr10874976qbq.1182238978661;
	Tue, 19 Jun 2007 00:42:58 -0700 (PDT)
Received: by 10.65.211.6 with HTTP; Tue, 19 Jun 2007 00:42:58 -0700 (PDT)
Message-ID: <9f2e40a90706190042x6016b395od1eca739d5205ebd@mail.gmail.com>
Date: Tue, 19 Jun 2007 13:12:58 +0530
From: "soni de" <soni.de@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Regarding Timezone
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_73362_23216674.1182238978634"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50=0.001,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200706/324
X-Sequence-Number: 25357

------=_Part_73362_23216674.1182238978634
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello,

We have installed postgres 8.2.0

default time zone which postgres server using is

template1=# SHOW timezone;
 TimeZone
-----------
 ETC/GMT-5
(1 row)


But we want to set this timezone parameter to IST.
Our system timezone is also in IST. We are using solaris.

Please provide me some help regarding this.



Thanks,

Soni

------=_Part_73362_23216674.1182238978634
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hello,</div>
<div>&nbsp;</div>
<div>We have installed postgres 8.2.0</div>
<div>&nbsp;</div>
<div>default time zone which postgres server using is </div>
<div>&nbsp;</div>
<div>template1=# SHOW timezone;<br>&nbsp;TimeZone<br>-----------<br>&nbsp;ETC/GMT-5<br>(1 row)<br>&nbsp;</div>
<div>&nbsp;</div>
<div>But we want to set this timezone parameter to IST.</div>
<div>Our system timezone is also in IST. We are using solaris.</div>
<div>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Please provide me some help regarding this.</span></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font>&nbsp;</p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks,</span></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Soni</span></font></p></div>

------=_Part_73362_23216674.1182238978634--