Re: Regarding Timezone

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: soni de <soni(dot)de(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Regarding Timezone
Date: 2007-06-19 07:51:27
Message-ID: 46778AFF.2080400@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

soni de wrote:
> But we want to set this timezone parameter to IST.
> Our system timezone is also in IST. We are using solaris.

This is the performance-list, and this is not a performance-related
question. Please use the pgsql-general or pgsql-novice list for this
kind of questions.

PostgreSQL should pick up the correct timezone from system
configuration. I don't know why that's not happening in your case, but
you can use the "timezone" parameter in postgresql.conf to set it
manually. See manual:
http://www.postgresql.org/docs/8.2/interactive/runtime-config-client.html#GUC-TIMEZONE

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message A. Kretschmer 2007-06-19 07:55:05 Re: Regarding Timezone
Previous Message soni de 2007-06-19 07:42:58 Regarding Timezone