On Wed, Jun 26, 2019 at 6:32 PM Andrew Gierth <and...@tao11.riddles.org.uk> wrote: > Pacific/Auckland -> NZ
Right. On a FreeBSD system here in New Zealand you get "NZ" with default configure options (ie using PostgreSQL's tzdata). But if you build with --with-system-tzdata=/usr/share/zoneinfo you get "Pacific/Auckland", and that's because the FreeBSD zoneinfo directory doesn't include the old non-city names like "NZ", "GB", "Japan", "US/Eastern" etc. (Unfortunately the FreeBSD packages for PostgreSQL are not being built with that option so initdb chooses the old names. Something to take up with the maintainers.) -- Thomas Munro https://enterprisedb.com