Re: Issues with inconsistent COLLATION installation

Here is encoding for existing database:
List of databases
┌───────────┬──────────┬──────────┬─────────────┬─────────────┬───────────────────────┐
│ Name │ Owner │ Encoding │ Collate │ Ctype │ Access
privileges │
├───────────┼──────────┼──────────┼─────────────┼─────────────┼───────────────────────┤
│ thedatabase │ postgres │ UTF8 │ en_US.UTF-8 │ en_US.UTF-8 │
│
│ postgres │ postgres │ UTF8 │ en_US.UTF-8 │ en_US.UTF-8 │
│
│ template0 │ postgres │ UTF8 │ en_US.UTF-8 │ en_US.UTF-8 │ =c/postgres
↵│
│ │ │ │ │ │
postgres=CTc/postgres │
│ template1 │ postgres │ UTF8 │ en_US.UTF-8 │ en_US.UTF-8 │
postgres=CTc/postgres↵│
│ │ │ │ │ │ =c/postgres
│
└───────────┴──────────┴──────────┴─────────────┴─────────────┴───────────────────────┘
--cnemelka

On Mon, Sep 9, 2019 at 12:45 PM Cory Nemelka <cnemelka(at)gmail(dot)com> wrote:

> We have already run pg_import_system_collations('pg_catalog')
> --cnemelka
>
>
> On Mon, Sep 9, 2019 at 12:43 PM Cory Nemelka <cnemelka(at)gmail(dot)com> wrote:
>
>> We are having issues with some databases getting our locales generated.
>> We are using Ubuntu 18.04 and postgresql 10.8.
>>
>> Example:
>>
>> *from bash prompt:*
>>
>> $ locale -a | egrep fr
>> fr_BE
>> fr_BE(at)euro
>> fr_BE.iso88591
>> fr_BE(dot)iso885915(at)euro
>> fr_BE.utf8
>> fr_CA
>> fr_CA.iso88591
>> fr_CA.utf8
>> fr_CH
>> fr_CH.iso88591
>> fr_CH.utf8
>> french
>> fr_FR
>> fr_FR(at)euro
>> fr_FR.iso88591
>> fr_FR(dot)iso885915(at)euro
>> fr_FR.utf8
>> fr_LU
>> fr_LU(at)euro
>> fr_LU.iso88591
>> fr_LU(dot)iso885915(at)euro
>> fr_LU.utf8
>>
>> *from psql prompt:*
>>
>> [local] cnemelka(at)postgres=# create collation french
>> (provider=libc,locale='fr_FR.utf8');
>> ERROR: 22023: 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".
>> LOCATION: report_newlocale_failure, pg_locale.c:1312
>>
>> *Anyone having similar issues or know of the solution?*
>>
>> *TIA,*
>> --cnemelka
>>
>