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.klaver@aklaver.com