Christopher Kings-Lynne writes: > Any reason why postgres can't detect time zone on my machine > automatically? > > LOG: could not recognize system timezone, defaulting to "Etc/GMT-8" > HINT: You can specify the correct timezone in postgresql.conf. > postmaster starting > -bash-2.05b$ LOG: database system was shut down at > 2004-05-31 15:19:00 > GMT-8 > LOG: checkpoint record is at 0/A47C80 > LOG: redo record is at 0/A47C80; undo record is at 0/0; shutdown TRUE > LOG: next transaction ID: 536; next OID: 17218 > LOG: database system is ready > > > -bash-2.05b$ date > Mon May 31 15:21:10 WST 2004
I'm guessing the TZ code isn't identifying Aussie timezones. I'm getting the same message, albeit Etc/GMT-10. If anyone who hacked on the TZ code (Magnus, Bruce, ...) wants me to add a few printfs to trace this down, pleae get in touch with me. Cheers, Claudio --- Certain disclaimers and policies apply to all email sent from Memetrics. For the full text of these disclaimers and policies see <a href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em ailpolicy.html</a> ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster