From: Tom Lane <tgl@sss.pgh.pa.us>
To: Anrik Drenth <drentha@gmail.com>
cc: pgsql-novice@postgresql.org
Subject: Re: Postgres 12 - enable en_NZ.UTF-8
In-reply-to: 
 <CAEdS=wpBnTzRn7VpXOTmGki-qmQG+c8M4BCF97G1SWpqANoi6A@mail.gmail.com>
References: 
 <CAEdS=wpBnTzRn7VpXOTmGki-qmQG+c8M4BCF97G1SWpqANoi6A@mail.gmail.com>
Comments: In-reply-to Anrik Drenth <drentha@gmail.com>
	message dated "Tue, 14 Jul 2020 14:56:02 +1200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2796447.1594706555.1@sss.pgh.pa.us>
Date: Tue, 14 Jul 2020 02:02:35 -0400
Message-ID: <2796448.1594706555@sss.pgh.pa.us>
Precedence: bulk

Anrik Drenth <drentha@gmail.com> writes:
> How do I enable "en_NZ.UTF-8", in Postgres 12, in the file
> /etc/postgresql/12/main/postgresql.conf
> Changing 'en_US.UTF-8' to 'en_NZ.UTF-8' for the following: lc_messages,
> lc_monetary, lc_numeric, lc_time.

> And restarting Postgres 12 - I get the error "invalid value for parameter
> "lc_time": "en_NZ.UTF-8".

That has nothing to do with what's in pg_collation.  It means that
you don't have this locale definition installed at the OS level.
Probably "locale -a | grep NZ" will not find it.  So you need to
install the relevant OS package.  You didn't say what platform
you're on, so I can't guess which package that is; but it's
something related to libc, not Postgres.

			regards, tom lane