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

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>
Subject: Re: could not determine encoding for locale "et_EE.UTF-8": codeset is "CPUTF-8" in pg_restore
Date: 2020-03-29 07:56:24
Message-ID: 9FADB15B59E64B1AACA7518F9EA217D6@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

>> 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?

"D:\Program Files\PostgreSQL\12\bin\psql" postgres postgres

psql (12.2)
WARNING: Console code page (775) differs from Windows code page (1257)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
Type "help" for help.

postgres=# \l template0
List of databases
Name | Owner | Encoding | Collate | Ctype
| Access privileges
-----------+----------+----------+-----------------------+-----------------------+-----------------------
template0 | postgres | UTF8 | Estonian_Estonia.1257 |
Estonian_Estonia.1257 | =c/postgres +
| | | |
| postgres=CTc/postgres
(1 row)

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2020-03-29 08:02:48 Re: could not determine encoding for locale "et_EE.UTF-8": codeset is "CPUTF-8" in pg_restore
Previous Message Michael Paquier 2020-03-29 07:19:10 Re: PG12 autovac issues