Re: Timezone fun (bugs and a request)

Tom Lane wrote:
> Alvaro Herrera <alvherre@dcc.uchile.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@flood:~$ ls -l /etc/localtime 
> lrwxrwxrwx    1 root     root           36 Feb  2 17:08 /etc/localtime -> /usr/share/zoneinfo/Pacific/Auckland
> oliver@flood:~$ date
> Tue May 25 15:14:53 NZST 2004
> oliver@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