On Wed, Jun 26, 2019 at 6:32 PM Andrew Gierth
<andrew@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