aboutsummaryrefslogtreecommitdiff
path: root/src/backend/utils/misc/postgresql.conf.sample
diff options
context:
space:
mode:
authorJeff Davis <jdavis@postgresql.org>2023-03-28 16:15:59 -0700
committerJeff Davis <jdavis@postgresql.org>2023-03-28 16:34:29 -0700
commit1671f990dd669c0b72e45c7bef0fd579a10676ed (patch)
tree002e9ca8c4cd35b2f641de6c308f78b701f3b21a /src/backend/utils/misc/postgresql.conf.sample
parentb7cea58822c67724effc711ae28e4077a01a7cd6 (diff)
downloadpostgresql-1671f990dd669c0b72e45c7bef0fd579a10676ed.tar.gz
postgresql-1671f990dd669c0b72e45c7bef0fd579a10676ed.zip
Validate ICU locales.
For ICU collations, ensure that the locale's language exists in ICU, and that the locale can be opened. Basic validation helps avoid minor mistakes and misspellings, which often fall back to the root locale instead of the intended locale. It's even more important to avoid such mistakes in ICU versions 54 and earlier, where the same (misspelled) locale string could fall back to different locales depending on the environment. Discussion: https://postgr.es/m/11b1eeb7e7667fdd4178497aeb796c48d26e69b9.camel@j-davis.com Discussion: https://postgr.es/m/df2efad0cae7c65180df8e5ebb709e5eb4f2a82b.camel@j-davis.com Reviewed-by: Peter Eisentraut
Diffstat (limited to 'src/backend/utils/misc/postgresql.conf.sample')
-rw-r--r--src/backend/utils/misc/postgresql.conf.sample3
1 files changed, 3 insertions, 0 deletions
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample
index fc831565d90..ee49ca39370 100644
--- a/src/backend/utils/misc/postgresql.conf.sample
+++ b/src/backend/utils/misc/postgresql.conf.sample
@@ -731,6 +731,9 @@
#lc_numeric = 'C' # locale for number formatting
#lc_time = 'C' # locale for time formatting
+#icu_validation_level = ERROR # report ICU locale validation
+ # errors at the given level
+
# default configuration for text search
#default_text_search_config = 'pg_catalog.simple'