public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Anrik Drenth <[email protected]>
Cc: [email protected]
Subject: Re: Postgres 12 - enable en_NZ.UTF-8
Date: Tue, 14 Jul 2020 02:02:35 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAEdS=wpBnTzRn7VpXOTmGki-qmQG+c8M4BCF97G1SWpqANoi6A@mail.gmail.com>
References: <CAEdS=wpBnTzRn7VpXOTmGki-qmQG+c8M4BCF97G1SWpqANoi6A@mail.gmail.com>

Anrik Drenth <[email protected]> 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

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Postgres 12 - enable en_NZ.UTF-8
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox