fr_FR.UTF-8 not available

[mesobreira]

Hi,

We are using the crunchy-postgres images: centos8-12.6-4.6.2 and we would like to use an fr_FR.UTF8 collation.
However, it seems that this locale is not installed in the image:

CREATE COLLATION french (locale = 'fr_FR.utf8');
ERROR: could not create locale "fr_FR.utf8": No such file or directory
DETAIL: The operating system could not find any locale data for the locale name "fr_FR.utf8".

Am I doing something wrong or do I have to personalize your official images with locale fr?

• Operating System: Centos 8.3
• Container Image Tag: centos8-12.6-4.6.2
• PostgreSQL Version: 12.6

Thanks,

Manuel S.

[bilemedimkq]

same issue.

[vtamara]

Similar issue in github actions. I'm needing support in PostgreSQL for es_CO.UTF-8. I tried several things, please see:
https://github.com/pasosdeJesus/sip/runs/2973909026?check_suite_focus=true

I the meantime I was able to configure CI in gitlab, mirroing from github and I could configure it with locale support (I had to deploy my own docker image with postgresql+postgis+locale-es but finally it works).

https://gitlab.com/pasosdeJesus/sip-ic/-/pipelines