Re: [PERFORM] Regarding Timezone

2007-06-19 Thread Tom Lane
"soni de" <[EMAIL PROTECTED]> writes: > But we want to set this timezone parameter to IST. Which "IST" are you interested in? Irish, Israel, or Indian Standard Time? Postgres prefers to use the zic timezone names, which are less ambiguous. Try this to see likely options: regression=# select * f

Re: [PERFORM] Regarding Timezone

2007-06-19 Thread A. Kretschmer
am Tue, dem 19.06.2007, um 13:12:58 +0530 mailte soni de folgendes: > 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 pa

Re: [PERFORM] Regarding Timezone

2007-06-19 Thread Heikki Linnakangas
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

[PERFORM] Regarding Timezone

2007-06-19 Thread soni de
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