Re: Timezone fun (bugs and a request)

Tom Lane wrote:
> Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> writes:
>
>>First I initdb'd without TZ set. So every time I start the server I get
>>LOG: could not recognize system timezone, defaulting to "Etc/GMT-4"
>>HINT: You can specify the correct timezone in postgresql.conf.
>
>
> I've fixed the minor issue here, which is that the sign is backwards ---
> it ought to select "Etc/GMT+4". The larger issue is that it's not
> recognizing your system timezone because the only name it can cons up
> for the zone is "CLT4CLST", which doesn't work because it has the wrong
> DST rules. (I think it's just luck that it realizes that, actually :-().

With a freshly updated CVS tree I get the wrong sign on the timezone here:

LOG: could not recognize system timezone, defaulting to "Etc/GMT-12"
HINT: You can specify the correct timezone in postgresql.conf.
LOG: database system was shut down at 2004-05-25 15:15:44 GMT-12

My timezone is NZST which is GMT+12. TZ is not set. This is a Debian box
with libc-2.3.2.

> oliver(at)flood:~$ ls -l /etc/localtime
> lrwxrwxrwx 1 root root 36 Feb 2 17:08 /etc/localtime -> /usr/share/zoneinfo/Pacific/Auckland
> oliver(at)flood:~$ date
> Tue May 25 15:14:53 NZST 2004
> oliver(at)flood:~$ date +'%c %z'
> Tue May 25 15:30:11 2004 +1200

Also, unless I'm missing something, shouldn't Chile (Alvaro's timezone?)
be behind GMT (GMT-something) not ahead of it (GMT+something)?

-O