Re: could not determine encoding for locale "et_EE.UTF-8": codeset is "CPUTF-8" in pg_restore

On 3/28/20 3:31 PM, Andrus wrote:
> Hi!
>
>> In the Debian Postgres instance in psql what does \l show for the
>> databases?
>
> #psql namm postgres
> psql (12.2 (Debian 12.2-2.pgdg100+1))
> Type "help" for help.
>
> namm=# \l namm
>                                  List of databases
> Name |   Owner    | Encoding |   Collate   |    Ctype    |     Access
> privileges
> ------+------------+----------+-------------+-------------+---------------------------
>
> namm | namm_owner | UTF8     | et_EE.UTF-8 | et_EE.UTF-8 | =Tc/namm_owner +
>      |            |          |             |             |
> namm_owner=CTc/namm_owner
> (1 row)
>
>> In the Windows 10 command prompt what does systeminfo show?
>

> System Locale:             et;Eesti
> Input Locale:              et;Eesti

Hmm, I was expecting to see et_EE though I will admit to not truly
understanding how Windows does locales.

I should have asked earlier, in the Postgres instance on Windows what
does \l show for template0?

>
> Andrus.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com