From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Anrik Drenth <drentha(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Postgres 12 - enable en_NZ.UTF-8 |
Date: | 2020-07-14 06:02:35 |
Message-ID: | 2796448.1594706555@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Anrik Drenth <drentha(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Rychlewski (LCL) | 2020-07-15 00:57:55 | "Create index" lock type |
Previous Message | Anrik Drenth | 2020-07-14 02:56:02 | Postgres 12 - enable en_NZ.UTF-8 |