Tom Lane wrote: > Pam Wampler <[EMAIL PROTECTED]> writes: > > Where do I & how do I permanently set the time zone? > > I think best/only way right now is to set the TZ environment variable > before starting the postmaster. The TimeZone variable ought to be > settable from postgresql.conf, but for some reason it's not there now. > > BTW, if the system default timezone is not already the way you want it, > you might consider making it so rather than putting a special hack into > the Postgres start script. This usually involves creating or changing > a configuration file somewhere under /etc ...
Actually, I think there are three levels: system timezone, TZ, and PGTZ environment variables. The first is all processes, the second is all processes that have TZ set, and PGTZ affects only PostgreSQL and not other applications. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
