seting the time zone in the server

From: miguel angel rojas aquino <mrojas_aquino(at)mail(dot)flashmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: seting the time zone in the server
Date: 2002-10-16 19:48:43
Message-ID: 3DADC29B.50505@mail.flashmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi, everybody

i've reading the pg users manual and in datatype-datetime.html it says
that the TZ environmet variable sets the time zone for the postmaster
backend at startup, and i'm trying to do this exactly to avoid some date
problems in my application.

i've set this variable in the .bash_profile of the postgres user and in
the /etc/rc.d/init.d/pstgresql script, but when inserting or querying
the data, i appears with a different timezone based on the date

so, can anyboby please give me some pointers about how to set this
variable in the ritght form, it would be greatly appreciated :)

i'm using pg 7.2.2-1PGDG on a redhat 7.1 system

Browse pgsql-general by date

  From Date Subject
Next Message James Hall 2002-10-16 19:50:56 Pg_dumpall problem
Previous Message Tralhao, Marcelo de Almeida 2002-10-16 18:41:31 Oracle's Wrapper in PostgreSQL