Oliver Jowett <[EMAIL PROTECTED]> writes:
Also, unless I'm missing something, shouldn't Chile (Alvaro's timezone?) be behind GMT (GMT-something) not ahead of it (GMT+something)?
Part of the confusion here is that the zone names in the zic database follow POSIX rules: plus is west of Greenwich. AFAICS it's doing the right thing in selecting Etc/GMT-12 for you.
Ew! That's disgusting! What possessed POSIX to do this the opposite way to pretty much everything else?
Have you checked the actual time values reported by the server to see if they look okay?
Indeed, the timezone is actually correct:
oliver=# select now();
now
-------------------------------
2004-05-25 16:08:05.688408+12
(1 row)What confused me is that the times in the log don't follow the SQL-and-everything-else convention:
LOG: database system was shut down at 2004-05-25 15:15:44 GMT-12
For comparison, 7.4.1 on the same system says:
LOG: database system was shut down at 2004-05-25 16:03:43 NZST
and apache says:
127.0.0.1 - - [25/May/2004:16:06:16 +1200] "GET / HTTP/1.0" 200 4110 "-" "Wget/1.9.1"
I'm a bit hesitant to reverse the sign convention in the zic database to agree with SQL conventions --- that seems certain to lead to even more confusion.
Can we keep the zic database convention unchanged but change the display format in the logs to be consistent with the SQL conventions?
-O
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
