Postgres Pro
Downloads
Home   >   mailing lists

Postgres 12 - enable en_NZ.UTF-8 - Mailing list pgsql-novice

From Anrik Drenth
Subject Postgres 12 - enable en_NZ.UTF-8
Date
Msg-id CAEdS=wpBnTzRn7VpXOTmGki-qmQG+c8M4BCF97G1SWpqANoi6A@mail.gmail.com
Whole thread Raw
Responses Re: Postgres 12 - enable en_NZ.UTF-8  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Anto Aravinth
Date:
Subject: Ranking the query with right order in full text search
Next
From: Tom Lane
Date:
Subject: Re: Postgres 12 - enable en_NZ.UTF-8