Alvaro Herrera <[EMAIL PROTECTED]> 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.
[EMAIL PROTECTED]:~$ ls -l /etc/localtime lrwxrwxrwx 1 root root 36 Feb 2 17:08 /etc/localtime -> /usr/share/zoneinfo/Pacific/Auckland
[EMAIL PROTECTED]:~$ date
Tue May 25 15:14:53 NZST 2004
[EMAIL PROTECTED]:~$ 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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]