Re: Weird new time zone - Mailing list pgsql-hackers

> You tell us ... what's your real timezone, and what do you get from
> pushing up the log level to DEBUG4 during postmaster start?

OK, I have log level set to debug4 and australian_timezones set to true.
   The system time zone is set to WST.

Attached is the startup log.  I should point out that the Casey
Antarctic base is in the Australian Antarctic Territory and it is in the
same time zone as Perth, Western Australia for me:

http://times.clari.net.au/location.php3/Antarctica/Casey
http://times.clari.net.au/location.php3/Australia/Perth

So I guess in many ways, PostgreSQL is correct - just...weird...

I should also point out that with australian_timezones set to false, it
still picks Casey Station in Antarctica.

Chris



postmaster starting
DEBUG:  Reject TZ "Africa/Algiers": at 1089417600 2004-07-10 01:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Luanda": at 1089417600 2004-07-10 01:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Porto-Novo": at 1089417600 2004-07-10 01:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Gaborone": at 1089417600 2004-07-10 02:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Ouagadougou": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Bujumbura": at 1089417600 2004-07-10 02:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Douala": at 1089417600 2004-07-10 01:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Bangui": at 1089417600 2004-07-10 01:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Ndjamena": at 1089417600 2004-07-10 01:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Kinshasa": at 1089417600 2004-07-10 01:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Lubumbashi": at 1089417600 2004-07-10 02:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Brazzaville": at 1089417600 2004-07-10 01:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Abidjan": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Djibouti": at 1089417600 2004-07-10 03:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Cairo": at 1089417600 2004-07-10 03:00:00 dst versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Malabo": at 1089417600 2004-07-10 01:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Asmera": at 1089417600 2004-07-10 03:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Addis_Ababa": at 1089417600 2004-07-10 03:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Libreville": at 1089417600 2004-07-10 01:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Banjul": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Accra": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Conakry": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Bissau": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Nairobi": at 1089417600 2004-07-10 03:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Maseru": at 1089417600 2004-07-10 02:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Monrovia": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Tripoli": at 1089417600 2004-07-10 02:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Blantyre": at 1089417600 2004-07-10 02:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Bamako": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Timbuktu": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Nouakchott": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Casablanca": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/El_Aaiun": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Maputo": at 1089417600 2004-07-10 02:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Windhoek": at 1089417600 2004-07-10 01:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Niamey": at 1089417600 2004-07-10 01:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Lagos": at 1089417600 2004-07-10 01:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Kigali": at 1089417600 2004-07-10 02:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Sao_Tome": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Dakar": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Freetown": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Mogadishu": at 1089417600 2004-07-10 03:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Johannesburg": at 1089417600 2004-07-10 02:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Khartoum": at 1089417600 2004-07-10 03:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Mbabane": at 1089417600 2004-07-10 02:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Dar_es_Salaam": at 1089417600 2004-07-10 03:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Lome": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Tunis": at 1089417600 2004-07-10 01:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Kampala": at 1089417600 2004-07-10 03:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Lusaka": at 1089417600 2004-07-10 02:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Harare": at 1089417600 2004-07-10 02:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Africa/Ceuta": at 1089417600 2004-07-10 02:00:00 dst versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Atlantic/Cape_Verde": at 1089417600 2004-07-09 23:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Atlantic/St_Helena": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Atlantic/Faeroe": at 1089417600 2004-07-10 01:00:00 dst versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Atlantic/Reykjavik": at 1089417600 2004-07-10 00:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Atlantic/Azores": at 1089417600 2004-07-10 00:00:00 dst versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Atlantic/Madeira": at 1089417600 2004-07-10 01:00:00 dst versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Atlantic/Canary": at 1089417600 2004-07-10 01:00:00 dst versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Atlantic/Bermuda": at 1089417600 2004-07-09 21:00:00 dst versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Atlantic/Stanley": at 1089417600 2004-07-09 20:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Atlantic/South_Georgia": at 1089417600 2004-07-09 22:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Atlantic/Jan_Mayen": at 1089417600 2004-07-10 02:00:00 dst versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Indian/Comoro": at 1089417600 2004-07-10 03:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Indian/Antananarivo": at 1089417600 2004-07-10 03:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Indian/Mauritius": at 1089417600 2004-07-10 04:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Indian/Mayotte": at 1089417600 2004-07-10 03:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Indian/Reunion": at 1089417600 2004-07-10 04:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Indian/Mahe": at 1089417600 2004-07-10 04:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Indian/Kerguelen": at 1089417600 2004-07-10 05:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Indian/Chagos": at 1089417600 2004-07-10 06:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Indian/Maldives": at 1089417600 2004-07-10 05:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Indian/Christmas": at 1089417600 2004-07-10 07:00:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Reject TZ "Indian/Cocos": at 1089417600 2004-07-10 06:30:00 std versus 2004-07-10 08:00:00 std
DEBUG:  Accept TZ "Antarctica/Casey"
DEBUG:  postmaster: PostmasterMain: initial environ dump:
DEBUG:  -----------------------------------------
DEBUG:          USER=chriskl
DEBUG:          SSH_CLIENT=192.168.0.1 2818 22
DEBUG:          MAIL=/var/mail/chriskl
DEBUG:          SHLVL=1
DEBUG:          HOME=/home/chriskl
DEBUG:          OLDPWD=/home/chriskl/pgsql
DEBUG:          SSH_TTY=/dev/ttyp0
DEBUG:          LOGNAME=chriskl
DEBUG:          _=/home/chriskl/local/bin/pg_ctl
DEBUG:          BLOCKSIZE=K
DEBUG:          TERM=xterm
DEBUG:          PGSYSCONFDIR=/home/chriskl/local/etc/postgresql
DEBUG:
PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/sbin:/usr/local/bin:/usr/X11R6/bin:/home/chriskl/bin:/home/chriskl/local/bin
DEBUG:          SHELL=/usr/local/bin/bash
DEBUG:          PWD=/home/chriskl/pgsql-server
DEBUG:          SSH_CONNECTION=192.168.0.1 2818 192.168.0.8 22
DEBUG:          PGDATA=/home/chriskl/local/data
DEBUG:          FTP_PASSIVE_MODE=YES
DEBUG:  -----------------------------------------
DEBUG:  invoking IpcMemoryCreate(size=9691136)
DEBUG:  max_safe_fds = 984, usable_fds = 3169, already_open = 6
LOG:  database system was shut down at 2004-07-10 16:07:37 WST
LOG:  checkpoint record is at 0/A37F6C
LOG:  redo record is at 0/A37F6C; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 496; next OID: 17228
LOG:  database system is ready
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
DEBUG:  reaping dead processes