Postgres 12 - enable en_NZ.UTF-8

From: Anrik Drenth <drentha(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Postgres 12 - enable en_NZ.UTF-8
Date: 2020-07-14 02:56:02
Message-ID: CAEdS=wpBnTzRn7VpXOTmGki-qmQG+c8M4BCF97G1SWpqANoi6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All,

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".

Looking at pg_collation 'en_NZ.UTF-8' does not exist.

Thanks

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2020-07-14 06:02:35 Re: Postgres 12 - enable en_NZ.UTF-8
Previous Message Anto Aravinth 2020-07-13 03:53:54 Ranking the query with right order in full text search